cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
glucero1975
Helper III
Helper III

How to compare all rows of a sharepoint list in powerapps

I am building an app where I want to compare each row in the sharepoint list against one another to find matches.  Each row signifies a specific product with multiple columns that are choice columns and some are just single line text.

 

The canvas app I have made takes each row in the sharepoint list and creates a cpreview card.  I have created and Checkbox on each care for the user to selcet it to comapre.  

Thus, how do i get the data to display once the user has selected the items they wish to compare?  I have attached image of cards and sharepoint data list.

17 REPLIES 17
glucero1975
Helper III
Helper III

Get error in formula.   Combobox items =ThisItem.'Opportunity Area'

Tried to set label items = Concat(ThisItem.'Opportunity Area',Value,";")

 

Issue: Invalid argument type

Locstion ComboBox1.Items

AmDev
Super User
Super User

Hi @glucero1975  - The error you have forwarded seems to only be related to the combo box - If you just want to view the items chosen in that field as a joined string in the comparison view, just use the label with the formula I gave you. 

 

It should work as is, but to troubleshoot can you check to make sure multiselections have been made in the record you collected?

 

Also, can you go to View\collections and click into the nested table in your collection to reveal the contents of that nested table (i.e. your selected items). For example in the following scenario, I have clicked through in to view the contents of my multiple selection in a choice column called 'ChoiceMulti' within my collection, 'colTESTING'

 

AmDev_0-1638740119136.png

 

You can see the header is 'Value', so when I added the following code into the label in the gallery row:

AmDev_1-1638740196816.png

.....

 

I got the following result in the label:

AmDev_2-1638740230519.png

 

Is the header in your nested table called 'Value' or is it something else?

glucero1975
Helper III
Helper III

When I check collection and click on nested tables, they do show allchoices as Value like your screen shot. So,

 it works when there are multiple itens for the column that have been selected.  How do I now disply when only one choice is selected?

For the Concat items with multipoe vlaues, if I remove the  ";" will it remove the ; after each choice?  I want all choices to display but not the ;

 

AmDev
Super User
Super User

Yes, you can just delete ; and leave just the space(" ").

 

I have tested and this also works if you select just one choice in a column that has multi selection enabled.

glucero1975
Helper III
Helper III

For some reason, my single choice ones still will not show? It seems taht when I select the multichoice columns, the one thare are in 'Columnname' show up and the ones not in ' do not show?

 

AmDev
Super User
Super User

Are you referring to other choice columns that are single select only?

 

If so, you will need to include the following in your label:

 

'ThisItem.YourSingleChoiceColumn.Value' 

glucero1975
Helper III
Helper III

I got it working.  Thank you for all your time and support.  Greatly appreciated.

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (4,604)