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

5 жыл бұрын

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.

@ShanesCows

4 жыл бұрын

Thanks 🙏

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

3 жыл бұрын

Awesome 😎

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

@ShanesCows

5 жыл бұрын

Very cool

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

@ShanesCows

5 жыл бұрын

Awesome

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

4 жыл бұрын

Glad you got it 😀

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

9 ай бұрын

🤣 Glad it was helpful!

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

2 жыл бұрын

Thanks 😊

Awesome video Shane. Keep up the good work.

@ShanesCows

5 жыл бұрын

Thanks Manny

its 2021 and this is still useful. Thank you!

@ShanesCows

3 жыл бұрын

Awesome 😎

Thanks for the comprehensive lesson

@ShanesCows

4 жыл бұрын

Glad to help. 😀

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

@ShanesCows

3 жыл бұрын

My pleasure!

Great stuff Shane. A true MVP.

@ShanesCows

Жыл бұрын

Thanks Simon

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

@ShanesCows

3 жыл бұрын

🐶 is always so fun

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)

Thank you Shane, you made my day

@ShanesCows

3 жыл бұрын

Awesome.

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

@ShanesCows

4 жыл бұрын

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?

@ShanesCows

5 жыл бұрын

Yuppers

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

4 жыл бұрын

PersonField.Email

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

5 жыл бұрын

Not that I know of. 😐

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

4 жыл бұрын

I do some validation in this video not using forms kzread.info/dash/bejne/e6qV0quscsWzXbg.html

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

2 жыл бұрын

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

Awesome video, thank you!

@ShanesCows

2 жыл бұрын

Glad to help

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

@ShanesCows

4 жыл бұрын

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

Excellent One! Thank for same

@ShanesCows

5 жыл бұрын

Happy to help

Thanks Shane, awesome!!

@ShanesCows

4 жыл бұрын

You are welcome :)

great video Shane, thanks a lot

@ShanesCows

3 жыл бұрын

Glad to help. 😀

Thank you a lot! You have save my day

@ShanesCows

Жыл бұрын

Happy to help. 😎

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

@ShanesCows

3 жыл бұрын

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

3 жыл бұрын

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

Life saver thanks so much!!

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

@ShanesCows

2 жыл бұрын

Glad it helped

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

3 жыл бұрын

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

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

4 жыл бұрын

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

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?

Great Guide !

@ShanesCows

4 жыл бұрын

Thanks 🙏

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

3 жыл бұрын

Like this maybe? kzread.info/dash/bejne/dYNq2sibmtG_p8Y.html

Thanks, it helps me.

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

5 жыл бұрын

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

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

4 жыл бұрын

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

4 жыл бұрын

@@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! you are amazing

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.

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

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

3 жыл бұрын

I think this video will help. kzread.info/dash/bejne/pWxpy5qOh9qYgbA.html

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

3 жыл бұрын

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

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

3 жыл бұрын

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

3 жыл бұрын

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

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!

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

3 жыл бұрын

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

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

5 жыл бұрын

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

Awesome. Thank you.

@ShanesCows

3 жыл бұрын

You bet!

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

3 жыл бұрын

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

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.

Hi Shane, I am so excited to see your KZread 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

2 жыл бұрын

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!

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

@ShanesCows

5 жыл бұрын

I need to for sure. 😀

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

3 жыл бұрын

Yes Sir! kzread.info/dash/bejne/pWxpy5qOh9qYgbA.html 😀

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

4 жыл бұрын

Put an Or between the two = formulas

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.

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

4 жыл бұрын

Use IsBlank to check if the field has been filled in

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

3 жыл бұрын

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

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

@ShanesCows

3 жыл бұрын

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

@nAhmd1

3 жыл бұрын

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

3 жыл бұрын

One option would be like I show here. kzread.info/dash/bejne/kYWi3JaSlavZldY.html

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

3 жыл бұрын

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

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

4 жыл бұрын

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

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

4 жыл бұрын

I haven’t done a group column. Sorry

@srinivas.g09

4 жыл бұрын

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

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

4 жыл бұрын

I would guess you have a typo in your lookup.

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.

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

4 жыл бұрын

Not that I know of Asim

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

3 жыл бұрын

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

Hello Shane! Do all the Powerapps users need to have access to your “Access Control” list in order for this to work?

@ShanesCows

3 жыл бұрын

Yes, but only read access.

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

3 жыл бұрын

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

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

4 жыл бұрын

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

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

4 жыл бұрын

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

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

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

4 жыл бұрын

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

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

3 жыл бұрын

Replied to the other comment

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

3 жыл бұрын

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

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

2 жыл бұрын

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

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

4 жыл бұрын

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

@hpchristener

4 жыл бұрын

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

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?

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

3 жыл бұрын

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

@dalelouie8200

3 жыл бұрын

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

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

3 жыл бұрын

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

3 жыл бұрын

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 😃

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

4 жыл бұрын

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

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

4 жыл бұрын

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

@ShanesCows

4 жыл бұрын

Glad you got 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?

@ShanesCows

3 жыл бұрын

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.

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

3 жыл бұрын

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

@StevieBirdBones

3 жыл бұрын

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

@ShanesCows

4 жыл бұрын

I lie variables onStart for those.

@facundogorla8772

4 жыл бұрын

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

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

3 жыл бұрын

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

3 жыл бұрын

@@ShanesCows Thanks Shane!

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

5 жыл бұрын

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

@jimmywinberg8460

5 жыл бұрын

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

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

@ShanesCows

4 жыл бұрын

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

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

9 ай бұрын

Access.Value = "Full"

thanks good stuff

@ShanesCows

Жыл бұрын

Glad you enjoyed it

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

4 жыл бұрын

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

@ShanesCows

4 жыл бұрын

Awesome thanks for sharing 😀

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

5 жыл бұрын

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

@travellingstu

5 жыл бұрын

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

@DanielADamico

5 жыл бұрын

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

5 жыл бұрын

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

@Flick2025

5 жыл бұрын

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

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

4 жыл бұрын

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

@ShanesCows

4 жыл бұрын

Awesome

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

3 жыл бұрын

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

@jlemoo2

2 жыл бұрын

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.

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

4 жыл бұрын

Did you publish your changes after saving.

@NaveenKumar-wf3rf

4 жыл бұрын

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

@ShanesCows

4 жыл бұрын

Correct

@NaveenKumar-wf3rf

4 жыл бұрын

@@ShanesCows thank you 😊. Let me try.

@NaveenKumar-wf3rf

4 жыл бұрын

@@ShanesCows Thank you Shane 👍. It worked.

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

@ShanesCows

4 жыл бұрын

I like candy.

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.