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
Super User
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
Super User
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

Super User
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

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020.

thirdimage

Flow Community User Group Member Badge

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

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 Flow Community Video Gallery!

Users Online
Currently online: 71 members 3,002 guests
Recent signins:
Please welcome our newest community members: