PowerApps Hide Button Based on User and other fun

[@OneBallJ]

Oh man, I used to build two applications, one for the submitter and one for the team. Now I use this same functionality to merge the two platforms. Even though I've been doing this for the last 4 months your video still showed me a new way of doing it! Thanks Shane!

[@ShanesCows]

Happy to help

[@TimothyBishop-o2c]

YES! THANK YOU FOR GETTING MORE COMPLICATED WITH THE DATA QUERY! Sorry for yelling. I was very excited you took the time to get more complicated.

[@ShanesCows]

🤣 Glad it was helpful!

[@EffortfortheEffort]

Good video! There is not too much content available for these scenarios and you really hit the nail in the head with this video.

[@ShanesCows]

Thanks 🙏

[@chloez2725]

This is exactly what I've been looking for. Thank you Shane! Actually, like your clients, I work in the HR department too, and I have to create this "manager approval" button, which is visible to managers only. Your video definitely helps me out on this :)

[@ShanesCows]

Awesome 😎

[@OptimalTrainingGroup]

Excellent Video Shane! Do you have a video showing how to make a field hidden or visible if a checkbox is clicked?

[@ShanesCows]

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.

[@OptimalTrainingGroup]

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

[@zacharymcdonald8929]

Shane, great video this helped me with one of my power apps a while back but now managing my access list is to time consuming. I want to change my button view to what you described for the last button in this video. I just can’t find the second video. could you share the video link with me?

[@ShanesCows]

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

[@nitzan300]

Thanks a lot again for the amazing videos that you are sharing ! i would like to disable one option from my dropdown list in a certain hour, i am building a Meal ordering tool in my org and the employee should have the ability to order Lunch till 12:00 AM and Dinner till 17:00 , i have drop down list where the employees can choose Lunch or Dinner , what is the best way to do it ? Thanks in advance .

[@ShanesCows]

I think this video will help. kzbin.info/www/bejne/qWmYmmuLjNxlh68

[@lindseywoolmington8165]

Thank you, Shane!! This perfectly addresses a business problem we currently have!

[@ShanesCows]

Very cool

[@francisnoonan2314]

Shane, Thank you kindly for your well explained video. I am intrigued by the external list of email address you used for the visible buttons. I would also like to use this list as a "Send To:" list using the 'Office365Outlook.SendEmailV2' function, but it wants text instead of a table. Do you have a video that would explain using an external list of email addresses? I would like to modify a list instead of the app every time someone is hired or fired (or quits). Edit - Found article using the 'Concat' function. Works perfectly. Thank you again, your videos are well done!

[@ShanesCows]

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

[@altino91255268]

Hi Shane, How are you? Your videos are great. How do I protect my Sharepoint list, I don't want users to be able to see them or edit them directly ?

[@ShanesCows]

One option would be like I show here. kzbin.info/www/bejne/lYLRq2ePmq2mm9U

[@travisjones8134]

just finished watching video, and it definately gives me thoughts on my app that im building. my question, can you apply these same techniques to forms and galleries, rather than just individual buttons or fields?

[@ShanesCows]

Yuppers

[@aparnagupta9472]

Awesome!!Although I have a concern that why are the videos blurry?? For most of the powerplatform tutorials videos are blurry...

[@ankita199]

Thankyou for the video. Question- can we have an app with multiple screens with admin able to access all screens while other users can only access certain screens based on their role?

[@ShanesCows]

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

[@jackviljoen8809]

Hey Shane, I'm sure you can easily answer this. I am wanting to click a button and the label below disappears. I have looked all over and cannot find out how. Thanks!

[@ShanesCows]

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

[@sofiafrancia2059]

Thank you very much Shane, you are great! I need to create a save button that is enabled on the 1st of each month and disabled on the 15th of each month automatically so that users can only send information within a certain date. I did not find instructive about the latter, do you know if it can be done and how?

[@ozifer7934]

Hi Shane , thank you great video. I am trying to hide more than one filed depending on the selected value in dropdown. I m struggling what is the best way to achieve this?

[@ShanesCows]

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

[@jenn4256]

I ran into the issue that the button will still be available for about 1 to 2 seconds to individuals not in my Access Control list (mine is called Voters list) and of course someone went in to click on it right away before it disappeared. Not sure if anyone else had this issue, but I fixed it by making a varAccess variable on app start that saves the boolean value when compared to my Voters list. Then I put the button on an inner screen so that it is automatically invisible and does not even pop up for the 1 to 2 seconds while the app loads and decides the value. This is my app on start line: Set(varUser, User().Email); Set(varAccess,!IsBlank(LookUp(Voters, Title = varUser).Title)) and then my vote button is just visible set to varAccess. Thanks so much for your help with this video!!

[@ShanesCows]

Thanks for sharing Jenn.

[@Balit0s]

Thx for sharing this ! this solve my problem straight away !

[@raghadm5719]

Thanks a lot for the video! 🤗 At 16:27 , what if I have Access as a choice field in SharePoint and not as a text field? Appreciate your support!

[@ShanesCows]

Access.Value = "Full"

[@nAhmd1]

Hi Shane, fab video tutorial, as always. Quick question, is there any way to hide a button once clicked?

[@ShanesCows]

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

[@nAhmd1]

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.

[@jenniferfoust1193]

Your videos have helped me so much. Thank you so much for what you do!! I have a question that I can't find the answer to. Let's say someone enters an email in a field, and I only want a button to appear to that email user when they're logged in, but I don't know the email address to start with. Do you know how I could tell it to show the button based on the email entered in the other field, without knowing the email? How do I target the value without knowing what it is? Is this possible?

[@ShanesCows]

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

[@jenniferfoust1193]

@@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!

[@bini2036]

its 2021 and this is still useful. Thank you!

[@ShanesCows]

Awesome 😎

[@swapnabendi234]

Hi Shane, Quick Question!! Can You Please prepare a video for creating our own Database for testing purpose. It will helpful for practice too.

[@ShanesCows]

Like this maybe? kzbin.info/www/bejne/eYCZqZmYn9OMrcU

[@adriennemcgowan8242]

Shane this is exactly what I need. However, I can't seem to get the varUserEmail to work. It returns blank. However, if I just use User().Email it works fine. What am I doing wrong? I am using a SharePoint list that contains the email address.

[@adriennemcgowan8242]

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

[@ShanesCows]

Awesome thanks for sharing 😀

[@srinivas.g09]

Hi Shane, Thank you it is very useful. If the Access list having people or group column with multiple users and Role . How can we hide and show the buttons.

[@ShanesCows]

I haven’t done a group column. Sorry

[@srinivas.g09]

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

[@olabodemoboluwarin2768]

Thank you very much, Please I am trying to hide a checkbox that has been checked by the user, while other checkboxes which are still unchecked will be visible when the user re opens the form. I am unable to use Isblank as the checkboxes always returns either a true or false value into my list. Please help. Thank you

[@ShanesCows]

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

[@mustafahussainmohsin320]

Hello Mr Shane, Again nice video, I would like to ask, am I able to show the button for two different People, the HR and the Manager only, how can I add both the variables in visible property of that button. Help

[@ShanesCows]

Put an Or between the two = formulas

[@triciabautista1142]

Hello Shane as I put the LookUp(AccessControl, Title = varUserEmail).Title on the label for testing it shows that 'powerapps encountered an internal error trying to evaluate this expression'. How can I solve this?

[@ShanesCows]

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

[@olivelake2807]

Hi Shane! First thanks a lot for the VERY useful video! I'm trying to hide button when our app is embed in sharepoint and visible when the app is opened on mobile or tablet device. Any idea?

[@ShanesCows]

.... 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.

[@venkatagavili6249]

Hello Shane, Great video lesson, if I have buttons in a gallery how do I show or hide buttons in a gallery based on user login and items in my gallery are ["Home","My Team"] only want to show "My Team" button when the admin team logins in Let me know how to do that

[@mls1871]

Hi, nice video again! How does it work when in sharepoint, you used a "choices" or "person" column instead of a text? I am keep on having errors?

[@ShanesCows]

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

[@maggieho9521]

Hi Shane, good info!. I have a reset button to reset all combo boxes; reset(cboABC). When click on reset button, my gallery info/data are disappeared. Anything I missed? Thanks.

[@ederjimenez8]

is the logical funtion "or" still available today? I´m traying using ir but I get error on Power Apps

[@ShanesCows]

Yes it is. Make sure you capitalize the O in Or

[@ederjimenez8]

@@ShanesCows the function lower is also important, thanks a lot🙏

[@sounderparthiban5810]

Hi Shane, It is useful Video. Have a question. I created an app which consists of 3-4 screens and it's working for me during the edit mode. actually when ai share with my peers its directly getting into the new entry form. where in my idea is that when I share the app it should show the Home screen(only few buttons for TMs) first and then from home screen it show the new entry form when click Submit new entry. Also I have supervisory access button in the home screen and that should show only to few people. pls help

[@AbhimanyuDawar]

Hi Shane, great video not just this but all the ones I have seen so far. Very easy to follow and apply. I love the pro tips and the pitfalls you share. Using the above example please share how can I extract an email address using the Person field in the SharePoint list, thanks!

[@ShanesCows]

PersonField.Email

[@jwh7933]

Thank you so much for making this video! Coming from a SharePoint background, I knew there HAD to be a way to do this! On another note, what do you think the expiration date for the classic SP permission groups, esp since Office 365 groups have now been released..... I will have to check for that video you were going to make. Thanks again!

[@ShanesCows]

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

[@Jimmy_Winberg]

May i ask how to do the access list but with a people column? It does not seem to work when i try it.

[@ShanesCows]

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

[@jimmywinberg8460]

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

[@toniserrano6167]

Fantastic video! I have already applied it in my environment. Many thanks

[@ShanesCows]

Awesome

[@Fernando_Calero]

Hi Shane, great training, as usual, thanks! Also, I created the Access field in a SP list as choice type and that generated an "invalid argument type" error. I changed it to Single Line Text and everything went smoothly afterwards.

[@ShanesCows]

Glad you got it 😀

[@dianegood1319]

Thank you Shane!! I always enjoy your videos. But as usual my scenarios are different from your examples and I can't get some of my stuff to work. Please help....uuurrrrgggghhh! I am using a SharePoint list and I want to show/hide based on if the user equals the person showing in a person/name field. Is that possible? This code is not working: !IsBlank(LookUp('SharePoint List Name',PersonColumn.Email = varCurrentUser.Email)). I have also used varUserEmail but that and all kinds of different ways is not working. Please help!!

[@ShanesCows]

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

[@jlemoo2]

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.

[@juanjo2391]

Hi Shane nice video! I was wondering if you already created a video where insted of "fixing" the email to display the button it goes and compares against an Azure AD security group to determine if the condition is true or false? Thanks!

[@ShanesCows]

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. 😑

[@juanjo2391]

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 😃

[@PeterHeffner]

As always, a great video, Shane! Any chance to check the Sharepoint permissions groups for user().mail? This way we wouldn't have to maintain another AccessControl list in Sharepoint.

[@ShanesCows]

Not that I know of. 😐

[@adrianparker5841]

Hi Shane, your really doing great work here. I have a query. I get get the command to work when only looking at the varUserEmail, when I add "And =" section, I'm getting an error on the = saying Invalid argument type. Have you any suggestions?

[@ShanesCows]

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

[@papithasekar9608]

Hi Shane, Thank you for the video. Am trying to hide a datacard if the user has not filled the value in it. My scenario: User has to select the hours and min from the drop down. If they didn't enter overtime, then I would like to hide the datacard in detail screen. Will you able to help me to do achieve it.

[@ShanesCows]

Use IsBlank to check if the field has been filled in

[@lagenteestaloca5875]

Thanks Shane, great material. Love your videos - very informative and fun to watch!.. Shane I wonder if you'd be able to to advise. I am new to PA's. I'm doing a flow project where I get a shift swap request form. The old paper form had to have signatures of parties requesting swap. In my app I am implementing checkboxes that are ticked by both parties participating in shift swap. Unless both boxes are ticked, the Submit button is not visible. I am using the string for Submit button: If(Checkbox1.Value = true && Checkbox1_1.Value = true, true, false) is there a way to make this Submit button to trigger submit action once it becomes visible? I hope it makes sense. Thanks heaps again for great material you're putting out.

[@ShanesCows]

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. 😀

[@lagenteestaloca5875]

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

[@hpchristener]

Thank you for this video. The show/hide switching somehow doesn't work properly in my app: for some of the eligible persons the button is shown and for some of the same list it is not. It even happens that the button is shown and later the same day it is no longer visible. What could be wrong?

[@ShanesCows]

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

[@hpchristener]

@@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.

[@colby4390]

I have created the global variable you did and then to verify I placed the variable name in the text field of a label and it is blank. I have both connectors Office365Users and Office365Outlook. The only way that works is when using User().Email. I am not sure what I am doing wrong.

[@asimrehan73]

Nice Video Shane, i am wondering if it’s possible to show/hide button based on user being part of a member group of the Sharepoint list? Can Powerapp recognise, what is the level of rights the user have for that sharepoint list ?

[@ShanesCows]

Not that I know of Asim

[@lfish894]

Hi Shane, as always a great educational video. One question, if you have a power app who’s data is based on a SP list, can you restrict access to the whole list and still allow users to use the app. (Form based app)

[@rickysydney4208]

hi Shane. Can you restrict based on AD group? For example if i sent the visibility based on someone AD group., will everyone who is part of that AD group see the list?

[@ShanesCows]

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.

[@michaelshelnutt3534]

Do you have a video similar to this on how to make the Button's action contingent upon a drop down item on the same page?

[@ShanesCows]

Yes Sir! kzbin.info/www/bejne/qWmYmmuLjNxlh68 😀

[@manideepmalyala]

Hi shane, this is the tutorial i'm looking for thank you but thing is i need to implement this on model driven app custom ribbon buttons i.e., only particular users must see the custom ribbon button, can you please help thank you!

[@DanielADamico]

Hi Shane, good video! However, I would like to see you giving more examples of security using CDS instead of SharePoint. Using Power apps along with SharePoint lists to control security is not a good idea because as you know, the users of the app will need to have access to the SharePoint lists and they could easily change the list contents and bypass the app security you implemented.... 😊

[@ShanesCows]

I am working on a proper CDS intro series. So many little things to cover to do it well.

[@travellingstu]

They only need view access to the list for this to work

[@DanielADamico]

@@travellingstu This is true for this example, but often you'll also have personal/confidential information that sometimes you don't want to be shared/viewed by other users.. ☹️☹️

[@travellingstu]

@@DanielADamico In these cases i use a 2010 workflow using an impersonation step to restrict the permissions on create

[@Flick2025]

Also would like to see more of these apps done with CDS

[@naokoh8069]

Hi Shane, I am so excited to see your KZbin and increase some knowledge about Power Apps. Now, I have trouble with Gallery & Visible. Sometimes, Gallery's text goes "blank" even if there is a certain text. But after clicking Gallery again, it works. Do you know something about it? Do I miss some trap?

[@naokoh8069]

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!

[@yehunlavolontededieu322]

Hmmm lol i didn't know chewy was there listening until 16:30. Another nice video, simple but great tactic. txs

[@ShanesCows]

Thanks 😀

[@pranjalsingh287]

Hey shane, awesome video. I needed to clarify one thing from you regarding the Add picture control. I have a powerapp where I am using the add picture control and pictures are getting stored in an azure blob storage. Everything works fine when the app is used via mobile. The issue is when I use the powerapp from desktop and try to save images, if I change the file extension from image files to all files, the browse pop-up let me also select files which are not images like doc or pdf. Technically only images should be there but other files are also getting stored in blob through this. Is there any way by which we can validate the add picture with only images. I tried the IsMatch() function with image regex but it didn't help much. What's your take on this?

[@ShanesCows]

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

[@StevieBirdBones]

This video is so helpful! For some reason I wasn't able to get the varUserEmail to work, however. It just wouldn't ever load, even on a label, and I followed the instructions exactly :(

[@ShanesCows]

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

[@StevieBirdBones]

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

[@Magmaviper_1]

I have a powerapp setup to only show a button when a user is logged in, but when the screen first loads, for a brief second the box shows up and is clickable by anyone (granted, you have to be very quick to click on it), it's like the button object loads before the visible formula loads. Is there a way to disable it by default, or make the screen not load until all the visible formulas have loaded?

[@ShanesCows]

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

[@shreyapandey1671]

Hi Shane, M following u last 1 yr and ur all videos is very useful & helpful. I've one query, m not able to find anywhere. My scenario is- 1. I've 11 PowerApps applications in same tenant. 2. I created 11 separate apps. I used 1 app as Master app, in Masterapp there is 10 SubApps. 3. Suppose 5 users have permission for only 5 SubApps but the problem is they (5 users) can also see the rest of 5 SubApps icon. 4. they don't have permission but still they can able to see those Apps icons, bcoz that all Subapps link in same screen whenever they click on those icon, it ask the permission. 5. So what i want is, Who don't have permission, they cannot able to see those apps icon. SOLUTION is there any way, they can only find those apps or they can only see those apps icon, which have had permission.

[@ShanesCows]

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

[@verdijason11]

Hey Shane - have you used (display:none;) functionality within Power Apps instead of (visible:none;) ? I'm achieving Visible: none; - what I need is Display:none; Because the element still takes up the same space when not visible.

[@ShanesCows]

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

[@verdijason11]

@@ShanesCows Thanks Shane!

[@dalelouie8200]

Share, in InfoPath I was able to do similar logic to hide a section (of controls). Can sections be created in Power Apps? Do you have a demo that shows how to do this?

[@ShanesCows]

Replied to the other comment

[@alleynesacademy1547]

HI Shane, your videos have been great, but I am struggling with this one. I have created an app and need to hide some buttons from certain users. I have created a list in sharepoint of the user emails that the button needs to be hidden from. I have tried adding and removing my own to test and it does not seem to work. any advice?

[@ShanesCows]

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.

[@alleynesacademy1547]

@@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.

[@alleynesacademy1547]

@@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.

[@EuroWin]

Such great videos! It helps me a lot for my job(MS Application Engineer). BTW, your attitude is so cool! Keep it up, Master Shane!

[@ShanesCows]

Thanks 😊

[@2009ians]

Great video! Did you do a video on securing by office 365 user group, or by a sharepoint owner group?

[@ShanesCows]

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

[@tomgardzinski5029]

Hi Shane Great video. I set my app up like this however I am having some trouble. On AppStart I stated set(VarEmail = User().email), however when I create a label to see what VarEmail is holding it returns a blank. Can you give me any pointers here?

[@tomgardzinski5029]

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

[@ShanesCows]

Awesome

[@shwetashetty2537]

Hi Shane, Great video. How can i use a user group instead of individual user email? or how can i decide whether to make the button visible based on the "Owner" " Co-owner" and "User" permission to the app?

[@gokurukay1234]

Hi Shane, Thank You for share this video it help solution my problem to manage user access permission.

[@ShanesCows]

Glad it helped

[@prashanthdiddi7199]

Hi Shane, This video is amazing..! When are you planning to do a video on controls to show/hide based on member from Active Directory group? or from SharePoint group, if possible?

[@ShanesCows]

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

[@ATLANTAHOSANNATELUGUCHURCH]

Can you please suggest "How to disable Button (Button Name : Assign Manger- also this "Assign Manger" Button It's associated with Power Automate Flow ) in PowerApps after one click Button should be disabled). It would be very helpful ,if you could provide any reference link.

[@ShanesCows]

You would need a variable that gets set to true when they click the button. Then set the buttons display mode to be tied to the variable. Sorry, I don't have a video on this.

[@ATLANTAHOSANNATELUGUCHURCH]

@@ShanesCows Thank you 🙏

[@NaveenKumar-wf3rf]

Thanks Shane. I have a question, how to make fields/drop-down boxes visible in PowerApps onstart? Those fields are visible when I use the preview mode in PowerApps studio. But when I play the app, it is not visible. I haven't created fields using form option. I have created every fields individually and I have patched to SharePoint list. Thanks in advance 👍

[@ShanesCows]

Did you publish your changes after saving.

[@NaveenKumar-wf3rf]

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

[@ShanesCows]

Correct

[@NaveenKumar-wf3rf]

@@ShanesCows thank you 😊. Let me try.

[@NaveenKumar-wf3rf]

@@ShanesCows Thank you Shane 👍. It worked.

[@illmatic1668]

Hi Shane, thanks for this! I am running into an issue i can't seem to figure out. When testing on a label, the LookUp formula as entered always returns blank instead of printing an email. PowerApps always tells me no records can be found even though records exist. Do you know what would cause this? Thanks in advance.

[@ShanesCows]

I would guess you have a typo in your lookup.

[@alec5443]

Are you going to make a video on the powerapps portal option?

[@ShanesCows]

I need to for sure. 😀

[@akbarmahfuzalam]

How would I disable the button based on the date picker value? If I selected a date say 2nd April 2021 and I don't want the user to click the button till he reaches 2nd April 2021. Now the app user is sitting on 24th March 2021.

[@bonnis33]

Hi, Shane. The fist 7 minutes are grate! Then I am stuck! I type in OnStart on the app: Set(varUserEmail, User().Email), the text box goes blank. Shows no errors or mistakes. But on the OnStart it says: "powerapps encountered an internal error trying to evaluate this expression" Hoping you are getting this or someone else on this comment section can help.

[@diallolaouratou530]

Hey @shane I have a sharePoint list name which holds the email addresses "AccessControl " The column name where email addresses are listed is "EmailList" I tried this but it did not work. After setting this: Set(varUserEmail, user().Email) LookUp(AccessControl, EmailList = varUserEmail).EmailList Any suggestion. Thanks.

[@ShanesCows]

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

[@simonball5602]

Great stuff Shane. A true MVP.

[@ShanesCows]

Thanks Simon

[@Amr-Ibrahim-AI]

Thanks for the comprehensive lesson

[@ShanesCows]

Glad to help. 😀

[@samratguha8933]

1 more question I had in mind is that is it possible o control the visibility of a field based on a SharePoint Group (suppose if I don't belong to Group XYZ I can't edit/view some fields)

[@ShanesCows]

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

[@RyuzakiF]

Quick Question: So if I use a lot of User365 and group and user functions it's better to make all of them into variables at the start of the app? Or in another places of the app according to the situation?

[@ShanesCows]

I lie variables onStart for those.

[@RyuzakiF]

@@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

[@dalelouie8200]

Shane, in InfoPath I was able to use similar logic to hide a section (of controls). Is there any way to create sections within a Power Apps form and hide the section using the logic in this video? If it makes any difference this is for a SharePoint Power Apps form.

[@ShanesCows]

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

[@dalelouie8200]

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

[@patricknassar3790]

Hi Shane, Thank you for this info. One question. I am putting "varUserEmail" as the replacement for "User().Email" (discussed around the 6min mark). I have done everything you said but when I put varUserEmail in the code, my button stays disappeared. It works with "User().Email". And no error pops up. Any suggestions?

[@ShanesCows]

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

[@felipperibasbarboza9454]

Hi shane how are you doing? Man I got stuck trying to hide a button if a value selected on my forms is equal to "No". I tried everything but without victory. Could you help me?

[@tedmeyer4231]

Hi Shane, good stuff. I am curious about load time. I built an app for my company and it has several buttons on the home screen. Each is either visible or not based on an access list value. When the app is first opened, the buttons all appear for a brief second and then they hide based on the evaluation. Is there a way to overcome this?

[@ShanesCows]

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

[@javipyo]

How can I make a button visible if the email is inside a field where I have stored several emails, the field is of the Person or Group type, I have tried a lot but not without success

[@ShanesCows]

Look for my video on the In operator. It is a recent one.

[@canasman11]

Awesome video Shane. Keep up the good work.

[@ShanesCows]

Thanks Manny

[@rajeshy9363]

Hi, How to hide or display input box if current user is a manager

[@ShanesCows]

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

[@justinabel6733]

Is there a way to lookup by current user and then check to see if that columns "yes/no" field is set to yes to display the button?

[@ShanesCows]

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

[@verdijason11]

Thanks Shane, great video! Although I was unable to replicate [ LookUp(AccessControl, Title = varUserEmail).Title ] when customizing a SharePoint form. I am attempting to show/hide sections of my edit form based on user group. Any ideas?

[@verdijason11]

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

[@ShanesCows]

Glad you got it. 🤩

[@ClarkyXR]

Awesome video, thank you!

[@ShanesCows]

Glad to help

[@MikeSunTzu]

The problem is even though the button's not visible it is still active. It needs to disable too???

[@ShanesCows]

If the button is not visible then you cannot click it.

[@ambujaable]

One requirement i have, i want to see Microsoft team schedule / shifts in power app gallery, could you please guide me on the same ?

[@ShanesCows]

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

[@khalidmullawns]

Thank you Shane, you made my day

[@ShanesCows]

Awesome.

[@mblherry]

If there a way to hide a row in a gallery based on the user without using filters?

[@ShanesCows]

This video kzbin.info/www/bejne/Y4fEcneKibWMo8k

[@ShanesCows]

Oh wait that required filter. I don’t think I have an answer

[@samratguha8933]

Hi, Shane Thank you for being so informative this video really helped me a lot, as I was unable to perform the task based on the user from a List. I have a request if you could upload a video about the validation of a form (for both SharePoint and Non-SharePoint fields). Thank You in advance.

[@ShanesCows]

I do some validation in this video not using forms kzbin.info/www/bejne/f6fEoXypd8eAY7c

[@hailm03]

Thank you a lot! You have save my day

[@ShanesCows]

Happy to help. 😎

[@fnanfne]

Hahahaha, I was laughing so hard at Chewy! Great video once again!

[@ShanesCows]

🐶 is always so fun

[@tomaskavicky]

great video Shane, thanks a lot

[@ShanesCows]

Glad to help. 😀

[@vvaassaanntthh]

Hi @shane I need help with this below. this is regarding a "If" Statement that controls visiblity of a checkbox. in my SharePoint list (named "Reps for FLSMs"), I have a column called "HOS BUH Email" that is basically a column containing second level Approver email addresses. I have a checkbox "Select All" which should ONLY display when the logged in user is the same as one of the users in that "HOS" column above. so in the "visible" property of the checkbox, I provide this formula (which I think is correct), but it doesn't seem to work. I ve tried so much but no luck. can you help me identify what's wrong with this statement below? If('Reps for FLSMs'.'HOS BUH Email'=User().Email,true,false)

[@alfonsolans]

Great Material Shane thanks a lot for your great help appreciate it, keep on rocking Bold Zebras

[@ShanesCows]

My pleasure!

[@jonathanlloyd8920]

Why doesn’t varUserEmail work in my power app? It doesn’t even turn blue?

[@ShanesCows]

Did you create it on App OnStart?

[@dougsmith6283]

VarEmailUser does not show up for me :( its underlined and red error.

[@ShanesCows]

You have to create it. In App OnStart Set(varUserEmail, User().Email)

[@dougsmith6283]

@@ShanesCows Thanks Shane!