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

Community site session details

Session Id : 4c6smeWVqSl3QCTVHzxe5/
Power Platform Community / Forums / Power Automate - Building Flows / Flow to auto transfer ...
Power Automate - Building Flows
Unanswered

Flow to auto transfer data on a Table from Excel > Excel?

Like (0) ShareShare
ReportReport
Posted on 29 Aug 2020 03:50:05 by minniep 41

Is it possible to have a flow: Get Data Twice Daily from an Excel report and transfer the data to another Excel automatically?

 

Hi there,

 

I tried to search for templates or similar flow and yet have no idea if and how it can be done.

 

Background info:

We have a report built on this Excel: A Report, and one of the sheets inside collect customer data for AM and PM.

The PM data will replace the AM, and the AM of the next day will replace the PM yesterday.

We want to keep the file simple as it has lots of formulas and running on SharePoint.

So we need to store those daily AM and PM customer data in another place (eg. another Excel on SharePoint).

 

I would appreciate any suggestions.

I have the same question (0)
  • Pstork1 Profile Picture
    Pstork1 67,489 Most Valuable Professional on 29 Aug 2020 at 23:54:00
    Re: Flow to auto transfer data on a Table from Excel > Excel?

    If you put the new data in the Excel file using the following it will create new rows.

     

    Patch(datasource, defaults(datasource), {record values you want to save})

    ------------------------------------------

    Ignore this, its for Power Apps, not Power Automate.  For flows you will use the Update a row or Add a row actions.

     

  • minniep Profile Picture
    minniep 41 on 29 Aug 2020 at 23:35:55
    Re: Flow to auto transfer data on a Table from Excel > Excel?

    will the new data overlap? cover the data transferred earlier?

    also is there a way I can add a date and time before pasting the data?

     

    like I want the file storing the info looks like this:

    Aug 29AM  
    ID 1ChatReason 1Note
    ID 2ChatReason 2Note
    ID 3CallReason 3Note
    Aug 29PM  
    ID 10ChatReason 1Note
    ID 15CallReason 8Note
    ID 16ChatREason 2Note

    And the next day will just add on to new rows with new date and time with the data

  • Pstork1 Profile Picture
    Pstork1 67,489 Most Valuable Professional on 29 Aug 2020 at 22:23:15
    Re: Flow to auto transfer data on a Table from Excel > Excel?

    Then create a Flow with a Recurrence trigger and in the flow list the rows from the source Excel file and copy/update them in the destination Excel file. It should work. Just make sure to create a table in the destination file that you can update.

  • minniep Profile Picture
    minniep 41 on 29 Aug 2020 at 21:21:11
    Re: Flow to auto transfer data on a Table from Excel > Excel?

    minniep_0-1598736056062.png

     

    yes @Pstork1 , it does have the table

     

  • Pstork1 Profile Picture
    Pstork1 67,489 Most Valuable Professional on 29 Aug 2020 at 20:20:18
    Re: Flow to auto transfer data on a Table from Excel > Excel?

    I'm not sure it will be a problem, but I suspect it will be.  Power Automate only works with simple tables that don't have any additional formulas or calculations associated with them.  You'll have to try it to see if you can see the table when you attach to the Spreadsheet.

     

    To test, just create a flow with a manual trigger and then add a List Rows in Table action for ExcelOnline (For business).  In the settings point to your SharePoint site, the document library and the Excel file.  If you see the table in the list it should work.  if you don't then something about the table is preventing connection.

  • minniep Profile Picture
    minniep 41 on 29 Aug 2020 at 20:09:44
    Re: Flow to auto transfer data on a Table from Excel > Excel?

    Thank you @Pstork1 for replying to my inquiry.

     

    Yes it is already a table and no formula, but certain cells are set as list using the data validation.

    would that be a problem?

  • Pstork1 Profile Picture
    Pstork1 67,489 Most Valuable Professional on 29 Aug 2020 at 14:38:53
    Re: Flow to auto transfer data on a Table from Excel > Excel?

    A couple questions

    1) Does the source Excel file have the data you want to export in a table?  If not then the flow can't access the data

    2) Does the source table contain any calculations?  Flow can't access a table with calculated columns or cells containing calculations

     

    If the source data is in a table and that table has no calculations in it.  Then  you can create a recurring flow to copy the data you select to a different Excel file with an appropriate table.

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

News and Announcements

Welcome to the Power Platform Communities
Announcing our 2025 Season 2 Super Users!
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 986 Moderator

#2
stampcoin Profile Picture

stampcoin 699 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 577 Super User 2025 Season 2

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans