Dear all ,
I would like to get items whose "Assigned to " column is blank by using Filter Query in Get items action.
I leave blank or null in the Filter query filed . but both of them don't work.
Thanks
You can use the expression AssignedTo eq null (type null as text in the filter query not the expression null)
Please replate AssignedTo with column name of your choice
This will help you in retrieving the values from SharePoint where the column name "AssignedTo" contains blank values.