You are setting up the variables on the App OnStart. So, as long as I keep the app open and I do not refresh it, I will have whatever permissions you gave me when I opened the app even if you change my permissions on the SharePoint list afterwards. I think it would be better to put the variables on the screen's OnVisible property so that it is updating every time I go back to the screen.
This is exactly what I've been looking for, but I used a choice column for my roles and now I get an error of invalid type. Is there a different way to format the Role.Value = "Admin" for choice columns?
@@OptimalTrainingGroup yes, it was just a multi-select choice also...so the ability to select more than one option in each..so approver and reviewer and admin
I had no luck until I switched around the email and the role in LookUp, and I also removed the setCurrentUser. My formula looked like this: Set(isUserAdmin,IsBlank(LookUp('Roles SharePoint List', Role.Value ="Admin" && UserName.Email = User().Email)))
Man!!! I have been looking and asking how to do this for soooooo long. Thank you very much for showing this. Very awesome indeed
You're welcome!
You are setting up the variables on the App OnStart. So, as long as I keep the app open and I do not refresh it, I will have whatever permissions you gave me when I opened the app even if you change my permissions on the SharePoint list afterwards. I think it would be better to put the variables on the screen's OnVisible property so that it is updating every time I go back to the screen.
Good point. Thank you!
Good video. Thanks for making this.
Very helpful indeed!
This is exactly what I've been looking for, but I used a choice column for my roles and now I get an error of invalid type. Is there a different way to format the Role.Value = "Admin" for choice columns?
Are you sure you used a choice column? I did as well for the Role field.
@@OptimalTrainingGroup yes, it was just a multi-select choice also...so the ability to select more than one option in each..so approver and reviewer and admin
I had no luck until I switched around the email and the role in LookUp, and I also removed the setCurrentUser. My formula looked like this:
Set(isUserAdmin,IsBlank(LookUp('Roles SharePoint List', Role.Value ="Admin" && UserName.Email = User().Email)))
It is possible to calculate like year and month
Yes, you can do that. You can use the different PowerApps Date functions.
@@OptimalTrainingGroup thanks I will check
This site will help you www.matthewdevaney.com/all-power-apps-date-time-functions-with-examples/
@@OptimalTrainingGroup thanks v much...