web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps TEXT function use on a...

Power Apps

Answered

TEXT function use on a Calculated column

(0) Share

Report

Report

Posted on by DCHammer

716 Moderator

I have a calculated date/time column that is simply the submission date of the sharepoint record + 14 days.

When I use Text(ThisItem.FollowupDate,DateTimeFormat.ShortDateTime) in a Text label, it does not convert and the raw date/time appears as text.

That's what is explained as the solution to what I want in numerous posts.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

WarrenBelz 154,496 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @DCHammer ,

SharePoint calculated columns do not “play well” with Power Apps and should not be used. You can do the same calculation in Power Apps as you have the same fields available to you.

Text( DateAdd( YourDateField, 14, TimeUnit.Days ), DateTimeFormat.ShortDateTime )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
DCHammer 716 Moderator on at

Like (0)

Report
Copy link

Link copied!

Thanks Warren. I did manage to make the silly thing work by using DateTimeValue and then converting that to text. And all for not. The users decided they don't want to see that value anyway now. Arrrg

Was this reply helpful? Yes No

Join the conversation