Hi @anwarkrg
as said, the below flow can run every day and add current date data to the sheet2. Also one thing to note- there should be table associated with each sheets
let's see the flow design -
1. Create recurrance flow/scheduledflow designed to run every day
2. Use list rows to get details from sheet1 data
Here i have used filter query which filter date column by current date.
3. Now loop through the list rows in table action's output using apply to each action.
Then add a row action to add row to sheet2
Expression used in date field-
formatDateTime(items('Apply_to_each')?['Date'],'yyyy-MM-dd')
All other dynamic content comes from the list rows in table action output.
Is this the flow design you have expected ?
