Hello Friends,
I'm currently working on a Power Automate conundrum and could use some help.
The goal of this workflow is to see if a unique id is found within three columns on a second SP list. If the unique id is found within any of those three fields, then I want it to update item on the first SP list with a Yes, and a No if it's not found.
I'm starting out with get all items from one SP list, and then get items from a second list. On the second get items I have a filter query: (Title eq'Related1 value') or (Title eq'Related2 value') or (Title eq'Related3 value').
Title is a unique identifier (4 digits)
Related value 1, 2 and 3 are Look up columns that pull in the unique ID for a related item (could match the title column).
Issue starts here: Then the compose function I've been using is (unfortunately, this doesn't work with an array) :
length(body('Get_items')?['value'])
It then passes to a condition where the outputs from the compose is greater than 0 then yes / no
Thanks
