Hey Daniel, the video was very helpful, although my goal is to make it so everyone in the team can add new items in the Power App, but then i need to make an app so only a few people may view all the items of the list in an app. The radio button solution would keep those people from viewing all the entries and i surely don't want to make them all site owners. Basically it is a work order list for employees to submit work order requests and then the maintenance staff can view them and mark them done or whatever.
Daniel thanks, that's a very good explanation. However, I would like to propose another quick solution to protect the Power Apps Users from having access to the list, and that is by creating a new customized permission level in sharepoint site settings where you can uncheck this particular option "View Application Pages - View forms, views, and application pages. Enumerate lists". This will prevent users having this new custom permission level to access the list through sharepoint site or through microsoft lists app. This custom permissions option is very handy. I have tried and tested the above method, you can do that as well and give your feedback. Thanks
Thanks Daniel. Questions ;) If you disable search on a list but have a search function in your app does search in the app still work? What is the best way if you have to secure list items to a group of people and not an individual? e.g. you have a group of people that can edit some records but not all. Say you have groups of 5 people who edit one set of data and other groups of people editing another. I have used filters in the apps to do that but wondered if there was a better way. Saw Reza do something like it with folders in lists and security on the folders, but it requires you to move items with a flow. Wouldn't feel to comfortable with the flow failing. Best way I know of to keep people out of lists is to set up a custom permission level for contribute and remove the view application pages. people get access denied like that. Not sure if it is effective with the new mobile list apps.
That's a great question Phil. I need to test and verify but my educated guess is that the search or filter you do in Power Apps for a list will still work. Here's why - The search in SharePoint is based on the search indexing. Hence you unselect the search in the list, then the index shouldn't have the list information. Power Apps on the other hand (using api) directly searches the list.
Hi Daniel, great tutorial and very easy to follow. Are you able to use permission groups from the SP site in PowerApps to control access in PowerApps to limit what they can see? e.g. say I created a permissions group called a specific team (Procurement) and added in the team members in that group allowing them to view any SP list records, but they did not create them or modify them, is it possible to pass that SP permission group in PowerApps to filter on the Procurement permission group? Thank you for your time.
Thanks Daniel for the various tips on making lists more secured!
My pleasure!
This is very helpful Daniel. Thank you so much!
Glad it was helpful!
Hey Daniel,
Your all tutorial are very nice, specially in which you explained mixed reality.
Thank you for being here ☺️
My pleasure!
Awesome! Thank you very much! 💥
Glad you like it!
Yes Daniel its Awesome!
Thanks Akshay
Thank you! Daniel very informative
Glad it was helpful!
Great Daniel.
Great , that is really helpful
Glad it was helpful!
Hey Daniel, the video was very helpful, although my goal is to make it so everyone in the team can add new items in the Power App, but then i need to make an app so only a few people may view all the items of the list in an app. The radio button solution would keep those people from viewing all the entries and i surely don't want to make them all site owners. Basically it is a work order list for employees to submit work order requests and then the maintenance staff can view them and mark them done or whatever.
Daniel thanks, that's a very good explanation.
However, I would like to propose another quick solution to protect the Power Apps Users from having access to the list, and that is by creating a new customized permission level in sharepoint site settings where you can uncheck this particular option "View Application Pages - View forms, views, and application pages. Enumerate lists". This will prevent users having this new custom permission level to access the list through sharepoint site or through microsoft lists app.
This custom permissions option is very handy. I have tried and tested the above method, you can do that as well and give your feedback.
Thanks
Its VeryUseFull Deniel
Thank You Brother
Your welcome.
great, congratulations
Thank you!
Awsome
Thanks for the compliment, Yoginath
Thanks Daniel.
Questions ;)
If you disable search on a list but have a search function in your app does search in the app still work?
What is the best way if you have to secure list items to a group of people and not an individual? e.g. you have a group of people that can edit some records but not all. Say you have groups of 5 people who edit one set of data and other groups of people editing another. I have used filters in the apps to do that but wondered if there was a better way. Saw Reza do something like it with folders in lists and security on the folders, but it requires you to move items with a flow. Wouldn't feel to comfortable with the flow failing.
Best way I know of to keep people out of lists is to set up a custom permission level for contribute and remove the view application pages. people get access denied like that. Not sure if it is effective with the new mobile list apps.
That's a great question Phil. I need to test and verify but my educated guess is that the search or filter you do in Power Apps for a list will still work.
Here's why - The search in SharePoint is based on the search indexing. Hence you unselect the search in the list, then the index shouldn't have the list information. Power Apps on the other hand (using api) directly searches the list.
Hi Daniel, great tutorial and very easy to follow. Are you able to use permission groups from the SP site in PowerApps to control access in PowerApps to limit what they can see? e.g. say I created a permissions group called a specific team (Procurement) and added in the team members in that group allowing them to view any SP list records, but they did not create them or modify them, is it possible to pass that SP permission group in PowerApps to filter on the Procurement permission group?
Thank you for your time.
Hi Derek,
You can use the SharePoint permission groups but that requires API calls since there isn't a connector for it.
Hi Daniel, great video as usual....Would Microsoft Lists work in the same way
Yes, absolutely
Thanks Daniel
Thanks for the support!