I am trying to update a field (Date) to TODAY's date. How do i accomplish this thru Power Automate. I am using the Update Item with a field called "Audit Date" which again will be TODAY's date once the trigger condition is met.
@cnorris135 here is the expression for setting today's date :
formatDateTime(utcNow(),'yyyy-MM-dd') /*gets formats UTC*/
--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
I received this error:
Flow save failed with code 'OpenApiOperationParameterValidationFailed' and message 'Input parameter 'item' validation failed in workflow operation 'Update_item': The parameter with value '"formatDateTime(utcNow(),'MM-dd-yyyy')"' in path 'item/AuditDate' with type/format 'String' is not convertible to type/format 'String/date'.'.
@cnorris135 please Share your update item action screen and Audit column expression. Also check your SharePoint Audit column type.
Did my reply help? Please give it a thumbs up.
Did I answer your question? Please mark my post as a solution!
Regards,
Hardesh
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
14 | |
13 | |
11 | |
10 | |
9 |
User | Count |
---|---|
31 | |
21 | |
15 | |
14 | |
12 |