web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Apps - Building Power Apps
Unanswered

Outlook connector failed to send email due to null values for the 'to' parameter of the send email function

(0) ShareShare
ReportReport
Posted on by 95

Hi,

 

My powerapp looks up an approver from a sharepoint list and maps their email to the 'to' parameter in the outlook send an email V2 function.

 

Users of the app can therefore send items to the approvers for approval.

 

Problem is that some users get this error:

 

danru_0-1699966914959.png

 

I guess that this must be due to the fact that these users don't have permissions to see the approvers list hence the null value in the function and subsequent error. However, they HAVE BEEN ASSIGNED permissions as described below (the behaviour in the app suggests that they still can't see it nonetheless).

 

All these users are part of a custom sharepoint group that the approver's list is shared with (this list has unique permissions).

 

It works for users who are ALSO part of the default sharepoint members group at the site level (edit permissions), but NOT for those who are ONLY part the custom sharepoint group ( the custom group has 'contribute' permissions for the approvers lists).

 

I did a test where I shared the site with the custom sharepoint group and upgraded it's permission level to 'Edit' (same as 'Members'). However this did not work produce the same result as the error returned.

 

My finding is that the users of the app must also be part of the Sharepoint Members group (share site only) for this to work.

 

It's strange as the app users that are ONLY part of the custom group are still able to submit records to another 'request' list on the same site and view it in the app no problem (without having to be part of the default members group).

 

It only seems to be an issue with the lookup to the approvers list in the powerapp.

 

I would appreciate it if anyone knows why this happens?

 

Thanking you again as always.

 

Regards,

 

Daniel

 

 

Categories:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Coming soon: forum hierarchy changes

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 819 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 308 Super User 2025 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 222 Super User 2025 Season 2

Last 30 days Overall leaderboard