Unanswered

Create a Date Field to accept in dd/MM/yyyy hh:mm:ss format from Power automate

(0) Share

Report

Posted on by ssalmans5323

Hi Everyone,

I am new to Power automate i am finding difficulty while updating the date field in sharepoint list. I want to create date field which should accept Date in dd/MM/yyyy hh:mm:ss format. when i tried to update it from power automate its throwing runtime error.
can you provide me custom Json for creating the field in sharepoint list or else any other simple way to create it...

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

Expiscornovus 33,194 Most Valuable Professional on at

Like (0)

Report
Hi @ssalmans5323,

Which action are you using? Are you using the update item action?

Normally you should be able to use a parsedatetime to a date time value which can be accepted by such type of field.

Below is an example

parseDateTime(variables('DateValue'), 'en-us', 'dd/MM/yyyy HH:mm:ss')

Was this reply helpful? Yes No
ssalmans5323 51 on at

Like (0)

Report

Hi @Expiscornovus
The issue is in Sharepoint column i am able to parse in power automate but not able to create such field which can accept dd/MM/yyyy HH:mm:ss as input.

Was this reply helpful? Yes No
Expiscornovus 33,194 Most Valuable Professional on at

Like (0)

Report

Hi @ssalmans5323,

As far as I am aware the DateTime type of field does not have an input setting for this. This field type only has DisplayFormat and FriendlyDisplayFormat properties.

In your case you probably want to use a PowerApps form for this.

Was this reply helpful? Yes No
ssalmans5323 51 on at

Like (0)

Report

Hi @Expiscornovus
I am trying to update the Date field through Power Automate but i am not able to configure the field in sharepoint which should accept in dd/MM/yyyy HH:mm:ss format. I am trying to find the way.
Is there any way in sharepoint?

Was this reply helpful? Yes No
Expiscornovus 33,194 Most Valuable Professional on at

Like (0)

Report

Hi @ssalmans5323,

Like mentioned in my previous reply, the field does not have a setting for this, sorry.

Only workaround I know is to customize the form with PowerApps and validate the input. You can find several examples of this on the PowerApps forums. Below is one example which uses the IsMatch

function, https://powerusers.microsoft.com/t5/Building-Power-Apps/Form-validation-Text-Input-field-Date-format/td-p/1855371

Was this reply helpful? Yes No