Forum Discussion
Flow update SharePoint list B based on Lookup column value in list A on Item Created
I have two lists A and B. List A has a lookup column to associate a record with a record from list B. When a record is created in list A I need to updated a Status column in list B. I've started...
I'm having the same problem. I've tried using Compose, but I get stuck with an array, rather than just the value and I can't get any further. I feel like I'm nearly there, but can't make the final leap.
Posts/Pages I've tried to use as reference:
- https://powerusers.microsoft.com/t5/General-Flow-Discussion/How-to-filter-the-array-to-get-single-item/td-p/14981 (example of Compose)
- https://powerusers.microsoft.com/t5/Building-Flows/Get-access-to-single-element-of-array-outside-of-loop/td-p/34844 (My situation isn't a loop -- I don't think -- but thought it might lead somewhere)
- https://powerusers.microsoft.com/t5/Building-Flows/how-to-get-sharepoint-lookup-list-value-in-flow-email/td-p/11800 (the solution near the bottom looks like how I would expect it to work, but it's not working for me)
It also feels like we can't be the only people trying this. Anyone?