Power Automate Exchange

Please login or click SIGN UP FOR FREE to create your FlowUG account to join this user group.
 View Only
  • 1.  Only receive email depending on condition not working

    Gold Contributor
    Posted Mar 17, 2022 07:34 AM
    Edited by Chris Clark Mar 17, 2022 12:39 PM

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



  • 2.  RE: Only receive email depending on condition not working

    Posted Mar 18, 2022 07:57 AM
    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
    ------------------------------



  • 3.  RE: Only receive email depending on condition not working

    Gold Contributor
    Posted Mar 18, 2022 08:55 AM
    Edited by Chris Clark Mar 18, 2022 09:48 AM

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