Hello,
I am trying to build a powerapp using a SPlist, in this order I need to create a pie chart wich displyas the items of the "Category" field, using just title...,
I write in Items of Gallery: SPListName.Category
the gallery displays in fact the "Category" names, but all the times wich is selected in every record..., the column Category is a selection type wich have only two options,... I need the gallery displays only the two values..., Not the two values in all records
thank you
You are so right in order for the solution of this topic…, I did as you described using Choices .., I solved part of my problem, because now I need to create a Gallery wich are filtered witch the name of the Customer (Customer s a choice column in my SP list), the SP list is named: Ingresos, so when I write in the Items:
SortByColumns(Filter([@Ingresos]; StartsWith(NumeroIngreso; TextSearchBox1.Text)); "Title"; If(SortDescending1; Descending; Ascending))
I see that in fact it shows the name of the Customers (I have 20 customers), but the name of the Customer 1 is repeated as many records are in the SP list, I mean There must be only 20 customers in this Gallery…,
thank You
Hi @alexaristide ,
Could you please share a bit more about your scenario?
Could you please show more details about the Category field in your SP List? Is it a Choice type column?
If you just want to display two available options within your Gallery rather than the Category field values in all records, I think the Choices function could achieve your needs.
Please consider set the Items property of the Gallery to following:
Choices('Your SP List'.Category)
then within the Gallery, set the Text property of the Label to following:
ThisItem.Value
Please take a try with above solution, then check if the issue is solved.
Best regards,