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

All responses (3)

Answers (1)

mills 18 on at

Like (0)

Report

Re: Last row in excel online to be used in the flow

Thank you, JohnAageAnderse !
Verified answer

v-alzhan-msft on at

Like (1)

Report

Re: Last row in excel online to be used in the flow

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.
JohnAageAnderse 1,986 on at

Like (1)

Report

Re: Last row in excel online to be used in the flow

Hello @mills

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

Kind regards, John