
Announcements
Hi, I need a nightly job that searches all records where Field1 = Today, and then updates Field2=true. Can anyone tell me if this is possible with powerautomate and if so, how to go about it?
Thanks!
Yes this is possible using power automate
You need to do a Recurrence flow trigger -> then use the List Rows Action from CDS Current Environment Connector and use the filter row to add your filter
Then apply_to_each action to loop on returned List and use Update Row Action from CDS Current Environment to update field 2 to true.