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"

All responses (6)

Answers (0)

Praktikant 26 on at

Like (0)

Report

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

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

Like (0)

Report

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

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???
DeepakS 2,301 Most Valuable Professional on at

Like (0)

Report

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

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
Praktikant 26 on at

Like (0)

Report

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

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.
DeepakS 2,301 Most Valuable Professional on at

Like (0)

Report

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

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.
RobElliott 10,118 Super User 2025 Season 1 on at

Like (0)

Report

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

@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.