cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
frixel2
Helper I
Helper I

Data from one table to another table

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?

 

2.png

8 REPLIES 8
tom_riha
Super User
Super User

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.

 



[ If I have answered your question, please Accept the post as a solution. ]
[ If you like my response, please give it a Thumbs Up. ]

[ I also blog about Power Automate solutions even for non-IT people. ]
asd2525
Helper I
Helper I

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. 

@asd2525 

 

Thanks for your answer.

Have you a example for me how and where to build the Power Query?

 

so far, Thanks

frixel2
Helper I
Helper I

Hi @asd2525  and @tom_riha 

 

I try it again but i don`t know what to fil by Key Column and Key Value.

Can you help me with this?

So far thanks.

 

1.png

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.

asd2525_0-1615564715959.png

 

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.



[ If I have answered your question, please Accept the post as a solution. ]
[ If you like my response, please give it a Thumbs Up. ]

[ I also blog about Power Automate solutions even for non-IT people. ]

Hi @tom_riha 

Oke, i understand that with the date but than i get one row.

What do do if i want all the rows of the table into a another file?

Hello @frixel2 ,

if it's 2 different files each with their own table I'd do it like this:

  • 'List all rows present in the table' from the File_1
  • 'Apply to each' (of the rows from File_1)
    • 'Add row into a table' to the File_2


[ If I have answered your question, please Accept the post as a solution. ]
[ If you like my response, please give it a Thumbs Up. ]

[ I also blog about Power Automate solutions even for non-IT people. ]

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,199)