Convert table to text

(0) Share

Report

Posted on by Kenjoy84

141

I want to convert table to text. I try to use "concut", but it seems doesn't work as I expected.

Could you give me a thought?

I am using collection, so I am attaching error message and the value inside the collection.

In this "Dept Type" (Dept Group) column, multiple values can be saved.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

WarrenBelz 156,340 Most Valuable Professional on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @Kenjoy84 ,

Try this

Concat( ComboBox3.SelectedItems, DeptGroup & "," )

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
Kenjoy84 141 on at

Like
a
(0)

Report
Copy link

Link copied!

I tried that, but still, there is error.
I tried with "DeptGroup.Value" as well. But, the situation is same.
Do you have another idea?

Was this reply helpful? Yes No
Verified answer

Kenjoy84 141 on at

Like
a
(2)

Report
Copy link

Link copied!

I found the solution in another discussion.

https://powerusers.microsoft.com/t5/Building-Power-Apps/Convert-table-to-text/m-p/690002/highlight/false#M220805

Was this reply helpful? Yes No
KEarley 276 on at

Like
a
(3)

Report
Copy link

Link copied!

Isn't there a more intentional way to turn a table, record, or even a field into text? Taking the output of a data object and concatenating it together just to extract from it the desired piece of data seems like a workaround. Shouldn't there be something like this: DataObject.Record.ToText(FieldName) or some other intentional method?

Was this reply helpful? Yes No
jnernst 166 on at

Like
a
(1)

Report
Copy link

Link copied!

@KEarley I really wish there was... Seems a lot of the fuctions that are being used are workarounds... Before you know your app consists of 4 workarounds that break eachother anytime you put in anymore features...

Was this reply helpful? Yes No