Power Platform Community Forum Thread Details

Hi Experts,

Need a little help if you can please

I have a sharepoint list named ChangeRequests

I have a screen with a Gallery called Gallery2 and the Items Property set to:

(Filter(ChangeRequests,
(Lower(User().Email) in (Stage1Approver1) || (Lower(User().Email) in (Stage1Approver2) && IsBlank(Stage1ApprovalStatus) && (ChangeStatus="Submitted") ||
(Lower(User().Email) in ('R&D Approver') && IsBlank('R&D Approval Status') && (ChangeStatus="Awaiting Department Approval") ||
(Lower(User().Email) in ('IT Approver') && IsBlank('IT Approval Status') && (ChangeStatus="Awaiting Department Approval")
))))))

In Gallery2 there is a Button with the OnSelect property to Navigate to a new screen with a Form to show the results of Gallery2.Selected. At the bottom of this screen, there is another button to add comments and approval. The OnSelect of this button is currently:

Gallery2.Selected;Navigate(Screen1)

I'd like to change this code to select the request that has been selected from Gallery2 and to navigate to a screen called Stage1Approval if the logged in user is listed in my SharePoint List (ChangeRequests) column named Stage1Approver1 OR in the column named Stage1Approver2 and also if the Text in column Stage1ApprovalStatus is "Submitted"

But navigate to a different screen called Screen1 if the logged in user is listed in a TextInput (displayed like user1@domain.com;user2@domain.com) and the text in the SharePoint column Department1Status is "Awaiting Department Approval"
OR if the logged in user is listed in a TextInput (displayed like user3@domain.com;user4@domain.com) and the text in the SharePoint column Department2Status is "Awaiting Department Approval"
OR if the logged in user is listed in a TextInput (displayed like user5@domain.com;user6@domain.com) and the text in the SharePoint column Department3Status is "Awaiting Department Approval"

If it can't be done by looking at one textinput for the email address as I mention above then I can do each email address in separate TextInputs so that TextInput1 would display user1@domain.com and TextInput2 would display user2@domain.com etc.

Thanks in advance!

Dave

Categories:

Using Apps Using Formulas

Connecting to Data