Skip to main content

Power Automate to Access SharePoint Recycle Bin


Introduction: Access Recycle Bin of SharePoint using Power Automate.

Steps:
  1. Actions: select "Send an HTTP request to SharePoint"

SharePoint Search connectors and actions Triggers Actions SharePoint Resolve person SharePoint Send an HTTP request to SharePoint SharePoint Set content approval Status SharePoint Set hub site join status to pending SharePoint Stop sharing an item or a folder SharePoint Copy file (deprecated) SharePoint Delete attachment SharePoint x O O


  1. Enter the below details:
Site Address: Select your site address from the list.
Method: GET
Uri, Headers: Refer the screenshot below.
Pls. Note: Trigger used was When a File is Deleted- SharePoint Connector.
s Send an HTTP request to SharePoint O • Site Address • Method Headers Body eq datetime• Time deleted x Deleted by x ' and and DeletedByName eq • Filename with x Accept Enter key Enter request content in 'SON application/json Enter value

  1. Select Action "Parse JSON"
Data Operations Search connectors and actions Triggers Actions co mpose Data Operations Create CSV table Data Operations create HTML table Data Operations Filter array Data Operations Join Data Operations Parse JSON Data Operations Data Operations x

  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"]
}}}}
Parse JSON Body X • Content • Schema "type": "object", "properties" : "odata. metadata". "type": "string" "value": " items" : Generate from sample




Labels:

Comments

Post a Comment

Popular posts from this blog

Get Business Process Flow Stage Id using API Query

Developers may need to get the stage ids of BPF stages in order to use in power automate or JS. Here is a blog that will help. API Query-   https:// CRMURL.dynamics.com/ api/data/v9.0/processstages?$select=stagename&$filter=processid/workflowid eq BPFGuid   Eg: 1) Get the GUID of  Business Process Flow whose stage details you need. Replace below Query with Your CRM URL and BPF GUID. https://Test130.crm.dynamics.com/ api/data/v9.0/processstages?$select=stagename&$filter=processid/workflowid eq 9128E4D1-1234-4852-ABD0-A63A6ECA5C5D   Output:    The output will provide the stage name and ID.
Post a Comment
Read more

Dynamic, Multiple Recipients of D365 Email in Power Automate

When t he 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.    In above screenshot we can see the Activity party attribute is populated for single value and is static to only a single entity record GUID.   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. Example: get all users whom you need to send email, append the user id to array. pass this array as input to the Activity Parties field in create an email record.  
Post a Comment
Read more