cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
VictoriaH
Level: Powered On

OData Filter on IsFolder eq false - column name not found - SharePoint Get Files Action

When I attempt to use the action "Get Files" with an OData query of:
IsFolder eq false


I get an error:
{  "status": 400,  "message": "Column 'IsFolder' does not exist. It may have been deleted by another user.\r\nclientRequestId: aa892d84-80e4-4e90-8e9d-58740ba1cc48\r\nserviceRequestId: 50de9e9e-60f9-7000-6e56-71cead85477b"} 

 

Yet, if I just get files, IsFolder is an output property:
IsFolder
false

 

I've looked up all the variations I could find of how "IsFolder" could be spelled and tried them all from:
1. isFolder eq False - doesn't exist
2. isfolder eq False - doesn't exist
3. {IsFolder} eq False - Syntax error
and so on...

 

Any thoughts? Is it not possible to filter on the IsFolder property? Or is there unique syntax to use?

 

Thanks!

3 REPLIES 3
Community Support Team
Community Support Team

Re: OData Filter on IsFolder eq false - column name not found - SharePoint Get Files Action

Hi @VictoriaH,

 

Currently, it is not possible to use filter query on output properties. If you are trying to filter based on output properties, please consider adding a Condition.

Besides, another workaround is to add a custom Choice (or Yes/No) column named as IsFolder, then you could use Filter query based on this column.

Please take a try with it on your side.

 

Best regards,

Mabel

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
VictoriaH
Level: Powered On

Re: OData Filter on IsFolder eq false - column name not found - SharePoint Get Files Action

Thank you for the response and sharing that information.

 

Although this is an output property field, is OData query not capable of seeing this property field of the library? It has been able to filter for my custom columns. What is different about the IsFolder property that it can't filter it?

 

Thank you for the recommendation. I already use a condition, but it is inefficient when combined with the over 5k item behavior. My hope was to limit the OData query to a more specific set by excluding the folders and potentially staying under the 5k threshold. If filtering out folders early on cannot be done, I'll have to add the other indexed columns and require them in my flow to force the results to be under 5k. It'd be better to require less data entry to kick off the flow, but it's the next step if we confirm that IsFolder is somehow unique from all the other columns.

 

 

3AConsulting
Level: Power Up

Re: OData Filter on IsFolder eq false - column name not found - SharePoint Get Files Action

Albeit very late, but if someone is still looking for a solution for this. In the Filter you can filter on ContentType.

If you add ContentType ne 'Folder' or if you want to limit to a specific contenttype ContentType eq 'your contenttype' that should filter out the folders in your library.

 

This should do the trick. Hope this helps someone.

 

Regards

 

Guy De Backer

3A ICT Consulting

Helpful resources

Announcements
firstImage

Power Platform Online Conference

Speakers, submit your sessions now! Call for speakers ends Feb. 10!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (4,529)