News and Announcements icon

Dynamics 365 CommunityForums Customer experience | Sales, Customer Insights,... Fetch xml is not worki...

Customer experience | Sales, Customer Insights,...

Unanswered

Fetch xml is not working in power autoamte dataverse action List records

(0) Share

Report

Report

Posted on by Community member

2

I have a fetch Xml which retrieves realted records of task entity which has many to many relationship, this fetch xml is working for my plugin, but when I try to use the same fetch xml in power automate it is not working and throwing an error /The value for OData query '$filter' cannot be empty/

here is the fetchxml

<fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='true'>
<entity name='ss_teststaff'>
<attribute name='ss_teststaffid'/>
<attribute name='ss_name'/>
<attribute name='createdon'/>
<attribute name='ss_email'/>
<order attribute='ss_name' descending='false'/>
<link-entity name='ss_ss_tasks_ss_teststaff' from='ss_teststaffid' to='ss_teststaffid' visible='false' intersect='true'>
<link-entity name='ss_tasks' from='ss_tasksid' to='ss_tasksid' alias='TaskId'>
<filter type='and'><condition attribute='ss_tasksid' operator='like' value='@{items('check_each_task_if_the_due_date_is_45_days_from_the_current_date')?['ss_tasksid']}' />
</filter>
</link-entity>
</link-entity>
</entity>
</fetch>

All responses Img

All responses (1)

Answers Img

Answers (0)

Community member 2 on at

Like (0)

Report

Fetch xml is not working in power autoamte dataverse action List records

Helpful resources

News and Announcements

Join us in the Community for an AMA: December 12th Register Today

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2

Martin Dráb 230,149 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans