You’re offline. This is a read only version of the page.

Power Apps

Unanswered

From a sharepoint list make a collection with unique items in column 1 and summed values per item in column 2

(0) Share

Report

Posted on by NiclasS

Dear All,

I am struggeling with this problem:

I have a sharepoint list "CustomerSatisfaction" with:

a column "Country" that is a select column with three choices

another column "NSatC" that contains values

In Power apps I want to make a collection where:

One column containins three rows with the unique choices from "Country" in the Sharepoint list

One column containing the sums of NSatC per "Country"

I have started like this:

ClearCollect(CSD,
ForAll(Choices(CustomerSatisfaction.Country) As A,
{
 Land:A.Value,
 NSatCSum: ???????????
}))

Categories:

All responses (0)

Answers (0)

Join the conversation

Helpful resources