Power Automate: Creating Bulk Document Set in SPO and Update DOC Set Metadata Columns using Excel

(1) Share

Report

Posted on by CU25041925-0

I created the Power Automate flow as:

Trigger: Manually trigger a flow
Action: Get file content (SharePoint)
List rows present in a table (Excel Online (Business)
Apply to each
(Inside "Apply to each"): Created new folder
(Inside "Apply to each"): Update file properties

Refer to above Pics, Folders were created as per Excel and folder names were also added as per Key Column. But SPO Folder's Metadata columns are not updated from Excel sheet.

Could anyone guide me about this flow? Thank You.

Categories:

Building flows

I have the same question (0)

All responses (1)

Answers (0)

Expiscornovus 33,830 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @CU25041925-0,

I have used Send an HTTP request to SharePoint action in the past to meet this requirement. You can use a PATCH request for this. I shared a blog about this:

https://www.expiscornovus.com/2023/11/13/create-document-set-with-metadata/

Below is the same example

{ "fields": { "Order_x0020_Status": "Proposed", "Customer": "Fabrikam Travel|2fe1fa4e-f9c5-4ea6-8d65-7d934d5ed50c;", "Product_x0028_s_x0029_": "SharePoint Online|7c932ee6-c55a-429b-9b06-3b72690ed3c9;" }, "contentType": { "id": "@{variables('ContentTypeId')}" } }

Happy to help out 😁

I share more #PowerAutomate and #SharePointOnline content on my Blog, LinkedIn, Bluesky profile or Youtube Channel

Was this reply helpful? Yes No