cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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
Anonymous
Not applicable

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

7 REPLIES 7
Anonymous
Not applicable

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.. 

v-alzhan-msft
Community Support
Community Support

Hi @Anonymous ,

 

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.
yashag2255
Dual Super User II
Dual Super User II

Hi @Anonymous 

 

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!

Anonymous
Not applicable

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

Just wanted to say a quick thanks for this solution & confirming it still works as of posting this message. 

@jslsmithyx  Nice!! Yeah, its still a nice, good working trick! Regards from Costa Rica!

majorfriend
Helper II
Helper II

Thanks Alister,

I was also able to use your method to get this working, but I bypassed the Compose step.

 

So mine goes like this
SharePoint - Get file properties

SharePoint - Get file metadata (pass the file identifier from Get file properties)

Excel - List Rows (pass ID from get file metadata)

 

Then I was able to Apply to Each and go on with the rest of my flow.

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors
Users online (1,640)