cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JackWren
Frequent Visitor

List rows present in a table - Dynamic Table

Hi everyone, 

 

I am currently working on a Flow where I need to list the content of an excel file that I receive by mail. I also format the data into a table. So far, so good but I need to list the rows present in that table for comparison with another (static) table. I can't seem to reference this dynamic table in the file field. Has anyone succeeded in doing this? 

 

JackWren_0-1655238554737.png

 

Thank you 

1 ACCEPTED SOLUTION

Accepted Solutions

Sorry for the delay, I was trying to understand what exactly HTTP requests were. 

I finally settled for compose steps to make the Flow dynamic.

View solution in original post

3 REPLIES 3
Pstork1
Dual Super User
Dual Super User

1) Create the file in your OneDrive in a specific location

2) Use Excel online to create a table in the file instead of doing it by running a script

3) Wait 10-15 seconds

4) You should now be able to read the table based on the information used in #2



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Join me at 365 and PWR EduCon in Chicago
EduCon Chicago 2022

eliotcole
Super User
Super User

You actually don't need to use tables if you just want to get all the data on the sheet, @JackWren.

 

You can just call a Graph endpoint using the Send an HTTP request action from the Office 365 Groups connector:

 

See my proposed solution, here.

Sorry for the delay, I was trying to understand what exactly HTTP requests were. 

I finally settled for compose steps to make the Flow dynamic.

Helpful resources

Announcements
Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (2,022)