use flow to update various sharepoint group sites

[Leo_NYC]

Hello there....I'm stuck on how to solve an update problem.  We have a main sharepoint site that lists our projects and statuses for each customer.  We have 4 customers for which we have set up their sharepoint site on our tenant.  These Customer Sites have job lists for which we have set up individual flows to copy updated information from our main site to their individual job lists.  We do not copy over all of the columns, rather only a few of them for which the customers are interested in seeing.

We created an update flow for 3 of the customer sites which run great, however as our list of sharepoint sites grows it is not feasible to run each flow individually.  

We are trying to create one flow that will update the individual Customer sites.  To do this we have created a master list of those Customers for which we can iterate through and filter out pertinent projects from the master job list. 

We then either create a new item or update and existing item in the Customer's job list.  The problem we have is that the Create Item action uses a dynamic site URL, and a static list name (the lists all have the same name).  Flow cannot resolve the site address until run-time.   In some cases the the *item parameter manifests itself during design-time where I have tried to put int "item as a record" (which creates a blank item in the ProjectList), and I tried putting in the "ID" of the item which hangs up the flow forever.  Also we do not want to move over all the columns from the main job list, only about six of them.

I could always make a separate flow for each customer sharepoint site but that becomes a maintenance headache if there are updates.  Has anyone tried doing this successfully?

[v-litu-msft · Accepted solution]

Hi @Leo_NYC,

What you want to do couldn't do in the Create item action, you could consider using the Send an HTTP request to SharePoint action.

Here is the request API to create a list item:

https://docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/working-with-lists-and-list-items-with-re...

And this is an example of how to create it:

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[NeilMcC1]

Hi Lin,

I tried the sharepoint http request example you shared, however I'm getting an error "A type named 'SP.Data.****ListItem' could not be resolved by the model. " Strangely, when I use a list names 'Test' the request succeeds, but for any other list name it fails. Any idea what's going on?

Thanks