cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
C_Mcbail
New Member

Update SharePoint List Item from an array of Lists

So I have 2 Arrays, one array of websites, and the other an array of lists that those websites contain.

Ex:
Websites Array:

C_Mcbail_0-1638560312605.png

List Array:

C_Mcbail_1-1638560424437.png

I use a nested for each loop, in order to enter each site and then loop through the lists I want to access in that site (this works perfectly fine it gets all the data and i can use it properly):

C_Mcbail_2-1638560505047.png

where the problem happens, is when I try put the data in the update item action. 

C_Mcbail_3-1638561567928.png

nothing happens when I put the data in the Item box... what exactly should i be using in there... is there a way to some how tell it to update [This_item(with_this_data)]? it seems like that's the case, if it's not why can i even get to this point. is dynamically updating like this a lost cause using SharePoint Lists?

 

1 ACCEPTED SOLUTION

Accepted Solutions
iltoningui
Super User
Super User

Hi @C_Mcbail 

 

You can use the "Send an HTTP Request to SharePoint",

check out this post from Anna Jhaveri

iltoningui_1-1638569703831.png

 

View solution in original post

2 REPLIES 2
iltoningui
Super User
Super User

Hi @C_Mcbail 

 

You can use the "Send an HTTP Request to SharePoint",

check out this post from Anna Jhaveri

iltoningui_1-1638569703831.png

 

close.... I've tried this method before. That works in a more... open environment... unfortunately because of the way the send HTTP request Accesses the data, the security parameters set with our version prevents it from accessing the designated SharePoint sites (even though I have ownership access) and I get an access error when using the send HTTP request. I might have been doing something wrong though so I'll certainly give it another shot

Edit: it seems i was using the Send HTTP Request wrong, I am quite the newbie with Power automate and URI's... thank you for giving me a nudge to try this out again as it finally seems to work!

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

New Process Advisor Capabilities carousel.png

Read the blog for the latest news

Read the latest about new experiences and capabilities in the Power Automate product blog.

PA Survey Carousel Image.png

We want to hear from you!

If you are a small business ISV/Reseller, share your thoughts with our research team.

Users online (2,314)