Unanswered

Send e-mail only to user that match date conditional requirements

(0) Share

Report

Posted on by cnapan

screencapture-emea-flow-microsoft-manage-environments-Default-a8bcda6a-e5fc-468e-b14a-af6ebf303051-flows-d2f9fba8-7dae-4cfb-8d10-ba9b3ad02ca3-2021-02-03-20_39_38.png Hello, I would need a little help with the flow process. I have a Sharepoint list with two columns. Column 'Name' contains a user names. Column 'Date' contains dates. I have used formatDateTime function to compare the current date with the dates from column 'Date' If it match, then based on the username I am getting user e-mail address and the e-mail is sent to that user. And all that works. The problem is that the e-mail is sent to all users from the list, even if the date next to their names is not matching current date I would like that e-mail to be sent only to these users, who have current date next to their names. How to accomplish that?

Categories:

Building flows

I have the same question (0)

All responses (14)

Answers (0)

Sort by

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @cnapan ,

How do you get the current date and how do you format the date on the SharePoint list? Would you please share the expressions for the formatDate functions?

Was this reply helpful? Yes No
cnapan 24 on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous
That is the formula I am using:

formatDateTime(triggerBody()?['Last_x0020_day_x0020_at_x0020_wo'], 'dd-MM-yyyy') is equal to formatDateTime(utcNow(),'dd-MM-yyyy')

Was this reply helpful? Yes No
VictorIvanidze 13,081 on at

Like (0)

Report
Copy link

Link copied!

Why do you do "Search for Users"? For what?

Was this reply helpful? Yes No
cnapan 24 on at

Like (0)

Report
Copy link

Link copied!

Because I got only user name in Sharepoint column in shape like this: "Joe Doe". I need to obtain somehow the user e-mail address, based on his name.
Does the question is related somehow to my issue?

Was this reply helpful? Yes No
VictorIvanidze 13,081 on at

Like (0)

Report
Copy link

Link copied!

Sorry, my bad, I thought you have the address in the list.
Could you somehow test "if no" branch?

Was this reply helpful? Yes No
cnapan 24 on at

Like (0)

Report
Copy link

Link copied!

Not sure how to test. I think I am missing some step that takes only the values that matches condition before the sent-email step.

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

Like (0)

Report
Copy link

Link copied!

Hi @cnapan ,
What I would suggest for testing is,
1) Initialize 2 string variables. The current date variable will have the expression formatDateTime(utcNow(),'dd-MM-yyyy')

2) When you have the SharePoint item set the relevant date. The expression will be formatDateTime(triggerBody()?['Last_x0020_day_x0020_at_x0020_wo'], 'dd-MM-yyyy')
3) for the condition compare the two variables.
when you run your flow you should able to see what is assigned for each variable. Please send those screenshots so we can see the result of the expression

Was this reply helpful? Yes No
cnapan 24 on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous
I have tested it and now it gives me an error on the formula getting date from sharepoint. I did not changed anything, but now it cannot get the date properly. It worked yesterday. Eh... Instead go forward with that issue I am only getting back. 😞

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

Like (0)

Report
Copy link

Link copied!

Hi @cnapan ,

In my example, I didn't give an initial value for the SharePoint date.

Was this reply helpful? Yes No
cnapan 24 on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous
Have done what you have asked for.. Not sure what that is proof though,

Was this reply helpful? Yes No