I have a text column in my custom CDS entity containing a string of a date. Most fields are empty.
I want to build a Flow which will will convert the string to a value of type datetime and update the date field in the same record, for all records in my custom entity.
Its failing with a 400, BadRequest, error. What am I doing wrong?
Attached images show the flow and the resulting error.
Source column values are either empty or in the format "7/7/1977".
You couldn't enter the expression in the "PCN Status Date" in the "Update a record" action directly.
Please add a dynamic content with the expression in your "PCN Status Date" in the "Update a record" action.
I have made a test on my side, you could refer to screenshot below to add the dynamic content with the expression:
The flow would run successfully as below:
I made the change you suggested but my Flow still fails.
Here is the full text of my expression.
convertToUtc(item()?['cr89e_pcnstatusimportastext'], 'Pacific Standard Time')
Here is the earlier portion of my Flow. I am trying to apply this update to each record in a list. Referencing each record individually is probably my issue.
Another important thing to note is that my destination date field is of type Date&Time, not string/text.
Is there some other function I should be using to convert a date string to a Date&Time field type?