How could I add multiple columns at once in PowerApps

Question

Hi I am having the data in sharepoint like

Title	ID
S1	101
S1	102
S2	103
S3	104
S3	105

Now I have to create a piechart in PowerApps Showing the Percentage of Each title.

So, I am creating a new column using AddCoulmn(GroupBy,"Title", "Grouped"), "Titles", CountRows(Grouped))

Now I want to create another Column with the distinct titles and its percentage with reference to the ID.

How can I do that?

carlosfigueira · Accepted Answer · 2021-10-22 19:11:19Z

1

The AddColumns function can add multiple columns at once. For example, the expression below can be used to add a percentage in addition to the number of titles in the grouping that you have.

With(
    { totalCount: CountRows(dataSource) },
    AddColumns(
        GroupBy(dataSource, "Title", "Grouped"),
        "Titles", CountRows(Grouped),
        "TitlePercent", 100.0 * CountRows(Grouped) / totalCount))

answered Oct 22, 2021 at 19:11

carlosfigueira

87.7k14 gold badges137 silver badges176 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Tanish Gupta Over a year ago

Hi, your solution solved the problem. But I am also getting an error, Delegation warning. The CountRows operation is not supported by this connector. on { totalCount: CountRows(dataSource) }, line.

Collectives™ on Stack Overflow

How could I add multiple columns at once in PowerApps

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related