Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

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

Like (0) ShareShare
ReportReport
Posted on 16 May 2024 10:39:51 by 51

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...

  • Expiscornovus Profile Picture
    31,701 Most Valuable Professional on 16 May 2024 at 16:09:45
    Re: Create a Date Field to accept in dd/MM/yyyy hh:mm:ss format from Power automate

    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

  • ssalmans5323 Profile Picture
    51 on 16 May 2024 at 15:17:00
    Re: Create a Date Field to accept in dd/MM/yyyy hh:mm:ss format from Power automate

    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?

  • Expiscornovus Profile Picture
    31,701 Most Valuable Professional on 16 May 2024 at 13:41:37
    Re: Create a Date Field to accept in dd/MM/yyyy hh:mm:ss format from Power automate

    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.  

  • ssalmans5323 Profile Picture
    51 on 16 May 2024 at 13:27:00
    Re: Create a Date Field to accept in dd/MM/yyyy hh:mm:ss format from Power automate

    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.

     

  • Expiscornovus Profile Picture
    31,701 Most Valuable Professional on 16 May 2024 at 13:15:16
    Re: Create a Date Field to accept in dd/MM/yyyy hh:mm:ss format from Power automate

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

     

    updateitem_parsedatetime.png

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Building Flows

#1
stampcoin Profile Picture

stampcoin 125

#2
David_MA Profile Picture

David_MA 118 Super User 2025 Season 1

#3
Michael E. Gernaey Profile Picture

Michael E. Gernaey 110 Super User 2025 Season 1

Overall leaderboard