You’re offline. This is a read only version of the page.
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...
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
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?
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.
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.
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
Share
Report
All responses (
Answers (parseDateTime(variables('DateValue'), 'en-us', 'dd/MM/yyyy HH:mm:ss')
#1
WarrenBelz
146,660
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,004
Most Valuable Professional
