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')
