Get List filter data from SharePoint list

To get the filter data form SharePoint List we generally need to loop through the entire list to get the filter value.

But SharePoint online offers an application page to display the unique values for filtering the data further.

Here is the application page URL

[SharePoint Site URL] + “/_layouts/15/filter.aspx?ListId={[List GUID]}&FieldInternalName=[Internal Name of the field]&ViewId={[View GUID]}&FilterOnly=1&Filter=1

 

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s