Unanswered

Problems with Order by in List rows from Excel

(0) Share

Report

Posted on by chsmebye

Hi,

Im trying to make a flow where I need the row with highest ID (column in a table). I use the "List rows present in a table" operation.
In the advanced options it looks like this:

The problem is that the "order by" does not order anything for me. I always get the first Id (1) for the table. The table looks like this:

In this case i want the row with id 6. If I remove the "top count" the whole list is presented.

What have I missed?
Please help 🙂

- Christian

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

creativeopinion 10,502 Super User 2025 Season 2 on at

Like (0)

Report

@chsmebye
Can you add a Compose action after your List Rows Present in a Table action and remove the text in the Order By field and leave the Top Count to 1 and run a test? Upload a screenshot of your outputs. I just ran a test on my end and I didn't have an issue with the order by.

I'm assuming there might be an extra space or hidden character in your Id header. If you take a look at the outputs, please confirm the text for your Id column between the double quotes. For my demo, my text is ID.

If you see an extra space in your text such as "Id ": or "Id ": you would have to either a) remove the extra spaces in your header or b) adjust your Order By ODATA query to match the text exactly as it appears in red between the double quote marks.

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Watch my tutorials on YouTube
👉 Tips and Tricks on TikTok

Was this reply helpful? Yes No
Verified answer

chsmebye 13 on at

Like (0)

Report

Thanks for reply @creativeopinion !
I have work with this and found out that i cant use formulas in the Id column. When I user "raw" numbers it worked!

But!
I think that when the flows triggers it opens the Excel file and do not find the latest result from the form. I tried this by send in a new Form and the flow gets the second newest row.
Example:
- sends in Form that gets Id 10
- the flow gets Id 9
Tried also with a delay so Im sure that the Form reply is in the Excel file, but no sigar.

Thanks anyway! I need another approach.

Was this reply helpful? Yes No
creativeopinion 10,502 Super User 2025 Season 2 on at

Like (0)

Report

@chsmebye Do you have another flow that is inserting data from the Form into your Excel table?...

Was this reply helpful? Yes No
chsmebye 13 on at

Like (1)

Report

@creativeopinion
No other flow, but formulas. Like VLOOKUP etc. and the cell with a VLOOKUP will not work with ORDERBY.
The solution I ended up with was to just have a mapping table in excel and just make the object in the flow.

Was this reply helpful? Yes No