Answered

Last row in excel online to be used in the flow

(0) Share

Report

Posted on by mills

Given a flow which grabs info from a Microsoft Form, pushes it to an excel sheet (online-OneDrive), then needs to get the last row from the excel sheet to send an email, the following step seems to break down:

The error I get is the same as cited by the other users. The Compose does not generate the JS0N.

https://powerusers.microsoft.com/t5/General-Power-Automate/How-to-get-last-row-values-in-an-excel-using-flows/m-p/397192/highlight/false#M39377

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (1)

mills 18 on at

Like (0)

Report
Copy link

Link copied!

Thank you, JohnAageAnderse !

Was this reply helpful? Yes No
Verified answer

v-alzhan-msft on at

Like (1)

Report
Copy link

Link copied!

Hi @mills ,

You need to add the expression in the Expression window when add the dynamic content as @JohnAageAnderse said.

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
JohnAageAnderse 1,986 on at

Like (1)

Report
Copy link

Link copied!

Hello @mills

Please make sure you enter the expression in the Dynamic content panel in the Expression field!

Kind regards, John

Was this reply helpful? Yes No