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.

I tried with

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

And

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

But, still, there is error.

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!
@Kenjoy84

You might consider changing your formula to the following:

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

This is assuming that you are already using the DeptGroup as the basis for your Items property of your ComboBox.

If not, then please share the Formula you have for the Items property on that combobox.

I hope this is helpful for you.

Was this reply helpful? Yes No
Kenjoy84 141 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for your support!
I tried with your formula, but there is error still.
I am sharing item property of comboBox which my formula referring.
Dept_Type column(table format) is equal to DeptGroup column which I want to get.

Thank you very much.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Kenjoy84

Okay, your items are based on a collection. It originally appeared from your picture that your collection had a single column called "Value". Upon examining your Formulas on the other items, it appears that you have actually a collection with several columns that have Tables of Values under them.

If you will only have one value in DeptGroup, then I would reconsider that strategy of having a table of values for only one in your colleciton.

So the formula should be:

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

Because in this case you are needing to get the first record of your table of values under the DeptGroup column in your collection.

Was this reply helpful? Yes No
Kenjoy84 141 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you very much! It works!
However, actually there are multiple values in this table.
Is there a way to show multiple values?

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(6)

Report
Copy link

Link copied!
@Kenjoy84

So you are saying that in addition to the possibility that multiple items may be selected in your combobox (if you are allowing multiple selections) that each selection may itself have multiple values in the DeptGroup table?

If so, then you can consider this formula:

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

Was this reply helpful? Yes No
Kenjoy84 141 on at

Like
a
(1)

Report
Copy link

Link copied!

This works perfectly! Thank you very much for your support!!

Was this reply helpful? Yes No
Scot12 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Where exactly is the conversion happening? I see concatenations. I basically want to compare the substring value in a SharePoint item field with a string casted date value, Text(Month(Now()), and use this in a filter for a drop down. However I am getting a type mismatch with type table and type text.

Was this reply helpful? Yes No
ChadRobbins 56 on at

Like
a
(0)

Report
Copy link

Link copied!

You shouldn't be getting a mismatch because the concat function converts the types to text. Where is the mismatch happening?

Was this reply helpful? Yes No