how to hide create button based up on gallery content

[rajkumar88]

I was try this with regular text box, check and uncheck box and it is working fine.

However if try to hide and unhide a "create new button" based up on the Gallery items, it is not working at all. 

My scenario is that- I have a a screen with Gallery filtered based up on the "assigned to" column. If user already submitted a line item through the form then it should not allow them to create one more request when they land on that screen. And if the user never created a request through that form then "create new button" should show up for that user. 

[rajkumar88]

Thanks for your sugegstion. That's a good idea. Howwever onstart -- I already have a rule as per below line.

If(User().Email in EmailList.ManagerEmail,Navigate(ManagerLandingscreen,ScreenTransition.None),User().Email in EmailList.EmployeeEmail, Navigate(EmpLandingScreen, ScreenTransition.None))

How can I add your code there? sorry to ask dumb question as I am pretty new to in PowerApps development.

Also as per the previous reply, I am using a filter based up on Created By'.DisplayName=User().Email to display gallery items. But do know how can I make it work if I click on Pending then it should show only pending items, if I click all it should show only all. somthing like that possible?

3. with respect to third point, how can I patch user email to the "email column" ? is it needs to be done before they save the request or on the start screen get the user email address and update the column?

[myke_deabreu]

Just add the code before your code.

Set(var_useremail,User().Email);

If(var_useremail in EmailList.ManagerEmail,Navigate(ManagerLandingscreen,ScreenTransition.None),var_useremail in EmailList.EmployeeEmail, Navigate(EmpLandingScreen, ScreenTransition.None))

for 3 just have that column default to var_useremail and hide it from the user.

[rajkumar88]

Hi Mke,

if I add it to my gallery filter then it is not working. instead if I make to user().email  then it shows list of line items.

Filter(EmployeePerformance,'Created By'.Email=var_useremail)

[myke_deabreu]

Did you run the "OnStart" after you added the line?

you could even try as a test add a button "OnSelect" Set(var_useremail, User().Email) and see if it shows.

If this doesnt work take a screenshot of your "OnStart" formula.

[v-xida-msft · Accepted solution]

Hi @rajkumar88 ,

Do you want to filter your Gallery Items based on the "All" and "Pending" button you clicked?

Firstly, if you want to filter your Gallery Items based on the creator of the request, please set the Items property of the Gallery to following:

Filter(EmployeePerformance,'Created By'.Email = User().Email)

You could also consider set the OnStart property of App control to following:

Set(CurrentUserEmail, User().Email)

Set the Items property of the Gallery to following:

Filter(EmployeePerformance,'Created By'.Email = CurrentUserEmail)

then save and re-load your app, check if the formula take effect.

If you want to filter your Gallery Items based on the "All" and "Pending" button you clicked, please take a try with the following workaround:

Add two buttons within your screen -- "All" & "Pending". Set the OnVisible property of the current screen to following:

UpdateContext({CurrentSelected: "All"})

Set the OnSelect property of the "All" button to following:

UpdateContext({CurrentSelected: "All"})

Set the OnSelect property of the "Pending" button to following:

UpdateContext({CurrentSelected: "Pending"})

Set the Items property of your Gallery to following:

Filter(
       EmployeePerformance,
       'Created By'.Email = User().Email,
       If(
          CurrentSelected = "All",
          true,
          Status = "Pending"
       )
)

Note: The Status column is a Text type column in SP list, which used to store the Request Status. If the Status column is a Choice field, please modify above formula as below:

Filter(
       EmployeePerformance,
       'Created By'.Email = User().Email,
       If(
          CurrentSelected = "All",
          true,
          Status.Value = "Pending"
       )
)

Please take a try with above solution, then re-load your app, check if the issue is solved.

Best regards,

[rajkumar88]

Hi,

Thanks a lot for the solution. 

Filter(
       EmployeePerformance,
       'Created By'.Email = User().Email,
       If(
          CurrentSelected = "All",
          true,
          Status.Value = "Pending"
       )
)

 for status.value ="pending" , can I also add one mor button and set this as "reviewed" too? If user clicks on Reviwed button then it show only  those line items. so do I need to use OR function after the status.value ="pending"?