Answered

Button DisplayMode to filter approvers

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have a strange but valid question from a user.

When my form is submitted, it triggers an email to Approver1, if Approver1 deletes the email, there is no way for them to get to the form for approval.

I have a button on my form, which is for 'my requests' and the DisplayMode I have set to this and when clicked navigates them to the my ViewScreen, I need this to be clickable for up to 5 users. is there a better way of doing this:

If(CountRows(Gallery2.AllItems)=0,DisplayMode.Disabled,DisplayMode.Edit)

Ideally do not want the button to be cickable if the user logged in does not have anything to view in the ViewScreem which contains my gallery. I tried something like this and a few variation but doesn't work, can someone help please:

If(And(CountRows(Gallery2.AllItems Or VarUser=DataCardValue33.Selected.Email)=0,DisplayMode.Disabled,DisplayMode.Edit)

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Verified answer

eka24 20,925 on at

Like
a
(1)

Report
Copy link

Link copied!

Create a local Table on Onstart of the App:
Set(MySelectedUsers,
    Table({MyUser: "g@sss.com"},
        {MyUser: "aaa@sss.com"},
        {MyUser: "bbb@sss.com"},
        {MyUser: "vv@sss.com"}))

Then on the Displaymode of the button:
If(User().Email in MySelectedUsers,DisplayMode.Edit,DisplayMode.Disabled)
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@eka24
Thank You.

Edited my last comment, just re-testing

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
@eka24

Thank you, I believe that works, will need to test it properly with another user, but not errors 🙂

Curious if I can use what you have suggested on the Items property of my gallery, rather filtering by various users I tried this, but get a delegation warning on the in part of the function:

Filter(List, VarUser in MyApprovers)

It appears using exactin removed the delegation warning, I expect the users name will also be as is, so exactin being case sensitive should not cause me a problem:
Filter(List, VarUser exactin MyApprovers)
your thought please?

Was this reply helpful? Yes No
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

That will be fine provided the users will not have same names.
Something should different the name. That is ok
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No