PowerApps Hide Button Based on User and other fun 

Happy to help

Thanks 🙏

Awesome 😎

Very cool

Glad you got it 😀

🤣 Glad it was helpful!

Thanks 😊

Awesome

Thanks Manny

Glad you got it. Yup, Concat was the answer I was going to give. :)

Yuppers

PersonField.Email

Thanks Simon

Awesome 😎

I don’t know about that. The permissions groups have been around forever 😑

Awesome.

My pleasure!

Glad to help

Not that I know of. 😐

🐶 is always so fun

Glad to help. 😀

Zach can you give me a time stamp where I mention it? I don't remember which video anymore. Sorry.

Happy to help. 😎

I haven’t yet. SharePoint groups aren’t rally possible. 😔

Thanks 😀

I don’t. My hint is: set the Visible property of the label or TextInput you want to show to ToggleName.Value and you should be all set.

@@ShanesCows Ok. Thanks! I will give that a try.

I do some validation in this video not using forms ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-IvapIsBbM-U.html

Like this maybe? ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-CO6xfbjnYwc.html

SharePoint groups aren’t possible without calling Graph API. Azure AD groups maybe I cover one of these days not sure.

I think this video will help. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-s85i8UWw2QM.html

If I follow you would need to store the email address the user entered in a data source and then do a lookup to see if the logged in user email matches and he lookup

@@ShanesCows This makes sense, and was helpful. I needed an approval button to show for a manager, who would log in after the form was created and approve or deny, but I wouldn't know what manager was chosen before they were chosen. I worked through a few videos, and got it to work! Thank you!

Check the file name to see if it matches jpg or png

Glad to help. 😀

I found my mistake... the gallery's result is not the one, multiple results were shown. That's why the text did not return a certain result, and when it was clicked, it means the result was selected, then the text showed. Umm... difficult!

You can put the same code in each control's visible property. Or setup one control, like a button, and then set the other controls to Button.Visible

Glad it helped

You are welcome :)

Yes, but it isn't simple. You could have logic that says OnCheck If(both boxes are checked, submit) Hopefully that is enough for you to get it. 😀

@@ShanesCows nice one thanks Shane, so quick ! Didnt think about yhat one... I'll give it a crack...

Yes, hide the button to navigate to those other screens with the technique from this video.

Type YourColumnName. and then see what it offers you for options. :)

Happy to help

One option would be like I show here. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-_Qnz4YeHses.html

Put an Or between the two = formulas

Sorry I don’t remember the whole formula. Leave a new comment with the broken formula and I will try to help

I haven’t done a group column. Sorry

@@ShanesCows No Problem. I have tried and done it. Thank you Shane.

You bet!

Create a variable and set it when they click the button. Have the visible property of the button tied to the variable.

Shane Young What would be the syntax for this? I used UpdateContext and set it to false on the OnSelect property and then tied the visibility to the variable. It doesn’t hide the button.

Use IsBlank to check if the field has been filled in

Yes Sir! ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-s85i8UWw2QM.html 😀

.... not sure.... IDEA add a parameter to the URL when you embed in SharePoint. Have your app check for the parameter. 😎 This would work. If you have used parameters before look for my video on Deep Linking for an overview.

Not that I know of Asim

Thanks 🙏

I need to for sure. 😀

I would guess you have a typo in your lookup.

Did you make sure that there is a value stored in the variable?

Yes, but only read access.

Look in app settings. I think there is a setting that says Delay app start or something of the sort.

Haven’t done it before. Sorry. Look to see if there is a connector

Juan I thought I showed in this video how to query a list. But you are right I never did a video on security groups. 😑

Not a huge issue, I can create a power automate flow to fill a list with the members of an AD group, however it would be cool to create different roles in an app and manage it easier 😃

You could put a spinner on the visible of the screen that delays things a second or two? Not sure, you might just have to get creative. I don’t think any of the apps I do this in have the issue but I have seen it before

There is no easy way to reference SharePoint Groups. Maybe via Graph API.

CheckBox.Value returns true or false. Set Visible property to be Not(CheckBox.Value) and that should do it.

Replied to the other comment

Set(varUserEmail, User().Email) should work OnSelect of a button. 😑

@@ShanesCows Update, I think it has to do with how our tenant is set up. Lame!

You can create a group in Power Apps and then set the visible property

@@ShanesCows I could not figure out how to add DataCards to a group. Is it possible?

That is shown in this video, you will need to slightly pivot and change your LookUp to have a criteria of Field = yes

Access.Value = "Full"

Hey Jason I don't think Display.None is possible. I think you have to do Visible. If you need something to move up then you would need to write dynamic formulas for X and Y of hte object you want to move. Possible but a lot of moving parts

@@ShanesCows Thanks Shane!

Try adding labels to the app to see what is happening when it is running

@@ShanesCows Thank for answering. I was loading those users from a SharePoint list into a collection and from there in a variable. All of them were shown in the collection but not all of them in the variable. Now using !IsBlank(LookUp(KLBBackOffice;Title=varCurrentUserEmail;Title)) as shown in your video solved the problem.

Nevermind - your solution works, I forgot to add another "SharePoint list" data source, thanks!

Glad you got it. 🤩

When you click the button Set a variable to be false. Set(varShowButton, false) Have the button's visible property be varShowButton `

Yes, you would need to add the groups connector and write the logic. I have tested it and works fine but I don't have video on it. I do think this download in the Curated Library has that working though.

I lie variables onStart for those.

@@ShanesCows I set their values in the OnEdit. Will try to put them in the Start and see how it goes. Was afraid it wont set them. Thanks for the reply! Waiting for more videos

NOt sure. That looks correct to me. Maybe try it with a hardcoded email address first.

Finally got it to work correctly. I had to click on the ellipsis (...) next to App to RunOnStart. Good to go.

Awesome thanks for sharing 😀

Diane that looks right. :( I know it has been a while so my fingers are crossed you got it working already. 🤞

I have this same question. Why should I need to explicitly type an email address when I can get it from the properties of a person object? I've been at it for a day now, and it tells me that the PersonColumn.Email returns a table, and not a text value. I do it LookUp('SharePoint List Name',Title = "Plant Manager", Name).Email, where "Name" is a column of type "Person." I should get the email of the Plant Manager this way, but nope, just an error about it being a table, and how I cannot compare that to a text value. I'll do a workaround by adding an Email column to my table, so I can do LookUp('SharePoint List Name',Title = "Plant Manager").Email and that works, but I don't think I should need to do that. In Shane's example, he manually types the email into his list, which seems a little bit error-prone to me.

I bet you have an issue with capitalization. Shane =shane doesn’t work. Look at your email address again 😀

Ahh, nevermind, figured it out. A Save, Close, and reopen of the App did the trick.

Awesome

Glad you enjoyed it

That is probably because the people column is a complex column so hard to query

@@ShanesCows Thank you i ended up using the Office365 group option. Awesome videos thank you very much

Thanks for sharing Jenn.

Have you tried manually testing the Lookup? Maybe your email isn't the same or capitalization is wrong? Troubleshoot the lookup and you will find the answer.

@@ShanesCows HI Shane, yes i have tried to do a lookup and it is returning a blank so as a newbie i am at a complete loss.

@@ShanesCows I started again with your video and did every step from the very beginning. For some reason my button will show if i use the user().Email = but when i use varUserEmail It is blank.

Did you publish your changes after saving.

@@ShanesCows No I have not. You mean, once the application is published then only those fields will be visible!

Correct

@@ShanesCows thank you 😊. Let me try.

@@ShanesCows Thank you Shane 👍. It worked.

You have to apply the concepts from the video to lookup if the person is a manager.

Not that I know of. YOu will need to write logic to manage that yourself.