cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CrispExcel
Frequent Visitor

Excel Get Row Key Values from Power APP

Hi,

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

CrispExcel_0-1606811714385.png

 

1 REPLY 1
crowdjs
Resolver I
Resolver I

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

 

https://powerusers.microsoft.com/t5/Building-Power-Apps/Pass-data-from-PowerApps-to-MS-Power-Automat...

 

tutorial

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/using-logic-flows 

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (1,182)