Help needed for a Select Step - How to get value from another list into the Select Step in my FLOW?

(0) Share

Report

Posted on by SueA

555

I have two SP LIsts:

Reviewers (Cols: ID (Integer), Reviewer (People Picker), Role (Single Line of Text)
Responses (Col: ID (Integer), ReviewerID (Integer), Question No. (Integer), Notes (Rich Text)

In my Power Automate, I have prior steps of Get Items step for the Reviewers list and then a Get Items step for the Responses list

Followed by a Select Step for the Responses List. (See attached).

For the matching IDs, I like to pull Role value from Reviewers list while I am selecting other values from the Responses list in my Select step.

Is it possible?

I tried the following in the expression Box for the ReviewerID - but it gives me an error:

If(
outputs('Get_items-Reviewers')?['body/value']?['ID']=
outputs('Get_items-Responses')?['body/value']?['ReviewerID'],
outputs('Get_items-Reviewers')?['body/value']?['Role'])

The Pop up message Box says: The expression is invalid.

Any idea is appreciated.

Thank you,
SueA.

Categories:

Building flows

Screenshot 2023-0...

I have the same question (0)

All responses (4)

Answers (1)

HenWang Microsoft Employee on at

Like (1)

Report

Hi @SueA ,

I am afraid this is not how select works. The select action can only do loop check for its own value. For this issue, you need to check whether outputs('Get_items-Reviewers')?['body/value']?['ID'] is equal to outputs('Get_items-Responses')?['body/value']?['ReviewerID'], which is not within the scope of select action. And you will need to use item()?['id'] to replace the outputs('Get_items-Reviewers')?['body/value']?['ID'] part as well.

Because select needs to loop each item inside its "From" value, which is the value dynamic content from one of your "Get items" action.

In this issue, to avoid the error notification, you will need to change the formula and the condition could only be compared with sure value instead of dynamic content.

Best Regards,
Hen Wang

Was this reply helpful? Yes No
Verified answer

Paulie78 8,422 Moderator on at

Like (2)

Report

It is possible but not super easy. Check out this blog post I wrote:

How to merge arrays with Power Automate

And also this one from @tom_riha :

https://tomriha.com/turn-two-arrays-into-one-through-a-shared-value-with-power-automate/

Hope this helps

Blog: tachytelic.net

YouTube: https://www.youtube.com/c/PaulieM/videos

If I answered your question, please accept it as a solution 😘

Was this reply helpful? Yes No
SueA 555 on at

Like (0)

Report

Hi Palulie78:
Thank you for the detailed explanation in the Blog as well as in the video. I am under time constraint and it is a bit challenging for me, as well.. For now, I have decided to denormalize my Responses List, add the Role Column and insert data along with other values via PowerApps. But, the process you shared is really genius and very well explained. Thank you for sharing your knowledge and skills with us.
Thanks,
SueA.

Was this reply helpful? Yes No
SueA 555 on at

Like (1)

Report

Thank you, HenWang:
I appreciate the explanation of the limitations of the Select Step in Power Automate and correcting my code regarding the ID. I did not know about those.
So, thank you.
SueA.

Was this reply helpful? Yes No