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

[cnapan]

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?

[Anonymous]

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?

[cnapan]

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')

[VictorIvanidze]

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

[cnapan]

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?

[VictorIvanidze]

Sorry, my bad, I thought you have the address in the list.

Could you somehow test "if no" branch?

[cnapan]

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.

[Anonymous]

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

[cnapan]

 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. 😞

[Anonymous]

Hi @cnapan ,

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

[cnapan]

Hi @Anonymous 

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

[Anonymous]

Hi @cnapan ,

Your screenshot does not show the date coming from SharePoint, have you set the variable after getting the SharePoint item? 

[cnapan]

@Anonymous  What variable I should set? In previous post you have asked me to set SharepointDate variable empty.

[Anonymous]

@cnapan 

[cnapan]

When I put that expression to SharepointDate variable I am getting error that I posted before. Which is strange, because it worked fine earlier. 

No offence, but I think I would start a new thread about this issue. I have feeling we are to much off topic here.