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.
Solved! Go to Solution.
Get error in formula. Combobox items =ThisItem.'Opportunity Area'
Tried to set label items = Concat(ThisItem.'Opportunity Area',Value,";")
Issue: Invalid argument type
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?
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 ;
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.
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?
Are you referring to other choice columns that are single select only?
If so, you will need to include the following in your label:
Keep up to date with current events and community announcements in the Power Apps community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!