FetchXML filter throws an error while used in Power Automate

Like (1) Share

Report

Posted on 9 Sep 2024 13:54:42 by PR-09091352-0

Error: 'crf20_Table1' entity doesn't contain attribute with Name = 'crf20_Status' and NameMapping = 'Logical'. MetadataCacheDetails: ProviderType=Dynamic, StandardCache=True, IsLoadedInStagedContext = False, Timestamp=10870476, MinActiveRowVersion=10870476, MetadataInstanceId=9913582, LastUpdated=2024-09-09 01:29:44.850, OrgId=6c32bbdd-2f8c-4d18-8dfc-b028f83bc47e

XML Code: <fetch version = "1.0" output-format="xml-platform" mapping="logical" distinct="false">
<entity name="crf20_table1">
<filter type="and">
<condition attribute="crf20_Status" operator = "eq" value= "DD Verified"/>
<condition attribute="crf20_StatementofDestruction" operator = "eq" value= "No"/>
</filter>
</entity>
</fetch>

Categories:

Process Advisor

All responses (1)

Answers (0)

Suggested answer

Michael E. Gernaey 35,704 Super User 2025 Season 1 on 09 Sep 2024 at 22:36:08

Like (0)

Report

FetchXML filter throws an error while used in Power Automate

Hi

You would need to share more than this, share your flow.

The error is straight forward, you are asking about a column it says doesn't exist, at least not with the name you gave it, try with all lower case.