How to give out a cell from excel by using Automate Flow?

(0) Share

Report

Posted on by Praktikant

Hey,

my Problem is using Excel through Power Automate Flow.

To get the cell i need to know the row ID. I already made a grid in Excel with Headlines, so the coloumn is not a problem anymore.

So can someone tell me where i can get the row ID from?

"status": 404,

"message": "Es wurde keine Zeile mit der ID \"name1\" gefunden.\r\nclientRequestId: 9aad4bc1-05d4-4aaa-87d2-78ffdff22ec7\r\nserviceRequestId: aad20736-1882-46d2-adf1-b84a9125f613;a0239ad9-4ad9-4257-8ad6-ae5ad3616990",

"error":

"message": "Es wurde keine Zeile mit der ID \"name1\" gefunden."

"source": "excelonline-ne.azconn-ne.p.azurewebsites.net"

Categories:

Using flows

I have the same question (0)

All responses (6)

Answers (0)

RobElliott 10,323 Super User 2025 Season 2 on at

Like (0)

Report

@Praktikant you can't directly get the row ID, you would need to have a column in your table and each cell in that column holds a unique value. You can then Get the row cells data based on the unique value.

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

Was this reply helpful? Yes No
DeepakS 2,301 Most Valuable Professional on at

Like (0)

Report

Hi @Praktikant

Get Rows action needed Key Column and Key Value to retrieve a row from excel, i think you are getting error because data that your passing in Key value field does not exists.
use following expression:

——————————————————
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
Praktikant 26 on at

Like (0)

Report

Thanks for your answer, but i dont know how to use this function. Could you please send the function as an answer,
so i can copy paste it inside my flow.

Was this reply helpful? Yes No
DeepakS 2,301 Most Valuable Professional on at

Like (0)

Report

Hi @Praktikant

items('Apply_to_each')['Name']
Make sure you use the correct column name and loop name(apply to each) , and paste this in expression.

——————————————————
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up

Was this reply helpful? Yes No
Praktikant 26 on at

Like (0)

Report

It didn't helped me. There is the same error egain. I Need a unique row key like a column Headline. Do you know if it is possible to make row Headlines or somthing like that???

Was this reply helpful? Yes No
Praktikant 26 on at

Like (0)

Report

thanks for your answer.
yeah i know but how do i get this uniqe value??
thats my Problem i guess.

Was this reply helpful? Yes No