How to Filtering data using rest API which is fetched from Document library in SharePoint
I able to fetch the documents that are uploaded into the document library of SharePoint online. Now I want to filter the contents that are fetching based on a Lookup column and Choice column. But filtering is not working in rest API. What Can i do?
So Please,Can anyone help me?
Below is the part of the url which I am using.
filter=FieldValuesAsText eq ‘Data.xlsx'",
If you want to filter data by file name, we can use the rest api below.
FileLeafRef eq 'Data.xlsx'
If you want to filter data base on lookup field and choice file, we can use this. In my test, the lookup field is "Lookup1" and choice field is "Choice1".
$Filter=Choice1 eq 'Choice1' and Lookup1/Title eq 'lookup1'