I am trying to return a list of Dynamics CRM records from an entity using a related Lead record.
Can anybody advise the correct syntax as I keep getting the following error?
Solved! Go to Solution.
Hi @MartinHutchcpa ,
I have made a similar test using Filter query in List record action in entity Opportunities.
Please check the following image for a reference.
Thanks for your reply Mabel, however can you help me by telling me what is different in your example please, as I have now removed the single quotes and I still get the same error.
Unfortunately when I remove the quotes I still get the same error.
This is the filter query from the failed run.
cdi_leadid eq fce4d0b8-91b2-e811-a956-000d3ab1ab19
From the screenshot of the one step you provided us in your initial post, it should work. You must have something higher up in your flow that may be causing the issue. Can you provided a screenshot of your entire flow for review?
Can you also please provide a full screenshot of the full error message you are receiving?
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. THANKS!
It is a fairly simple flow.
Having posted a support request to Microsoft for this, I have had no response to that for 4 days, although their SLA states 8 hours.
Does anyone here know what could be wrong or is it in the "too hard pile"?
Hi @MartinHutchcpa ,
Is entity Visits a custom entity?
I don’t have a Visits entity on my side.
Have you tried using _cdi_leadid_value instead of cdi_leadid to refer to the lookup field in the Filter Query?
Example: _cdi_leadid_value eq LeadDynamicContnetGoesHere
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!
We've given our badges an overhaul and also added some brand new ones!
Learn how to build the business apps that you need.
Find out where you can attend!
Watch & learn from the Power Automate Community Video Gallery!