You’re offline. This is a read only version of the page.
Hello, I am new to Power Automate Online and I need to create a very specific Flow.
My list is below.
I need to filter by deadline. It would be Deadline - today, and I need to check 45 days, 30 days, 15 days, 7 days, and today.
The Flow needs to get everyone who is 45 days, separate by name, create a table, and send an email to them. And do this for the others as well. How do I do this? I've tried in many ways and I can't even get the filter to work.
Can anyone help me?
Hi @davipolonini24 ,
Do want to filter row expired 45 days,30 days, 15 days, 7 days and put them into different tables?
Take 45 days as example, you can try this.
Share
Report
All responses (
Answers (
div(sub(ticks(utcNow()),ticks(item()?['Prazo'])),864000000000)
The flow will run daily and get all rows expired 45 days and create a html table.
Same logic for 30 days, 15 days, 7 days and today.
Best regards,
Rimmon
796
