web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Convert a Parse JSON r...

Power Automate

Answered

Convert a Parse JSON result in Date

(0) Share

Report

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:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

Expiscornovus 33,979 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
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
a
(0)

Report
Copy link

Link copied!

A straightforward solution!

Was this reply helpful? Yes No

Join the conversation