Get a row in Excel: No row was found with Id 'xxxxxxxx'

(0) Share

Report

Posted on by Pochoide

111

Hi,

I am having some trouble trying to get a row from an Excel table. It says that no row was found with a certain Id but I´m pretty sure that the row exists, also when I use the action List row present in a table with an ODATA filter, it finds the expected row.

This is my flow:

And these are the results:

Can someone explain what´s going on?

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

v-chengfen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Pochoide ,
Sometimes there are unexpected errors.

Please try to remove 【Get a row】, add it again, and test again.

Best Regards
Cheng Feng

Was this reply helpful? Yes No
Verified answer

Pochoide 111 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-chengfen-msft , thanks for your answer.

I tried that way many times, but still couldn´t get it to work. I solved the problem by deleting the Excel table and rewriting it, there was probably something wrong there. But I still don´t understand why the List rows present in a table action worked fine but the Get a row action didn´t.

Was this reply helpful? Yes No
chay0k 12 on at

Like (0)

Report
Copy link

Link copied!

I had such problem:
it can appeare because of unlimited rows in Excel table.
Seems, like power automate can't search data in such tables.
When I add down bounder:
Resize table from like($A:$B) value to like ($A$1:$B$4) - it starts work.

I hope these solutions work for you.

Was this reply helpful? Yes No