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?
