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.
Hello @v-yujincui-msft
I have checked the expressions in Add row into a table. Please refer to the below screenshot:
Thanks,
Krishna
Hi @krish1729 ,
Could you please check the expressions in Add a row into a table Action?
items('Apply_to_each')?['YourColumnName']
Best Regards,
Charlie Choi
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
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')))
Best Regards,
Charlie Choi
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
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
Michael E. Gernaey
497
Super User 2025 Season 2
David_MA
436
Super User 2025 Season 2
Riyaz_riz11
244
Super User 2025 Season 2