Hi Kim,
Thanks for your reply.
I amended the condition to

So hopefully if the column in my SP list isn't null then the email will be sent?
I'm still having issues with certain fields that are not populating the body of the email.
Mainly CovidTypeValue and SicknessReasonValue. These are both drop downs in the app. Are these the correct context to use?
DateReported, ExpectedReturn which are all required fields and ContactNumber

Regards
Chris
Edited 18/03 13:47
When you mention add the expression in the trigger. Is the trigger button within the app. The Save or submit button??
------------------------------
Chris Clark
Application Support Developer / Analyst
------------------------------
Original Message:
Sent: Mar 18, 2022 07:56 AM
From: Kimberly Piper
Subject: Only receive email depending on condition not working
Hi Chris,
I think you should move your condition to the trigger so you can prevent the flow from running unnecessarily. To do this go to the settings of the trigger and then add a trigger condition. This will simplify your flow considerably.
If you want to the flow to fire when the manager is populated you could use something like below substituting Manager with the appropriate field. Take a look at this link for more details: https://www.c-sharpcorner.com/article/flow-trigger-conditions-for-sharepoint-run-flow-when-needed/
@equals(empty(triggerBody()?['Manager']),false)
I hope that helps,
Kim
------------------------------
Kimberly Piper
Manager, BI, Data & Information Services
Original Message:
Sent: Mar 17, 2022 07:33 AM
From: Chris Clark
Subject: Only receive email depending on condition not working
Hi,
I'm want only certain emails to be sent out depending if a column ion my SharePoint list is populated This is my flow created from the SharePoint site

So when the column 'ManagersEmail' is populated a mail should be sent.

It worked in prinicipal as I did receive an email when column was populated but I also received one for the next record added but the ManagersEmail column was not populated.
Also some of the the body of the email details required are not displaying

SicknessReason
ExpectedReturn
ContactNumber
There is data for these in the SP site??
Edited 17/03 @ 16:10GMT
I've played about with some of the conditions and getting really confused
This is my latest try

Managers name is only populated depending on the screen submitted. So not all records will have this column populated. EmployeeName will always have data in.
So I want those records that have data in both columns to have a mail sent out. At the moment still receiving Emails from all records.
Also the email is not containing all the necessary information still
Please can someone help ??????
Edit again on the 17/03 @ 16:40
Would an expression help? If so what one and how??
------------------------------
Chris Clark
Application Support Developer / Analyst
------------------------------