Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Excel Get Row Key Values from Power APP


I have created an App that stores data in excel. 

It adds a row and assigns it "__PowerAppsId__".

How can I match the Key-Value below with the above __PowerAppsId__?

I don't want to ask power app, I want it to be dynamic



Resolver II
Resolver II

Most likely you will need to create a variable in power apps and pass the name to power automate.

see the link here how to pass arguments to power automate.

Or you can use try using the expression TriggerBody() to get the cryptic header information from the Power app trigger. Then maybe use JSON to get what you want out of it.

This is how I tested it.

I used text inputs to and passed that to the flow using a OnSelect method tied to a button. (In Power App)

Screenshot 2020-12-02 002526.png

Took a couple times, for some reason, updating the flow and updating the power app to get them in sink. Eventually it worked.

Screenshot 2020-12-02 003011.png



Helpful resources

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Users online (2,835)