Thursday, December 19, 2019

Accessing SharePoint Recycle Bin using Microsoft Flows


Introduction:
 This blog give the steps to access Recycle Bin of SharePoint using Microsoft Flows.

Steps:
  1. In 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




No comments:

Post a Comment

Save Populated Word Template Content in Variable Using Power Automate

Introduction : We had a requirement where based on switch case condition, we had to populate different word templates. Power automate A...