How to compare all rows of a sharepoint list in powerapps

Like (0) Share

Report

Posted on 5 Dec 2021 16:24:21 by glucero1975

101

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.

Categories:

Connectors

Dataflows

Using Apps Using Formulas

Card page with co...

Sharepoint list t...

I have the same question (0)

All responses (17)

Answers (2)

glucero1975 101 on 06 Dec 2021 at 17:10:01

Like (0)

Report

Re: How to compare all rows of a sharepoint list in powerapps

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

Was this reply helpful? Yes No
Verified answer

Gerard Simpson 2,987 Moderator on 05 Dec 2021 at 22:44:11

Like (0)

Report

Re: How to compare all rows of a sharepoint list in powerapps

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'

Was this reply helpful? Yes No
glucero1975 101 on 05 Dec 2021 at 22:31:48

Like (0)

Report

Re: How to compare all rows of a sharepoint list in powerapps

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?

Was this reply helpful? Yes No
Gerard Simpson 2,987 Moderator on 05 Dec 2021 at 22:16:03

Like (0)

Report

Re: How to compare all rows of a sharepoint list in powerapps

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.

Was this reply helpful? Yes No
glucero1975 101 on 05 Dec 2021 at 21:59:34

Like (0)

Report

Re: How to compare all rows of a sharepoint list in powerapps

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 ;

Was this reply helpful? Yes No
glucero1975 101 on 05 Dec 2021 at 21:56:25

Like (0)

Report

Re: How to compare all rows of a sharepoint list in powerapps

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?

Was this reply helpful? Yes No
Verified answer

Gerard Simpson 2,987 Moderator on 05 Dec 2021 at 21:38:34

Like (0)

Report

Re: How to compare all rows of a sharepoint list in powerapps

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'

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

I got the following result in the label:

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

Was this reply helpful? Yes No
glucero1975 101 on 05 Dec 2021 at 20:58:16

Like (0)

Report

Re: How to compare all rows of a sharepoint list in powerapps

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

Was this reply helpful? Yes No
Gerard Simpson 2,987 Moderator on 05 Dec 2021 at 20:27:19

Like (0)

Report

Re: How to compare all rows of a sharepoint list in powerapps

In that case and if you are only ever viewing the info, go for a label control and add the following to display the items in a single deliminated string:

Concat(ThisItem.YourMultiSelectColumn, Value, "; ")

Was this reply helpful? Yes No
glucero1975 101 on 05 Dec 2021 at 20:07:57

Like (0)

Report

Re: How to compare all rows of a sharepoint list in powerapps

OK. How do you get it to automatically display valeu/values? I can select the dropdown and it give me the value but I wanted t he gallery to just show all values like itdoes if it is a singletext item?

Was this reply helpful? Yes No