How to conver a record type data to text type?

(2) Share

Report

Posted on by charlene

Hello,

I am new here, and I am trying to display a field with a "record" type data. --> "Created by"

And I got the error below:

I am not sure what does change the rule to product a {0} value mean. I would like to display the result.

Any help would be appreciated!

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (2)

Verified answer

RezaDorrani 12,143 on at

Like (16)

Report

Hi @charlene

CreatedBy is a complex type column

Use ThisItem.'Created By'.DisplayName

or ThisItem.'Created By'.Email or other properties which are available

Regards,
Reza Dorrani

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

1 people found this reply helpful.

Was this reply helpful? Yes No
Verified answer

prajyot 132 on at

Like (0)

Report

Hello,
You can use Text(), for example.
createdDate:Text(Now(),DateTimeFormat.LongDateTime ),lastModifiedDate:Text(Now(),DateTimeFormat.LongDateTime)

If you want to show the createdBy or LastModifiedBy you use like it below.
createdBy:User().FullName,lastModifiedBy:User().FullName.

or Text(Thisitem.CreatedBy)

Thanks & Regards,
Prajyot Mahindrakar.

Was this reply helpful? Yes No
charlene 20 on at

Like (1)

Report

Thank you so much! It works!

Was this reply helpful? Yes No
SSPower 34 on at

Like (0)

Report

Hey Reza,
I hope you are good. Thanks for sharing the great knowledge of power apps , I always enjoy your videos. I am trying to replicate the combo box that you suggested in this video: https://www.youtube.com/watch?v=zPM0Q53L3sE but somehow I am not able to find my column name after CmbSystemAccess.Selected "Concat(CmbSystemAccess.Selected,"Column name", "; ")". Instead of Column name, the only option I am seeing is "This Item.Column name". I tried to add .Value and .Selected Items but after ".", there are no other property showing up and error is still there. Can you please let me know how can I pass thought this obstacle ?

Was this reply helpful? Yes No
metalproswi 38 on at

Like (0)

Report

Hello,

I have the same issue, but my field is populated from a Choice drop down list selection. How can I display the value recorded using Text Input?

Regards,
BK

Screenshot 2024-0...

Was this reply helpful? Yes No