cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

List rows present in table dynamic content not appearing

Hello ,

 

Building the following flow where when a sharepoint file is created, an excel table is created in it, then this table should be listed. This works perfectly when testing the flow but the dynamic content of the list rows action is not appearing in further actions. 

 

This is my actual flow: 

image.png

As I just said, the dynamic content of list Rows present in a table doesn't appear. Even though when testing the flow the action does rettrieve a successful output with all the items of the table. So i don't know why does this values does not appear dynamically in further action.

 

I want this for populating a sharepoint list with this data. 

 

Any help or ideas would be so much more than welcome. 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Helper II
Helper II

Re: List rows present in table dynamic content not appearing

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. 

 

 

View solution in original post

4 REPLIES 4
Highlighted
Helper II
Helper II

Re: List rows present in table dynamic content not appearing

Might it be a way in which I can kind-of encapsulate the 'create table function', so that when doing the 'List Rows present in a table', I could just say here is the table that have just been created, instead of giving it a path for seaching for it again... Maybe somethng like this could help to solve the problem.. 

Highlighted
Community Support
Community Support

Re: List rows present in table dynamic content not appearing

Hi @LuisGuzman98 ,

 

Do you mean the column dynamic content in the table doesn't appear after the "List rows present in a table" action?

 

Since the excel table in created when the flow has run, so the flow couldn't parse out the column dynamiccontent after the "List rows present in a table" action, if you would like to create the rows in sharepoint list, you need the expression for get each column value and insert it in the sharepoint list.

1.png

The expression for each column should be :

items('Apply_to_each')?['ColumnName']
 
 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Dual Super User III
Dual Super User III

Re: List rows present in table dynamic content not appearing

Hi @LuisGuzman98 

 

I see that you are providing Dynamic content for the File attribute in the excel online actions. And in the List Rows action, you again have provided the file identifier as dynamic content and I am sure you must have provided the Table 1 as a custom value. 

 

Please note that a current limitation with the excel connectors is that the File attribute of teh actions need to be provided by clicking the folder icon and then navigating to the excel file location and select the excel file from the document library. This means that the excel file you want to access should already be present on the document library. And then for the List rows action, you need to choose from the tables that come in the drop down. 

 

Therefore, you cannot add or get nything from an excel file that you are creating within the flow itself as a direct action. 

 

Hope this Helps!

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Highlighted
Helper II
Helper II

Re: List rows present in table dynamic content not appearing

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. 

 

 

View solution in original post

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

Join the new Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (8,110)