cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
VictoriaH
Advocate II
Advocate II

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!

5 REPLIES 5
v-yamao-msft
Community Support
Community Support

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.

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.

 

 

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

Just to add information to future readers, apparently the ContentType field is translated to your Sharepoint local language. For me, using Sharepoint in Portuguese, the correct query would be

ContentType ne 'Pasta'

Great, thank you.

 

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors
Users online (3,035)