I am using Flow in CRM dynamics where I need to fetch list of all cases that match today's date.
Filter query is that if Willis_followupdate is not null and equal to today's date then get the list. Now the problem is that Willis_followupdate column has date and time formate value(e.g.followupdate":"2020-06-25T18:30:00Z") and when my condition evaluate something like this: willis_followupdate ne null and willis_followupdate eq 2020-06-25.
I assume that because my column contains time also in value that why it not working.
Someone suggested to use formatDateTime but its throwing below error:
Unable to process template language expressions in action 'List_records' inputs at line '1' and column '2130': 'In function 'formatDateTime', the value provided for date time string 'followupdate' was not valid. The datetime string must match ISO 8601 format.'.followupdate":"2020-06-25T18:30:00Z"
Also, I tried to use starts with or contains and though to use string manipulation that doesn't support in Filter query of dynamics.
Please help me to love this.
@Anonymous - I would suggest using the Common Data Service connectors for your needs. The Dynamics 365 connector is deprecated.
Also, I would suggest you use the formatDateTime for the UTCNow() as well. This way the D365 field date value and the UTCNow() value will be equivalent.
Have you tried this: https://manueltgomes.com/reference/powerautomate-function-reference/formatdatetime-function/
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Did you know that you could restore a deleted flow? Check out this helpful article.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
23 | |
13 | |
11 | |
10 | |
8 |
User | Count |
---|---|
32 | |
25 | |
25 | |
17 | |
16 |