cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Trying to use Power Automate to send email reminder to employees is not working

Hi there,

I have a flow here. Basically I am trying to send employees reminder emails who did not complete their timesheets every Friday and following Monday. I have an excel file where I keep all the employees names as "Employee" columns and their emails. When an employee fills her/his timesheet, it goes to a Sharepoint list. What I like to do is to make a comparison with my excel file and Sharepoint list if the employees names are matching if not matching which means the person did not submit timesheet for the week so those employees should receive the email reminder. The column name is also called "Employee" in the SharePoint list. 
 
Another comparison needed also because in the Sharepoint list the submission status is not always "Approved" cause some people create their timesheet and leave the application without completing it, so we want to send these employees email who have their name in the Sharepoint list but their status is not approved. 
 
Here's my screenshots of my flows:
Screen Shot 2021-06-29 at 11.18.03 AM.pngScreen Shot 2021-06-29 at 11.18.33 AM.pngScreen Shot 2021-06-29 at 11.18.57 AM.pngScreen Shot 2021-06-29 at 11.20.19 AM.png

    

This is the condition formula that I have in the screenshot: 

 

length(outputs('Get_items')?['body/value'])​

 

 

Somehow, I feel there is no comparison being made. This flow sends reminder emails to everyone who has their name in my excel sheet. Could anyone please tell me what I am doing wrong or missing?

 
In my get items I have a comparison with the Employee column from Sharepoint to Employee column in excel and the second condition is the checking id the status equal to approved. They were not dynamic contents and I had to add a custom value. 
 
Hope everything make sense and thank you in advance for all the help!
1 ACCEPTED SOLUTION

Accepted Solutions

In relation to the filter, you need to use an OData expression in your filter, in this case you can try the following

 

(Status eq 'Approved') and (Employee/EMail eq '<Employee Email>')

View solution in original post

4 REPLIES 4
hmbarona
New Member

Hi @Anonymous ,

 

I believe your condition is wrong.

Can you please try the condition below?

 

length(body(‘Get_items’)?[‘value’])

In relation to the filter, you need to use an OData expression in your filter, in this case you can try the following

 

(Status eq 'Approved') and (Employee/EMail eq '<Employee Email>')
Anonymous
Not applicable

Thank you so much again @hmbarona for your time and solution to the problem. Hope this will help others who needed in future. 

hmbarona
New Member

Hi @Anonymous . I actually forgot to let you know. In case you want, you can join this group related to Power Platform that I created a few months ago, so you can follow up on the future events that we organize. Also, feel free to invite anyone interested in joining us. "Nos Vamos!" 😄

 

https://powerusers.microsoft.com/t5/Power-Platform-Portugal/gh-p/pp_Portugal_usergroup

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (1,827)