I would like to use the dataverse value @OData.Community.Display.V1.FormattedValue in the "List Row" action in "Filter row". However, I do not know how. For example, this is relevant for me if my values in dataverse are of type "choice" or "date".
Is there a way to do this?
Hello,
If you are trying to fetch Quotes whose Follow Up Data is today then please use below expression in your Filter Rows property of List Rows action -
Microsoft.Dynamics.CRM.Today(PropertyName='createdon')
Replace createdon with Follow Up Data field schema name.
I use below tool to generate Power automate query -
www.crmanswers.net/.../new-tool-dataverse-rest-builder.html
Please mark my answer verified if this is helpful!
Regards,
Bipin Kumar
Follow my Blog: xrmdynamicscrm.wordpress.com/
Hello Laurence,
Can you once confirm that you are trying to get all the records which have the "Follow up date" equals to "Current date" ? if yes then what is the "type" of "Follow up date" field ?
if it "Date" field then you can refer below article where you can compare the date field type with the current date.
Thank you,
Amit Katariya
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (