Forum Discussion
How To Customize SharePoint List View Filter Conditions in sharepoint online
I already have list library with data, and in that list library I have column called-Vendor, and i want to filter list library on the basis of value of that column.
Column can have following values
IT
Infra
Finance
and user which visiting on page can belong to any of the above vendor, so he only can see list items having same value in Vendor column.
so I am thinking to create sharepoint group and mapped user to sharepoint group, and then filter list with value of vendor column=sharepoint group of user.
is there anyway I can do this?how to do this using sharepoint group ?
rautchetanHere is an Idea. You create 3 groups IT, Infra, Vendor..
You then create a power Automate that runs when ever an it is created/Modified... In the Power auomate which is triggered when the item is created or Modified you check what is the Value. Based on the Value you assign item level permission for that item using power automate sharepoint connector... Its Simple to do it ...
if I assign permission using power automate for each item and also created sharepoint groups,so whenever users visit page, he only able to see list items which assigned to group same as current user group automatically? filtering automatically done and we don't need to do anything?
Can I use power automate with Classic sharepoint online? and what about existing list items?
Do I need to update them manually?
rautchetan . Yes you can use poweraoutomate with classic as in your case it is running behind the scene.
If there are a Lot of items , you can create a manual trigger flow to loop through all the items in your list and perform the same action (assign unique permission).
You will maximum need 2-3 hours to do this.
