How can I get a last row of Excel file on OneDrive ?

(0) Share

Report

Posted on by yoshihirok

1,724

I want to get a last row values of Excel servey file to Power BI Service streaming dataset by my flow.

My question is how can I get a last row of Excel file on OneDrive.

My scenario

Trigger: OneDrive - When a file is modifed

** Get a last row of Excel Servey file.

Action: Power BI - Add rows to a dataset.

and Power BI Service reports survey result to dashboard in real-time.

Regards,

Yoshihiro Kawabata

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (1)

abm abm 32,985 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

rHi @yoshihirok,

Try to use an excel formula or VBA to push the last row to a defined new worksheet. Flow need to read this worksheet which will contain only one row.

Thanks

Was this reply helpful? Yes No
yoshihirok 1,724 on at

Like (0)

Report
Copy link

Link copied!

Hi @abm, thank you for your reply.

Excel include Formula and VBA cannot use from Microsoft Flow's "Exce" service, I think.
I will try some way.

Regards,
Yoshihiro Kawabata

Was this reply helpful? Yes No
Verified answer

yoshihirok 1,724 on at

Like (1)

Report
Copy link

Link copied!

I can get last row of Excel file by "Compoase" and "@last(outputs('rows').body.value)"

Regards,
Yoshihiro Kawabata.

Was this reply helpful? Yes No
faustocapellanj 1,662 on at

Like (0)

Report
Copy link

Link copied!

Hi Yoshihiro,

I know this post is from February, but I am trying your solution, but it's not working for me. When I try your solution, I get the following error message when I try to save the flow:
The template validation failed: 'The action(s) 'rows' referenced by 'inputs' in action 'Compose' are not defined in the template.'.

If you or anybody else have gotten this to work, is there any chance more details can be provided on how this worked?

Thanks.

Was this reply helpful? Yes No
faustocapellanj 1,662 on at

Like (0)

Report
Copy link

Link copied!

Hello everyone,

I posted a message last night about the solution provided by @yoshihirok and something was confusing, but I was able to figure it out. On his Compose formula to get the last Excel row, he has ('rows'), but I just figured out that's the name of the Flow steps that retrieves the Excel rows. This is the expression that worked for me: "@last(outputs('Get_rows').body.value)".

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello @yoshihirok and @faustocapellanj,
How did you use the last row in next step of this flow? Did you perform any action like sending email or approval for just the retrieved last row? Can you share the screenshot of your solution?

Thanks!

Was this reply helpful? Yes No