Answered

EMAIL WITH SHAREPOINT LIST DATA BASIS ON CONDITION

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

HI,

I am trying to trigger email on the basis of share point list data, where i am using different columns.. But for email, i am using 2 column for condition of email

1. Due Date column (Date & Time Column)

2. Status (Choice Column)

if due date is matched with current date and the status of column selected as not received, email should trigger.

i am trying with compose function

1. formatdatetime(utcNow(),'MM-dd')

2. equals(triggerBody()?['Status']?['Value'],'Not Received')

with 1st condition, i am able to run email. but with adding of 2nd condition , it's not running. Ansd i facing issue with flow

any suggestion.

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (1)

CU-18081211-6 9,270 Moderator on at

Like (0)

Report
Copy link

Link copied!

@Anonymous ,

Use condition action like this:

Hope it helps!

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

instead of compose, what i need to use for this?

Was this reply helpful? Yes No
Verified answer

CU-18081211-6 9,270 Moderator on at

Like (0)

Report
Copy link

Link copied!

you have in comments (first formula). Actually is what you used in compose.

triggerBody()?['Status']?['Value']

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

I TRIED , BUT IT IS NOT WORKING..
looking to run flow only when both condition matched..

1. current system date = due date column in SP List
2. Status = Not Received (Choice column in SP List)

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

below error is coming

Was this reply helpful? Yes No