Convert a Parse JSON result in Date

(0) Share

Report

Posted on by EmilioRoqueta69

565

Hi,

I am reading a CSV file in Sharepoint library, get the content and with it, add a row in a Dataverse table.
That works fine, but sometimes I get an error in the date fields.
So, I need to convert to date format the proper column of the CSV file.
But, when I added an step with formatDateTime, I can not add the result of the Parse JSON that contains the field of date.

I only can get the "Body" of the Parse JSON.

The column after the Parse JSON is "Nacimiento".

How can I solve this situation?

Thanks for any help.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Expiscornovus 33,189 Most Valuable Professional on at

Like (1)

Report
Hi @EmilioRoqueta69,

Can you try something like the below. Add this expression via the expression tab in your Compose action

formatDateTime(item()['Nacimiento'], 'yyyy-MM-dd')

Was this reply helpful? Yes No
EmilioRoqueta69 565 on at

Like (0)

Report

A straightforward solution!

Was this reply helpful? Yes No