Convert a Parse JSON result in Date

(0) Share

Report

Posted on by EmilioRoqueta69

497

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.

All responses (2)

Answers (1)

EmilioRoqueta69 497 on at

Like (0)

Report

Re: Convert a Parse JSON result in Date

A straightforward solution!
Verified answer

Expiscornovus 31,732 Most Valuable Professional on at

Like (1)

Report
Re: Convert a Parse JSON result in Date

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')