Unanswered

splitting text to rows

(0) Share

Report

Posted on by cabutbul

I have a problem that apparently should be easy to solve, but I can't solve it.
I have a share point list called GeneralSpecGroups and it has two columns, a column called Title and a Lookup column called GroupToSpecName.
Each value in Title holds several values under GroupToSpecName !!!
In Power apps I added a Combo box called GroupSelect which represents the Title column (not a gallery) and I added Combo box2 which represents the GroupToSpecName column, I am interested in choosing any of the options in GroupSelect to see the relevant list under Combo box2.
The values under Combo box2 are not for selection, only for viewing.
I set Combo box2 as View and it does display the text but as one long line and it is important to me that the values appear as in a table one under the other.
This is the code I wrote
LookUp (
GeneralSpecGroups,
Title = GroupSelect.Selected.Value,
GroupToSpecName
)

I can't separate the text into lines according to the values.
Would appreciate help

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

AndrewR1 1,572 Moderator on at

Like (0)

Report
Hi @cabutbul So you are trying to set a combo box depending on another which the field in you SharePoint list is a choice column? This will then filter a table?

So, the way that I achieved this is I have a SharePoint list called movies a name column which is text and a genre column which is a multi-select choice column:

Text Coul Combo box:

This is listing all the distinct name in my table as the items property:

Distinct(Movies,Name)

Then for the genre combo box I have the following for its items property:

Choices([@Movies].Genre)

Then I will set the default selected items property to the following look up:

LookUp(Movies,Name = ComboBox7.Selected.Value,Genre)

As you can see this returns me 2 values Horror and Thriller for Scream.

Hope this helps!

Please click Accept as solution if my post helped you solve your issue. ✔️ This will help others find the solution to this problem. It also closes the item. Remember, you can accept more than one post as a solution.

If the content was useful in other ways, please consider giving it Thumbs Up. 👍

Thanks
Andrew

Was this reply helpful? Yes No
cabutbul 63 on at

Like (0)

Report

but if you want to display Horror and Thriller in separated rows.
How do you do that?

Was this reply helpful? Yes No