Power Platform Community Forum Thread Details

Hi,

I am looking for a way to perform something similar to XLOOKUP in Power Automate.

I have a form in Power Apps and when I fill in the Unique ID of the person and click on the button, I would like to automatically fill in all the current information about this person. It should be a changes form, so that the HR manager can check the current info in the SharePoint list and fill in any changes.

So basically, I want the Power Automate to take the SharePoint list, filter is by ID and give the data from that row back to Power Apps.

This is how the flow should look like:

In this way "Get items" is working properly, but "Respond to a Power App or flow" is not working:

retrieving all the info about me

not getting ID and Legal Entity

I managed to solve this issue with Compose function for individual fields:

However, this solution works well for the Legal Entity + Name, but I need to get back all the info (which means 90 fields), so my question is: Is there any "shortcut" for this? How can I achieve this without creating 90+ Compose actions?

Thank you.

Kind regards,

Sara

Categories:

General topics