Share
Report
2I 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>
<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>
Categories:
All responses (
Answers (
