Hi,
I want to trigger an ms flow on the date field of a custom entity(audits), It is a scheduled flow and it will trigger only condition if the date field(on hold) is equal to today's date and will shoot an e-mail, as I am trying the condition is same as per the the flow requirement and flow is also running successfully but not shooting any e-mail and as I am using the CSV table for my testing purpose that whether data is coming or not form fetch, so CSV table is also empty.
As I removed the filter or condition of date filed then flow is giving an error "Could not find a property named 'cyno_auditsid' on type 'Microsoft.Dynamics.CRM.audit'."
My fetch is here:-
<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">
<entity name="cyno_audits">
<attribute name="cyno_auditsid" />
<attribute name="cyno_name" />
<attribute name="createdon" />
<attribute name="cyno_onholduntil" />
<attribute name="cyno_auditfile" />
<order attribute="cyno_name" descending="false" />
<filter type="and">
<condition attribute="cyno_onholduntil" operator="on" value="@{variables('lastyeardate')}" />
</filter>
</entity>
</fetch>
Note:-variable lastyeardate value is here
lastyeardate= addDays(utcNow(),0,'yyyy-MM-dd')
Thanks Mehdi!!
Flow is working now.
Hi,
Yes, I think I understand the problem. You chose the wrong entity on the step list record. Please refer to the image below:
Hi,
I have update my question with the screenshots.
Thanks
Hi,
Can you please share some screenshots ?
Hi,
Can you please share some screenshots ?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,113 Super User 2024 Season 2
Martin Dráb 229,918 Most Valuable Professional
nmaenpaa 101,156