I am working on an approval process with multiple approver approving the item in parallel.
I have set up a MS list "Approver List" in sharepoint, which it contains columns
In the other list for items to be approved, there is a column called "Assigned_To", where it stores all the approver's email as choice (allow multiple selection with custom input)
I am using power automat to change the approval status of this item to pending as well as sending email to all the approvers by using the "Assigned_To" content from MS list. Then the email will have a deep link back to power app and brings the approver to the specific item to be approved.
However in the StartScreen I would like to check if the User clicking the link is one of the "Assign_To" email of which Company,
For example:
Assign_To
Person1@xxx.com (Company A)
Person2@xxx.com (Company B)
Person3@xxx.com (Company A)
The formula in StartScreen should check if the user is one of the Company A approver in the MS Approver List, if it is Company A then brings the user to Company A specific FormMode setting (Company B approval info disabled).
The problem I am facing now is that since the item to be compare is not compatible, and I don't know how to forumulate the logic above...
Error:
ID=Value(Param("ID"))).Assigned_To = User().Email
Not sure if I have explain this clear enough, please feel free to ask more question if it's unclear.
