
Announcements
My workflow is triggered from a MS Form where the value DIVISION is needed to determine which SharePoint site a new folder is created and then updated.
IF Division = Miami, THEN Site Address = contoso.sharepoint.com/sites/Miami
AND List or Library = Projects
I don't think this part is an issue. The issue is the following step where I want to Update Item with various values such as FirstName, LastName, Address, Client, etc.
In order for PowerAutomate to give me the values (SharePoint columns) I want to fill, it needs to know the exact address and library before it displays the fields for FirstName, LastName, etc. Without it knowing where I'm directing it, there are no fields for me to enter the values.
The obvious solution is to use the Condition IF Miami then Update Item contoso.sharepoint.com/sites/Miami and nest that as far as I need (IF NO, then IF New York then Update Item contoso.sharepoint.com/sites/NewYork; IF NO, then IF Chicago then Update Item contoso.sharepoint.com/sites/Chicago, etc) which in each step would present the values in the SharePoint list.
I'm really trying to avoid using a Condition as this gets more complex as we add more divisions to our organization. I also have other flows such as adding a Channel to a Team and a Bucket to a Planner.
So, I'm looking for a vertical solution that's as streamlined and nimble as possible. I just can’t conceive of a way to dynamically populate the ‘Update Item’ action so that it generates the fields I need to update.
Given that I know I want to fill out the fields FirstName, LastName, etc., in contoso.sharepoint.com/sites/Miami/Projects/[ItemID] is it at all possible to hard-code Update Item?