Answered

How to create a flow to email some list records in sharepoint online O365 with some condition

(0) Share

Report

Posted on by YEUNG_Gabriel

I have a SP online list with a formular column [NOW] - [Due Date] and I can easily filter out any records <30 days. However, we would like to email those filtered records @09:00 daily to some users

How can we do this via Flow / Power App ??

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-micsh-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @YEUNG_Gabriel,

If you would like to schedule a flow, then this is better to be done under Microsoft Flow.

Run flows on a schedule

You may take the following thread as a reference:

Flow to email sharepoint list

Follow my steps in the thread above to configure the Flow.

If you have any further questions, please post back.

Regards,

Michael

Was this reply helpful? Yes No
YEUNG_Gabriel 23 on at

Like (0)

Report
Copy link

Link copied!

Hi

Your link is valuable and I can create a flow on this...

I have a column named 'B' and it is a calculated field NOW() - [Due Date] so I put this in the FILTER QUERY --> B eq 'EXPIRED'

However, it failed and the Error Details is

The field 'B' of type 'Calculated' cannot be used in the query filter expression. clientRequestId : 7c92d7e20-a148.....

Thanks

Was this reply helpful? Yes No