web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Concat function return...

Power Apps

Answered

Concat function returns null values

(0) Share

Report

Report

Posted on by Community Power Pla...

When I use the Concat function in a HtmlText field, it returns no values.

This is the code snippet:

Concat(['LDDataTable'], Text(LDPrjID.Text) & "," & Text(LDPrjName.Text) & "," & Text(LDPrjStatus.Text) & "<br>")

This is the output:

,,

The table is populated using a filtered and sorted query and the values display as such:

Does anyone know why or can assist?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (6)

Answers Img

Answers (2)

WarrenBelz 153,051 Most Valuable Professional on at

Like (0)

Report

Hi @Anonymous ,
You need to refer to the table field names, not the control names.
What is the actual structure of the table?

Was this reply helpful? Yes No
Verified answer

Community Power Pla... on at

Like (0)

Report

See attachment @WarrenBelz

Capture1.PNG

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,051 Most Valuable Professional on at

Like (0)

Report
Thanks @Anonymous ,
This should work - tested fine this end on a table
Concat( ['LDDataTable'], ProjectNumber & "," & Project_x0020_Name & "," & ProjectStatus & "<br>" )

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.

Was this reply helpful? Yes No
WarrenBelz 153,051 Most Valuable Professional on at

Like (0)

Report

Hi @Anonymous ,
You have marked your own post as the solution - can you please correct this.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Sorry about that - Thanks for your assistance!

Was this reply helpful? Yes No
WarrenBelz 153,051 Most Valuable Professional on at

Like (0)

Report

No problem @Anonymous - easy to do. Just very confusing for people looking at in the future.

Was this reply helpful? Yes No

Join the conversation