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