Hi,
Not sure if this is the correct way but somehow I figure how to make the magic happen.
This only can happen if you always upload an excel file with the same format, same number of columns for example.
1. Fill the column names for your table when you create it.
2. Then I used the get tables action and called the same file I called when creating the table
3. I set an apply to each to the value of the get tables action developed before.
(Here's the tricky part)
4. I gave some chance for a file uploaded and converted to table in my document library to be recognized by my flow (You could restart the application maybe), when recognized I found it in the 'File' slot of the list rows action and as well as the table in it in the 'Table' slot.
5. Using this non dynamical parameter I designed My flow as how I need it, and I was able to call the dynamic variables contained in the table, (all the column headers of the table).
6. After this once my flow was working, so I changed the inputs for the 'List rows present in Table function' for the File slot. I once called again the file identifier dynamic variable from sharepoint and used the name dynamic variable of the get table function in the Table Slot.
7. Deleted the excel document from my sharepoint, test it, uploaded another file an voila, it worked.
I think the solution is tricking flows like kind of giving him a static value of file and table, once recognized develop the flow, once everything is working chamge the static values for dynamic values.
As I said at the start, I think this just work for documents that are always the same (the column names and number of columns always the same), very standardized format.
