Flow excel Get row Row id

(0) Share

Report

Posted on by Geert1

Hello,

I have an issue with the flow I want to create.

I want to create an flow when if there is a new row in excel(creaded by powerapps), then they should send an email to */which email selected*/, with the row details. See below, I already tried some thing.

When I Set by *Row id a code what is generated automatically by powerapps like "ZbdXon0O4ZY" (in the column "__PowerAppsId__" . Then the flow is working, but now I want only the last row when there is a new row add to the excel file.

So, I am searching for a solution, when there is a new row in excel, the flow should send an email.

Could you help me with this?

Thank you in advance

Ruurd

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

efialttes 14,756 on at

Like (0)

Report
Copy link

Link copied!

Hi
As a possible workaround, have yo tried to use "Get rows" action block instead, and take the last result? Since "Get rows" output is an array you can get it by applying last() function defined in https://docs.microsoft.com/en-us/azure/logic-apps/logic-apps-workflow-definition-language#functions
Hope this helps

Was this reply helpful? Yes No
Verified answer

v-xida-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @Geert1,

I don’t think the “Get row” action within your flow could achieve your needs. I agree with @efialttes’s thought almost, I have made a test on my side and please take a try with the following workaround:

Add a “PowerApps” trigger.

Add a “Get rows” action, specify File name and Table name.

Add a Compose action, Inputs set to following formula:

array(last(body('Get_rows')?['value']))

Add a “Apply to each” action, input parameter set to output of “Compose” action. Within “Apply to each”, add a “Send an email” action, To field set to following formula:

item()?['EmailAddress']

Subject set to following formula:

item()?['_PowerAppsId_']

Body set to similar formula as above.

Image reference:Note: The data structure of my Excel file as below:

The flow works successfully as below:

Best regards,

Kris

Was this reply helpful? Yes No
Pipi985 2 on at

Like (0)

Report
Copy link

Link copied!

The flow works successfully, but it's a manually triggered flow, can the flow be trigger automatically by adding the new row in excel?

Was this reply helpful? Yes No