Answered

Get SharePoint items from library where Retention Label eq 'General'

(3) Share

Report

Posted on by jherschel7

Hello,

I am trying to use the Power Automate Get files (properties only) action to get all files where the Retention Label is equal to 'General'.

CoPilot suggested using ComplianceTag or _ComplianceTag, but both were throwing errors: Action 'Get_files_(properties_only)' failed: Column 'ComplianceTag' does not exist.

Does anybody know how I can add a Filter Query to get files with certain Retention Labels?

Categories:

Connector development

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

WarrenBelz 155,840 Most Valuable Professional on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @jherschel7,

That is an internal field and I believe ComplianceTag is the Internal Name so
ComplianceTag eq 'General'

should be technically correct, however the standard odata query may not be able to see fields not directly exposed to it in the table.

You might try a HTTP request to SharePoint
/_api/web/lists/getbytitle('ListNameHere')/items?$filter=ComplianceTag eq 'General'

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
Vish WR 3,748 on at

Like
a
(2)

Report
Copy link

Link copied!

@jherschel7

agree with @WarrenBelz

Was this reply helpful? Yes No
Suggested answer

Kalathiya 2,456 Super User 2026 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!
Hello @jherschel7,

I think this is an issue with the column name in OData. You need to use the internal column name for the filter.

You can find the internal column name by following these steps:

#1. Go to SharePoint library

#2. Sort by the Retention Label column

#3. On the URL, you’ll see something like:

sortField=ComplianceTag

#4. Use this internal column name in your OData filter in action.

If this response resolves your issue, please mark it as the Verified Answer so it can help other community members as well.

---------------------------------------------------------------------------------

📩 Need more help? Just mention @Kalathiya and I’ll be happy to assist.

✔️ If this answer helped you, please tick “Does this answer your question?” so it can be marked as the Verified Answer.

💛 A Like always motivates me to keep contributing!

Was this reply helpful? Yes No