This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(166.4, 36%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMQ%3C/text%3E%3C/svg%3E)
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
Thanks
Is any one can help me on this Please ?
is any one can help on this ?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(313.6, 51%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EED%3C/text%3E%3C/svg%3E)
@Mohammad Qasim
I'm checking how the things are going on about this issue. Whether the answer helps you?
You can accept the answer if it helps.
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.
@Mohammad Qasim
Is there any progress on this issue?
If you find any answers helpful to you, please remember to accept them as answers.
It will help others who meet the similar question in this forum.
Thank you for your understanding.
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.
@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')
2.Automated flow: The "Companyexpirydate" field directly shows in the dynamic content.
formatDateTime(triggerOutputs()?['body/Date'],'dd/MM/yyyy')
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.
i am using Automated Flow
Probelm: as i go to dynamic content unable to find formula there and if i go to "expression section" it gives below .
note: companyexpiry is showing on dymic content not on expression.
error.
Please set the expression according to the GIF below.
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.
I am using Recurrence Flow, As i go to expression section , i am not able to find "createdexpirydate" fields
@Mohammad Qasim
You should add “Get item” action after "Get items" action in the flow, then "Companyexpirydate" field will show in the dynamic content.
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.
still waiting for response.??
@Mohammad Qasim
You should add “Get item” action after "Get items" action in the flow, then "Companyexpirydate" field will show in the dynamic content.
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.