Send an HTTP request to Sharepoint to Update List Items

(1) Share

Report

Posted on by jdun

What I want to do is:

1. Trigger flow when Item is Created/Modified on a 'Projects' List

2. Condition that if "Job Status" is equal to "Lost Bid"

3. Choose that list's 'Link' column (which is the projects generated Team Site link)

4. Update a list within this new site called 'Products' to have the 'outcome' column of all items listed here updated to "Lost"

I can create this flow without any issues when I reference a 'Products' list specifically attached to a project site. However, I need to be able to dynamically generate which products list is being updated. I believe the "Send an HTTP request to SharePoint" is the correct method to do this, but I'm having troubles figuring out how I would build this portion of the flow as I'm new to REST API's.

Any help would be greatly appreciated.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

v-bacao-msft Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!

Hi @jdun,

Do you want to use Send an HTTP request to SharePoint to Update All Items of the 'outcome' column?

Please take a try with the following workaround:

The flow works successfully as below:

For more details on SharePoint http request, please refer to link:
https://docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/working-with-lists-and-list-items-with-rest

Please take a try and feel free reply if you need more help.

Best Regards,
Barry

Was this reply helpful? Yes No
jdun 8 on at

Like (0)

Report
Copy link

Link copied!

Hi Barry,

This works if I know the site address to the specific list I want to update. My issue is I need to dynamically generate which project site belongs to the updated "Lost Bid" project. Because I am dynamically generating the site address it is not finding any values for the list.

So in this step I have selected my Projects list and then created a variable for my new Site Address to my prj subsite using the created or modified items ID to dynamically generate which project site to reference. If the Job Status value is equal to "Lost Bid" for the item being created/modified then do Step 2, if not do nothing.

Step 2, I want to get the items from the project site that we dynamically generated into our variable, and reference it's Products list. From here we want to update the 'outcome' value in each item in the Products list to "Lost". So is there a way to iterate through the list items to update them without using the ID variable since it does not show up in the list due to the dynamic site address requiring an input?

Thank you,

Jeff

Was this reply helpful? Yes No
jdun 8 on at

Like (0)

Report
Copy link

Link copied!

@v-bacao-msft

Is there a way I can extract the ID from the Current Item array perhaps? Or at least a way to check if it is not null and increase an integer variable (not ideal but better than nothing)?

Was this reply helpful? Yes No