Power Platform Community Forum Thread Details

App Fails to Send Emails After First Submission When Published, But Works in Play Mode

I’ve built a Power Apps form that retrieves email addresses using LookUp from a SharePoint list called 'Approval Matrix' for sending emails upon submission. The app works perfectly in play mode (when testing in Power Apps Studio). However, after publishing the app and using it live, the first form submission fails to send emails, showing that the email receiver is empty.

the code I’ve implemented for handling email notifications in our Power Apps application: Formulas:

FirstApprover = LookUp('Approval Matrix', Section = DataCardValue17_1.Selected.Value, 'First Approver Email');

SecondApprover = LookUp('Approval Matrix', Title = DataCardValue5_1.Selected.Value && Section = DataCardValue17_1.Selected.Value, 'Second Approver Email');

Email Logic in App OnStart Property:

Switch(

Lower(User().Email),

    Lower(FirstApprover),
    Office365Outlook.SendEmailV2(
        SecondApprover,
        " Request for New member",
        "etc..."
    ),

    Lower(SecondApprover),
    Office365Outlook.SendEmailV2(
        "manager's email"//

    ),

    // Default case:
    Office365Outlook.SendEmailV2(
        FirstApprover,
        "Request ",

    )
)

Please let me know if there are any suggestions or improvements you would recommend. Your feedback would be greatly appreciated.

Thank you!

Quick Links

Leaderboard