Skip to main content

Notifications

Community site session details

Community site session details

Session Id : Pq/QLs2ksC2wfQUprxCs0F
Power Automate - Building Flows
Unanswered

Forms to Existing Excel Document

Like (0) ShareShare
ReportReport
Posted on 4 Aug 2020 20:33:07 by

Hello,

 

I'm currently creating a flow that upon filling out a Forms document, a SharePoint list item is created to document the response, it is then sent to the supervisor of the requester for approval/denial, if approved the responses are saved as a line item in a new Excel table to be reviewed by superiors. 

 

What I need to happen is instead of creating a new line in the new excel document, is when approved, it creates a new line in an existing excel document (that is edited weekly by users) and is added to a specific section of the document, let's say by location, so that location will have a new line submitted based on the responses in the form. 

 

Is this possible within the limits of Power Automate? 

  • JohnAageAnderse Profile Picture
    1,986 on 21 Aug 2020 at 05:35:03
    Re: Forms to Existing Excel Document

    Hello @Anonymous 

    In your action for Add a row into a table, in the Table field, in the drop down list, choose the Enter custom value. This will allow you to use a Dynamic property instead, for example from a variable.

    Flow.JustinL1.Add row to a table.table name.jpg

    If your Excel table names are the same as the Location value you get from the Form, then you can use the Location value as the table name.

    Otherwise you need to translate your Location value into a table name as I mentioned previously.

    Kind regards, John

  • Community Power Platform Member Profile Picture
    on 20 Aug 2020 at 16:14:24
    Re: Forms to Existing Excel Document

    @JohnAageAnderse 

     

    Here is what I have so far. I'm connecting the sharepoint list item to the form item, but how would I connect it to the table to filter out which sheet it goes on?

     

    112233
    44

  • JohnAageAnderse Profile Picture
    1,986 on 20 Aug 2020 at 06:09:55
    Re: Forms to Existing Excel Document

    Hello @Anonymous 

    With a location code from the Form, you should be able to identify the Sheet and the Table in the Excel file, in which to add a row.

    Try to implement one or more expressions that will do the translation from location code to Sheet and Table. For examble by using lookup lists.

     

    Example scenario:

    1) Form is submitted

    2) Get items from the list "Location to Sheet and Table" where (Filter Query) Location code eq Form location code. Should only return one item!

    3) If none or more than 1 found, error situation, inform someone to look into this as it shouldn't happen! Terminate flow!

    4) Loop (apply to each) through each item (one) from step 2) and do:

    4.1) Add row to Excel file in Sheet (from step 2) in Table (from step 2)

    ...

     

    Kind regards, John

  • Community Power Platform Member Profile Picture
    on 19 Aug 2020 at 20:26:50
    Re: Forms to Existing Excel Document

    @JohnAageAnderse Hello,

     

    Thanks for your response! 

     

    Currently the project is on pause because there are other projects in the pipe that are priority so I have some time to diagnose this. 

     

    So let's say in the Form there is a location code that is selected as a choice, and each sheet is separated by location, could we write an if then statement in Power Automate to send it to the location code that was selected in the Form? 

     

    Does this make sense? 

  • JohnAageAnderse Profile Picture
    1,986 on 19 Aug 2020 at 07:28:16
    Re: Forms to Existing Excel Document

    Hello @Anonymous 

    Assuming that the Excel file contains a sheet for each location, then yes, you could use Power Automate to add rows to the table in each sheet.

    Did you manage to make a solution for this or are you stuck somewhere?

    Kind regards, John

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Building Flows

#1
Churchy Profile Picture

Churchy 6

#2
Chriddle Profile Picture

Chriddle 4 Super User 2025 Season 1

#2
stampcoin Profile Picture

stampcoin 4

Overall leaderboard