Announcements
I have a model driven app and am trying to understand how to use Power Automate. I want to create a cloud flow to run every night. It will check the value of a date field in all entity records. If the value of the date field in a given row is less than or equal to today's date, it will change the value of the Certification Status field to Expired. I've set up the recurrence portion but don't know what Dataverse action to use to look at all rows in a table and apply the condition to each row. I would appreciate any guidance on the steps I need in the flow. Thanks!
1. add 'List Rows present in a table' action from dataverse connector.
2. Select Table and use filter query to get data based on your date condition.
3. Add apply to each
4. In apply to each you can add action to Update a row and change Certificate status to expired.
Thank you. Could you provide what exactly I should enter in the Filter rows of the List Rows action?
My date field is ppt_expirationdate.
Here is what I have, but it all seems wrong because it is asking me for the GUID.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 342 Most Valuable Professional
11manish 234
Valantis 187
