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!
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 .
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 :)
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?
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!
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?
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?
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!
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?
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?
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.
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.
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?
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!
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
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!
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 😃
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.
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!!
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!
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
Hi Shane, I am so excited to see your TH-cam 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?
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!
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!
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.
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?
.... 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.
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!!
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.
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?
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 ?
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?
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.
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?
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.
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?
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.
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
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?
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.
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?
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 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.
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?
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
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.
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?
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 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.
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.
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?
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.
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
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.
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 :(
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 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
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?
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 👍
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)
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?
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
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)
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.... 😊
@@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.. ☹️☹️
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?
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!
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.
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.
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
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.
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.
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?
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.
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?
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.
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.
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.
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!
Happy to help
Good video! There is not too much content available for these scenarios and you really hit the nail in the head with this video.
Thanks 🙏
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.
🤣 Glad it was helpful!
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 .
I think this video will help. th-cam.com/video/s85i8UWw2QM/w-d-xo.html
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 :)
Awesome 😎
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?
Zach can you give me a time stamp where I mention it? I don't remember which video anymore. Sorry.
Thank you, Shane!! This perfectly addresses a business problem we currently have!
Very cool
Excellent Video Shane! Do you have a video showing how to make a field hidden or visible if a checkbox is clicked?
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.
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 ?
One option would be like I show here. th-cam.com/video/_Qnz4YeHses/w-d-xo.html
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!
Access.Value = "Full"
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!
Glad you got it. Yup, Concat was the answer I was going to give. :)
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!
Thanks 😊
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?
Yes, hide the button to navigate to those other screens with the technique from this video.
Awesome!!Although I have a concern that why are the videos blurry?? For most of the powerplatform tutorials videos are blurry...
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?
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!
PersonField.Email
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?
Yuppers
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?
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
Hi Shane, fab video tutorial, as always. Quick question, is there any way to hide a button once clicked?
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.
Great stuff Shane. A true MVP.
Thanks Simon
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.
I haven’t done a group column. Sorry
@@ShanesCows No Problem. I have tried and done it. Thank you Shane.
Hi Shane, Quick Question!! Can You Please prepare a video for creating our own Database for testing purpose. It will helpful for practice too.
Like this maybe? th-cam.com/video/CO6xfbjnYwc/w-d-xo.html
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?
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!
its 2021 and this is still useful. Thank you!
Awesome 😎
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
CheckBox.Value returns true or false. Set Visible property to be Not(CheckBox.Value) and that should do it.
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!
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 😃
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.
Glad you got it 😀
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!!
Thanks for sharing Jenn.
Thx for sharing this ! this solve my problem straight away !
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!
When you click the button Set a variable to be false. Set(varShowButton, false)
Have the button's visible property be varShowButton `
Fantastic video! I have already applied it in my environment. Many thanks
Awesome
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
Put an Or between the two = formulas
Hi Shane, I am so excited to see your TH-cam 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?
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!
Hmmm lol i didn't know chewy was there listening until 16:30. Another nice video, simple but great tactic. txs
Thanks 😀
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!
I don’t know about that. The permissions groups have been around forever 😑
Awesome video Shane. Keep up the good work.
Thanks Manny
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?
Yes Sir! th-cam.com/video/s85i8UWw2QM/w-d-xo.html 😀
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.
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 😀
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?
.... 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.
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!!
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.
May i ask how to do the access list but with a people column? It does not seem to work when i try 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
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?
Sorry I don’t remember the whole formula. Leave a new comment with the broken formula and I will try to help
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?
Type YourColumnName. and then see what it offers you for options. :)
is the logical funtion "or" still available today? I´m traying using ir but I get error on Power Apps
Yes it is. Make sure you capitalize the O in Or
@@ShanesCows the function lower is also important, thanks a lot🙏
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 ?
Not that I know of Asim
Are you going to make a video on the powerapps portal option?
I need to for sure. 😀
Hi Shane, Thank You for share this video it help solution my problem to manage user access permission.
Glad it helped
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?
Check the file name to see if it matches jpg or png
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.
Use IsBlank to check if the field has been filled in
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?
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.
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?
NOt sure. That looks correct to me. Maybe try it with a hardcoded email address first.
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.
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!
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?
Look in app settings. I think there is a setting that says Delay app start or something of the sort.
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.
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...
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?
SharePoint groups aren’t possible without calling Graph API. Azure AD groups maybe I cover one of these days not sure.
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?
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.
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?
Replied to the other comment
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
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.
I would guess you have a typo in your lookup.
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?
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.
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.
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?
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?
Ahh, nevermind, figured it out. A Save, Close, and reopen of the App did the trick.
Awesome
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.
Not that I know of. 😐
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
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.
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 :(
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!
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?
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
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?
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 👍
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.
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)
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?
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
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)
There is no easy way to reference SharePoint Groups. Maybe via Graph API.
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....
😊
I am working on a proper CDS intro series. So many little things to cover to do it well.
They only need view access to the list for this to work
@@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.. ☹️☹️
@@DanielADamico In these cases i use a 2010 workflow using an impersonation step to restrict the permissions on create
Also would like to see more of these apps done with CDS
Great video! Did you do a video on securing by office 365 user group, or by a sharepoint owner group?
I haven’t yet. SharePoint groups aren’t rally possible. 😔
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?
Did you make sure that there is a value stored in the variable?
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!
Thanks for the comprehensive lesson
Glad to help. 😀
Thank you Shane, you made my day
Awesome.
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.
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.
I bet you have an issue with capitalization. Shane =shane doesn’t work. Look at your email address again 😀
Hahahaha, I was laughing so hard at Chewy! Great video once again!
🐶 is always so fun
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
Look for my video on the In operator. It is a recent one.
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.
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.
@@ShanesCows Thank you 🙏
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?
Nevermind - your solution works, I forgot to add another "SharePoint list" data source, thanks!
Glad you got it. 🤩
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?
That is shown in this video, you will need to slightly pivot and change your LookUp to have a criteria of Field = yes
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.
Awesome video, thank you!
Glad to help
Great Material Shane thanks a lot for your great help appreciate it, keep on rocking Bold Zebras
My pleasure!
One requirement i have, i want to see Microsoft team schedule / shifts in power app gallery, could you please guide me on the same ?
Haven’t done it before. Sorry. Look to see if there is a connector
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?
great video Shane, thanks a lot
Glad to help. 😀
If there a way to hide a row in a gallery based on the user without using filters?
This video th-cam.com/video/-VaADTTPYmg/w-d-xo.html
Oh wait that required filter. I don’t think I have an answer
The problem is even though the button's not visible it is still active. It needs to disable too???
If the button is not visible then you cannot click it.
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.
I do some validation in this video not using forms th-cam.com/video/IvapIsBbM-U/w-d-xo.html
Hi,
How to hide or display input box if current user is a manager
You have to apply the concepts from the video to lookup if the person is a manager.
Thank you a lot! You have save my day
Happy to help. 😎
Another great video from you. THX a 1000 times. But you are eating to much candy. The candy box in the background are emtpy??? :D
I like candy.
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.
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.
Not that I know of. YOu will need to write logic to manage that yourself.
VarEmailUser does not show up for me :( its underlined and red error.
You have to create it. In App OnStart Set(varUserEmail, User().Email)
@@ShanesCows Thanks Shane!
Why doesn’t varUserEmail work in my power app? It doesn’t even turn blue?
Did you create it on App OnStart?