web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Get Items Filter Query

Power Automate

Answered

Get Items Filter Query

(0) Share

Report

Report

Posted on by davipolonini24

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?

Categories:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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.

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

Was this reply helpful? Yes No

Join the conversation