web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : ukYGP1u/rBCWr4g/mbhVCk
Power Automate - Building Flows
Unanswered

Add Rows in a table

Like (0) ShareShare
ReportReport
Posted on 16 May 2019 22:09:13 by 2,157

I have multiple excel files all named to suite a different site but have the same table structure.  I have a flow that:

 

1. When a new record is created in acognito form adds the data to a sharepoint list

2. Gets the dats from that list based on a filter that selects status and site (site comes from step one)

3. I then do a List Rows in Table matching excel file to the site.  This allows me to use a vraiable for the site in the file location box

4. It then removes any rows found in preparation for new rows:

 

here is my my problem

 

In building the Add Rows to table I get an an error as it requires an address to an actual table.  While the table does exist I need to address to refer to the excel file as a variable. The addrows does not like this part.  I guess it cannot use an empty varaible for designing.

 

Is there a possible solution?

  • Brad_Groux Profile Picture
    4,556 on 17 May 2019 at 04:36:56
    Re: Add Rows in a table

    @leyburn19 wrote:

    Thanks I am aware of the issues with excel (more by trial and error than anything else).  I have found ways to deal with most of them.  I do extensively use Sharepoint,  but I need to exract things to excel fo third partys who neeed that dat that way.  In this case it is trying to overcome the potential lockout issue for what will be rare occasions more than one site will access at the same time.


    Again, you can use an export to Excel after all of the data manipulation to a SharePoint list. I spent months trying to force Excel into doing what I needed it to do with Flow becuase of client requirements, it simply isn't worth the headaches. Now I tell my clients that Excel simply isn't an option for anything other than a data input source, I can't and won't use it for output. It's like trying to fit a square peg into a round hole.


    @leyburn19 wrote:

    I appreciate your time on this.  It would be great if there was a file in use check option in flow.  I have had a thought that I could do this by having a configure to run after process if the flow fails.  It likely only will fail based on file being in use.  


    If this is functionality you would like to see added to Flow or a Flow Template, please consider submitting it to the Flow Ideas page, where it can be voted on by other users, and tracked and commented on by the Flow team.

    The problem is fairly specific to Excel, because of how Excel's online services works. They run on top of SharePoint as it's own web-service due to the heavy lifting that Excel can do.

    SharePoint Lists and Cosmos DB are basically the future of Logic Apps because of their APIs, which greatly increases connectivity, performance and stability. 

    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!

  • leyburn19 Profile Picture
    2,157 on 17 May 2019 at 03:32:14
    Re: Add Rows in a table

    Thanks I am aware of the issues with excel (more by trial and error than anything else).  I have found ways to deal with most of them.  I do extensively use Sharepoint,  but I need to exract things to excel fo third partys who neeed that dat that way.  In this case it is trying to overcome the potential lockout issue for what will be rare occasions more than one site will access at the same time.

     

    I appreciate your time on this.  It would be great if there was a file in use check option in flow.  I have had a thought that I could do this by having a configure to run after process if the flow fails.  It likely only will fail based on file being in use.  

  • Brad_Groux Profile Picture
    4,556 on 16 May 2019 at 23:53:01
    Re: Add Rows in a table

    @leyburn19 wrote:

    I don't belive that will work either as the table will not exits till runtime for the add rows ro refer to.  It is a runtime proble.  I tried hard putting the required data into the variable as a default but this would work either.  I need 29 diffent table names for this solution (thankfully I could create them with flow).    I think my only solution is to have branches for each one,  or use conditions.  This would not be a problem but potentially I could have more than one site accessing files at teh same time so I see separation is required

     

    addrow.PNG


    I would not recommend Excel for this workload. I strongly suggest you utilize SharePoint lists, and then export to Excel as needed. The Excel connectors have severe issues and limitations that you'd most certainly encounter with your chosen design. Including, a limit of 100 API calls per 60 seconds, and file lockouts of 6-12 minutes any time an Excel file is accessed.

    For these reasons, most Microsoft Flow experts overwhelmingly recommend avoiding Excel if at all possible - because it is nearly impossible to know if/when a file lockout will occur on spreadsheets that are accessed frequently, or by multiple Flows, accounts, or users. 

    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!

  • leyburn19 Profile Picture
    2,157 on 16 May 2019 at 23:18:04
    Re: Add Rows in a table

    I don't belive that will work either as the table will not exits till runtime for the add rows ro refer to.  It is a runtime proble.  I tried hard putting the required data into the variable as a default but this would work either.  I need 29 diffent table names for this solution (thankfully I could create them with flow).    I think my only solution is to have branches for each one,  or use conditions.  This would not be a problem but potentially I could have more than one site accessing files at teh same time so I see separation is required

     

    addrow.PNG

  • Brad_Groux Profile Picture
    4,556 on 16 May 2019 at 22:53:40
    Re: Add Rows in a table

    Without a detailed screenshot, I'd suggest adding a Create a table step using a dynamic parameter for the name. Then call that table dynamically in the Add rows step. 

    If you could provide an expanded screenshot of your Flow and steps, and of any detailed error messages you're receiving we could likely better assist you.

    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!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2