Flow Designer - How to ask approval based on "Look Up Records"

[Hiago]

Hello!

I have a catalog item field (list collector) where the user needs to select some screens they want to access. Each of this screens have a user associated as Approver/Manager.

We've created a table to associate each selected requested screen to a RITM, and they looks like this:

So, in the flow, we have an action to look up all the records (screens) associated to the active Requested Item in the Flow, like this:

Then, we have an action to ask for approval of managers of this screens, that are associated in the main "Screens" tables. But, it's not possible to enter down in the records to pick up the manager field inside this table:

Note that if we use the action "Look Up Record", we are able to get the approver based on the record found, but for this case, we might have multiple approvers, so the look up record will only return one record, and doesn't work for us.

Has anyone faced to this limitation and managed to workaround it?

Thanks!

[Ankur Bawiskar · Accepted solution]

@Hiago 

Hi,

you can use inline script using f(x) which is present for Ask for Approval action

have a check on this and follow all the steps

Scripted Approvals in Flow Designer with Flow Variables

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards
Ankur

[Hiago]

Thank you very much, @Ankur Bawiskar!

That's exactly what I was looking for. It's working now as expected.

For anyone who'd like to know, this is how our approval script looks (after following all the steps in the link provided):

[win b]

@Ankur Bawiskar would this also work if the field is Look Up Selectbox inside the MRVS