Unanswered

Changing date format on record type

(0) Share

Report

Posted on by ruth

212

I have a Sharepoint list with an "audit period" (ie, 2017 - 2020). The beginning period and ending period is pulled from another list (ie 09/01/2017 and 12/31/2020). These values are stored in my list audit list. When I display them in power apps, they are formatted as "2020-05-31T07:00:00Z" .

I've tried to reformat using the text command --> Text(ThisItem.'ContractPeriod:BegDate',DateTimeFormat.ShortDate) but I can't use this function as the data type is record and the function is text. Does anyone know how to resolve this?

thanks

Ruth

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @ruth

try to convert to
Text(ThisItem.'ContractPeriod:BegDate', "mm/dd/yyyy")

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi @ruth

Text(DateValue(ThisItem.'ContractPeriod:BegDate'), "dd/mm/yyyy")

Was this reply helpful? Yes No
ruth 212 on at

Like (0)

Report
Copy link

Link copied!

same problem - "Invalid argument type (Record). Expecting a Text value instead"

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @ruth

Did you tried below both? What is the field format in SP?

Text(DateValue(ThisItem.'ContractPeriod:BegDate'), "dd/mm/yyyy")

Text(Text(DateValue(ThisItem.'ContractPeriod:BegDate')), "dd/mm/yyyy")

Was this reply helpful? Yes No
rubin_boer 4,843 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
hi @ruth , alternatively you can give this a shot

With( { uctDateTime: DateTimeValue( YourDateTime, "en-GB" ) }, DateAdd( uctDateTime, TimeZoneOffset(uctDateTime) / 60, Hours ) )

Hope it helps

Was this reply helpful? Yes No
ruth 212 on at

Like (1)

Report
Copy link

Link copied!

Yes. but I just figured it out.

I was using the default form that is built when I created a sharepoint form, the datacard value was a combo box? So I deleted it and used a label (could have used a text field but it's a display field so a label is fine). The command then works properly.

Thanks

Was this reply helpful? Yes No