How to convert Sharepoint date ( column in list ) from yyy/MM/dd to dd/MM/yy

Mohammad Qasim 576 Reputation points
2020-12-02T09:24:35.993+00:00

Greetings,

I have custom list having Date column which showing date 'yyy/MM/dd' I want to convert this into 'dd/MM/yy'

How can i do this ?,its fields in list which name is "Companyexpirydate" .Below Image for Reference.

Solution Required: to convert SharePoint datetime field format.
Note: as i go to expression column to add "formatdatetime" so i am not able to find my column field which is "Companyexpirydate"

current output is
44300-appdateoutput.png

44373-powerapp.png

Thanks

SharePoint Server Development
SharePoint Server Development
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Development: The process of researching, productizing, and refining new or existing technologies.
1,569 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Emily Du-MSFT 41,771 Reputation points Microsoft Vendor
    2020-12-03T08:31:37.11+00:00

    @Mohammad Qasim
    Whether this flow is an instant flow or an automated flow?

    1.Instant flow: You should add “Get item” action in the flow, then "Companyexpirydate" field will show in the dynamic content.
    formatDateTime(outputs('Get_item')?['body/Date'],'dd/MM/yyyy')
    44751-1.png
    44696-3.png
    2.Automated flow: The "Companyexpirydate" field directly shows in the dynamic content.
    formatDateTime(triggerOutputs()?['body/Date'],'dd/MM/yyyy')
    44752-4.png
    44753-5.png


    If an Answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


  2. Mohammad Qasim 576 Reputation points
    2020-12-08T09:51:36.21+00:00

    still waiting for response.??