Accessing SharePoint Recycle Bin using Microsoft Flows

 Introduction:

This blog provides steps to follow in order to access the SharePoint Recycle Bin in MS Flows 

 

Steps:

  1. In Actions, select "Send an HTTP request to SharePoint"

 

 

 

  1. Enter the below details:

Site Address: Select your site address from the list.

Method: GET

Uri:_api/web/recycleBin?$filter=DeletedDate eq datetime'Time Deleted' and DeletedByName eq 'Deleted by' and Title eq 'Filename with extension'.

Headers: 

Accept

application/json

Pls. Note: The parameters marked in yellow are  taken from the trigger "when a file is deleted in SharePoint"

Graphical user interface, text, application, email Description automatically generated

 

  1. Select Action "Parse JSON" 

Graphical user interface, text, application Description automatically generated

 

  1. In parse JSON, the content is the body of HTTP Response

Enter the below Schema:

{

"type": "object",

"properties": {

"odata.metadata": {"type": "string"},"value": {"type": "array","items": {"type": "object",

"properties": {"odata.type": {"type": "string"},"odata.id": {"type": "string"},

"odata.editLink": {"type": "string"},"AuthorEmail": {"type": "string"},"AuthorName": {

"type": "string"},"DeletedByEmail": {"type": "string"},"DeletedByName": {"type": "string"},

"DeletedDate": {"type": "string"},"DeletedDateLocalFormatted": {"type": "string"},

"DirName": {"type": "string"},"DirNamePath": {"type": "object","properties": {

"DecodedUrl": {"type": "string"}}},"Id": {"type": "string"},"ItemState": {"type": "integer"},

"ItemType": {"type": "integer"},"LeafName": {"type": "string"},

"LeafNamePath": {"type": "object","properties": {"DecodedUrl": {"type": "string"}}},

"Size": {"type": "string"},"Title": {"type": "string"}},"required": [

"odata.type","odata.id","odata.editLink",

"AuthorEmail","AuthorName","DeletedByEmail",

"DeletedByName","DeletedDate","DeletedDateLocalFormatted","DirName","DirNamePath","Id",

"ItemState","ItemType","LeafName","LeafNamePath","Size","Title"]

}}}}

Graphical user interface, text, application Description automatically generated

 

 

Sample Output:

Graphical user interface, text, application, email Description automatically generated

Comments

Post a Comment

Popular posts from this blog

The supplied reference link is invalid Error in Cloudflows

Image
  Introduction :  When we add a new row in dynamics CRM, we might end up using the lookup data reterived in previous action. There might be times when the previous record has returned a null. In such cases we get the error-    {    "error" : {      "code" :  "0x0" ,      "message" :  "The supplied reference link --  contacts () -- is invalid. Expecting a reference link of the form /entityset(key)."   } }     For this example; I was creating a new record and wanted to use the Account and its contact as lookup in my new record. The reterived Account did not have a contact and so my flow failed.   Solution :  Use the below if condition, if(empty(triggerOutputs()?['body/_primarycontactid_value']), ' ', concat('contacts(',triggerOutputs()?['body/_primarycontactid_value'],')'))   In this conditio...
Read more

Set Dynamic Recipients of D365 Email in Power Automate

Image
  Introduction :  We can send email using D365 Connectors in Power Automate. To know about how to send emails, refer my blog: https://www.cloudfronts.com/send-d365-email-using-power-automate/   In this scenario where, the activity parties (TO, From, CC) ae static, we can easily send emails. However here is how we can set the activity party dynamically on the Email.       Solution: The create a record of Email message is as below, here we are entering the attributes of activity party, by clicking on "Switch to Input entire array" You will get the Array format, the participationtypemask is TO, FROM,CC while the partyid@data.bind is the email address. Now all you need to do is create a dynamic array, You can use append to array variable action to create an array with participationtypemask as per your requirement, pass this array as input to the Activity Parties field in create an email record.  
Read more

Retrieve Email Recipients (TO, CC, BCC) in Cloud Flow

Image
  Introduction: When we trigger a flow on Email Activity or retrieve email activity. However that does not provide us the recipient details of the email. Recipient details are stored as part of Activity  Party.    In this blog, we will understand how to retrieve the Email Recipients from the activity party of the email.   Solution: From Email messages you will get activity party. Reterive Activity Parties of that ID. Use Filter Array Action to get only the type of recipient you need. If you do not know the Partition type mask, you can check the output of List rows and read the formatted value. The Filter array output will you party type and party ID. In my case the party type was Users so I have used Party ID as input to get the User record.   Based on your party type and requirements, you can make use of the party id value which basically is your recipients 
Read more