web

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

News and Announcements icon

Power Platform CommunityForums Power Automate Change this formula to...

Power Automate

Unanswered

Change this formula to -7 days

(0) Share

Report

Report

Posted on by MarkCoates

63

Hello,

Is anyone able to change the below formula so it collects data for the previous 7 days please?

@And(not(equals(length(item()?['Date']), 0)),equals(formatDateTime(item()?['Date'], 'dd/MM/yyyy'), formatDateTime(utcNow(), 'dd/MM/yyyy')))

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report
Hi @MarkCoates,

You could use the addDays functions an substract 7 days. With greaterorequals and lessorequals you can check if the detail is within the last 7 days time range.

Try an expression like below:

@and(and(not(equals(length(item()?['Date']), 0)), greaterorequals(formatdateTime(item()['Date'], 'yyyy-MM-dd'),addDays(utcNow(),-7, 'yyyy-MM-dd'))),lessorequals(formatdateTime(item()['Date'], 'yyyy-MM-dd'),utcNow('yyyy-MM-dd')))

Was this reply helpful? Yes No
MarkCoates 63 on at

Like (0)

Report

Thank you very much @Expiscornovus - Also, would you happen to know, in the automatic e-mail I send at the end, how would i be able to show "Please see report from 'Date' to 'Date'"

First date being 7 days ago and 2nd date being today?

Was this reply helpful? Yes No

Join the conversation