Power Platform Community Forum Thread Details

Hi Power Apps Community,

I’m encountering an issue with my Power Apps form where the email is not sent on the first submission due to a "no recipient" error, but it works on subsequent attempts. Here’s the setup:

Scenario:

I have a SharePoint list named 'Approval Matrix' with columns: Title, Section, and Approvers Text.
In my Power Apps form, I use DataCardValue11_1 and DataCardValue18_1 to capture the Title and Section values respectively.
I’m using the following formula to set the nfApprover variable:
Set(nfApprover,
LookUp('Approval Matrix',
Title = DataCardValue11_1.Selected.Value && Section = DataCardValue18_1.Selected.Value,
'Approvers Text')
);
Issue:
The first time I submit the form, Office365Outlook.SendEmailV2 returns an error indicating "no recipient."
When I submit the form again without making any changes, the email is sent successfully.

Implementation:

I initialize nfApprover on App formulas: nfApprover = LookUp('Approver Matrix', Title = DataCardValue11_1.Selected.Value && Section = DataCardValue18_1.Selected.Value, 'Approvers Text')

Question:
Why does the nfApprover variable seem to fail on the first submission but works on the second attempt? Is there a timing issue or something I'm missing in setting or updating the variable? Any guidance to ensure the email is sent correctly on the first submission would be greatly appreciated.

Thank you!

Categories:

Building Power Apps