Answered

Text Label - Calculated Date Format

(0) Share

Report

Posted on by jjjames237

Has anyone come across this one?.....I have a calculated Date column in SharePoint List and I'm using the information within a gallery in PowerApps, and this is what is being returned:

I'd like to format this as a regular date i.e. dd/mm/yyyy if anyone could help?

Thanks

Jim

Categories:

General Questions

All responses (5)

Answers (1)

PA-novice 20 on at

Like (0)

Report

Re: Text Label - Calculated Date Format

That worked for me as well.
jjjames237 on at

Like (0)

Report

Re: Text Label - Calculated Date Format

That worked! Thanks Bof
Verified answer

v-bofeng-msft on at

Like (2)

Report
Re: Text Label - Calculated Date Format

Hi @jjjames237,

Please try:

Text(DateTimeValue(ThisItem.NextReviewDueDate),"dd/mm/yyyy")

Best Regards,

Bof
jjjames237 on at

Like (0)

Report

Re: Text Label - Calculated Date Format

Thanks for the reply Andrew, unfortunately this didn't work.
My SharePoint calculated column is simply a date referenced from another column +365 to flag a review date in 12 months.
I've brought this into my gallery in PowerApps and the above image is the result I get.
AndrewR1 1,513 on at

Like (0)

Report
Re: Text Label - Calculated Date Format

Hi @jjjames237 you can use the Text function to do this like so:

Text(ThisItem.NextReviewDueDate,"dd/mm/yyyy")

You will need to change the ThisItem.NextReviewDueDate to the same name as your date field.

Please click Accept as solution if my post helped you solve your issue. ✔️ This will help others find the solution to this problem. It also closes the item. Remember, you can accept more than one post as a solution.

If the content was useful in other ways, please consider giving it Thumbs Up. 👍

Thanks
Andrew