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 : 2sOP+JAh1V1JRvRwVZWG4i
Power Automate - Building Flows
Answered

when user add or modify data in excel which need to added in another excel file -in series, no old data can delete

Like (0) ShareShare
ReportReport
Posted on 5 May 2022 10:41:37 by 53

when the user add or modify data in excel which need to add in another excel file -in series, no old data can delete.

 

I need a solution that can help me to add data automatically from one excel to another. Data needs to add in excel in series. like every week I add data in Excel1 and that data can automatically be added in excel2. Not update.. i need every week data in one file.

 

 

Please help me to make a flow in Power automate.

  • Krish1729 Profile Picture
    53 on 16 May 2022 at 04:08:51
    Re: when user add or modify data in excel which need to added in another excel file -in series, no old data can delete

    Hello @v-yujincui-msft 

     

    I have checked the expressions in Add row into a table. Please refer to the below screenshot:

    krish1729_0-1652674073037.png

    Thanks,

    Krishna

  • v-yujincui-msft Profile Picture
    on 11 May 2022 at 01:58:04
    Re: when user add or modify data in excel which need to added in another excel file -in series, no old data can delete

    Hi @krish1729 ,

     

    Could you please check the expressions in Add a row into a table Action?

     

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

     

    vyujincuimsft_3-1652234396230.png

    vyujincuimsft_4-1652234559871.png

    vyujincuimsft_2-1652234223424.png

     

     

    Best Regards,
    Charlie Choi

  • Krish1729 Profile Picture
    53 on 10 May 2022 at 10:27:41
    Re: when user add or modify data in excel which need to added in another excel file -in series, no old data can delete

    Hello @v-yujincui-msft 

    Thank you for co-opreating with me. the master file adding the blank cells. Do you have any suggestions to filter out the blank cells added in master file.

     

    Thanks,

    Krishna

     

     

  • v-yujincui-msft Profile Picture
    on 10 May 2022 at 09:35:50
    Re: when user add or modify data in excel which need to added in another excel file -in series, no old data can delete

    Hi @krish1729 ,

     

    Sorry my bad, i forgot to remind you to modify the expression with your field name.

     

    Try to use the following expression:

    @and(greaterOrEquals(item()?['date'], addDays(utcNow(), -7, 'yyyy-MM-dd')),less(item()?['date'], formatDateTime(utcNow(), 'yyyy-MM-dd')))

    vyujincuimsft_1-1652175104359.png

    vyujincuimsft_2-1652175133161.png

     

     

    Best Regards,

    Charlie Choi

     

  • Krish1729 Profile Picture
    53 on 10 May 2022 at 09:05:37
    Re: when user add or modify data in excel which need to added in another excel file -in series, no old data can delete

    Hello @v-yujincui-msft 

     

    Here is the output of array 3: @and(greaterOrEquals(item()?['Date'], addDays(utcNow(), -7, 'yyyy-MM-dd')),less(item()?['Date'], formatDateTime(utcNow(), 'yyyy-MM-dd')))

     

    Thanks,

    Krishna

  • v-yujincui-msft Profile Picture
    on 10 May 2022 at 07:25:08
    Re: when user add or modify data in excel which need to added in another excel file -in series, no old data can delete

    Hi @krish1729 ,

     

    Could you please provided the expression for Filter array 3?

     

    Based the screenshots you provided, the OUTPUTS of Filter array and Filter array 2 are not empty, please check if their output records match the conditions.

     

    In addition, you could check if there are records in the data source that meet both conditions.

     

    Best Regards,

    Charlie Choi

     

     

  • Krish1729 Profile Picture
    53 on 10 May 2022 at 07:09:50
    Re: when user add or modify data in excel which need to added in another excel file -in series, no old data can delete

    Hello @v-yujincui-msft 

     

    Please help me with the above error.

     

    Thanks,

    Krishna

  • Krish1729 Profile Picture
    53 on 10 May 2022 at 06:05:45
    Re: when user add or modify data in excel which need to added in another excel file -in series, no old data can delete

    Hello @v-yujincui-msft 

     

    Please see below screenshot of the outputs.

    krish1729_7-1652162635626.png

    krish1729_8-1652162684183.pngkrish1729_9-1652162714347.png

    krish1729_10-1652162734667.png

    Thanks,

    krishna

     

  • v-yujincui-msft Profile Picture
    on 10 May 2022 at 05:38:53
    Re: when user add or modify data in excel which need to added in another excel file -in series, no old data can delete

    Hi @krish1729 ,

     

    Of course you can.

     

    Best Regards,
    Charlie Choi

  • v-yujincui-msft Profile Picture
    on 10 May 2022 at 05:35:27
    Re: when user add or modify data in excel which need to added in another excel file -in series, no old data can delete

    Hi @krish1729 ,

     

    Could you please check the OUTPUTS of Other Actions?

    vyujincuimsft_0-1652160680868.png

    vyujincuimsft_1-1652160756290.png

     

    Best Regards,

    Charlie Choi

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