cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Dudditz
Level 8

Flow Update SharePoint Item

I have a scenario where I am updating many column values in SharePoint using the update item.  This occurs across 10 different SharePoint sites that all contain a unique library where the columns are being updates.  I have tried using variables and Ask In PowerApps to populate the Site Address and list name however not surprisingly the columns do not retrieve so you are stuck with hard coding the site and list name via the drop downs to return the available fields. 

Due to this I have had to create a switch and an update item action for every library which was a lot of work and results in a large amount of redundancy.  Is there a better way to do this where the update item can retrieve the columns and I can get this down to a single action?  Any ideas is appreciated.

 

case2.jpg

1 ACCEPTED SOLUTION

Accepted Solutions
Dual Super User
Dual Super User

Re: Flow Update SharePoint Item

Hi @Dudditz 

 

Site the site urls are dynamically provided you would have to use the send an http request to sharepoint to update your list item (post action) 

 

here is an example

https://powerusers.microsoft.com/t5/Building-Flows/Send-an-HTTP-request-to-Sharepoint-to-Update-List...

 

Regards,

Reza Dorrani

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

View solution in original post

4 REPLIES 4
Dual Super User
Dual Super User

Re: Flow Update SharePoint Item

Hi @Dudditz 

 

Site the site urls are dynamically provided you would have to use the send an http request to sharepoint to update your list item (post action) 

 

here is an example

https://powerusers.microsoft.com/t5/Building-Flows/Send-an-HTTP-request-to-Sharepoint-to-Update-List...

 

Regards,

Reza Dorrani

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

View solution in original post

Dudditz
Level 8

Re: Flow Update SharePoint Item

Hi Reza, to be more specific I am updating columns for a document set and folders.  I am starting with the Document set and while I have made progress researching the links provided I am getting an error.

 

"status": 400,
"message": "The property '__metadata' does not exist on type 'SP.Data.Shared_x0020_DocumentsItem'. Make sure to only use property names that are defined by the type.

 

Here is the flow send http request.  Any guidance on issues you see with my config is appreciated.

http1.jpg

Dudditz
Level 8

Re: Flow Update SharePoint Item

Thanks for all your help, its now working with the following action to update columns for both modern doc sets and folders.

 

update metadata.jpg

Dual Super User
Dual Super User

Re: Flow Update SharePoint Item

Hi @Dudditz 

 

Glad to know it worked out

 

Regards,

Reza Dorrani

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Helpful resources

Announcements
firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (4,067)