You’re offline. This is a read only version of the page.
Hello,
I am making this flow but i have troubles with the "list of rows present in a table"
What must i fill there for ID for the file/table?
Hello @frixel2 ,
if it's 2 different files each with their own table I'd do it like this:
Hello @frixel2 ,
'Key Column' is the column where Power Automate should search for a value. 'Key Value' is what value should it look for. It'll get the row where 'Key Value' is in the 'Key column'.
Using your screenshot, the 'Key Column' = Time and 'Key Value' = (8-3-2021 07:33:14) will give you row number 19.
This is a very quick and simple example of a Power Query. I have all the tables in the same sheet but they can be in different files or come from list or text file. It's very flexible. Basically what is happening here is I took the information from the first four tables and made a query that used key identifiers from each table to match it to corresponding data. I circled in the top left corner where to locate the Power Query in Excel. There are lots of resources like these forums for Power Query. Power BI uses some of the same functions so you can sometimes find information about them in Power BI forums.
Hi,
I tried every which way to get this to work and had no luck. I might suggest using Power Query instead as that is what I had to do in the end. You set it up to look at the files you want and just refresh it each time you open it. It unfortunately isn't a trigger that you can do.
I know that Dataverse has a Power Query function in it that you can have set to refresh on a time interval but my company prohibits access to that so I am unable to use it. If you can use it then it would be a great way to continually look at the folder you have and pull in the information you want for a summary. Power Query can also automate the formatting and equations you might have. I hope this suggestion helps even if it does point you in a different direction.
Hello @frixel2 ,
'List rows present in a table' wants the ID of the Excel file (the same ID you use in 'Get tables') and the name of the table. I guess your table is called Alert if you're trying to access the one you create in the step before.
#1
Michael E. Gernaey
497
Super User 2025 Season 2
#2
David_MA
436
Super User 2025 Season 2
#3
Riyaz_riz11
244
Super User 2025 Season 2
Share
Report
All responses (
Answers (
