Group and Sum Sharepoint List

[bugs777]

Hi everyone, 

I have a sharepoint list that I need to import into a datatable in powerapps and then group on the vendor name and sum only a select columns whilst ignoring all other columns. 

I've tried using add columns/remove columns in conjunction with group by but I can't seem to get it to work.

Any help would be appreciated!

Thank You!

[StalinPonnusamy · Accepted solution]

Hi @bugs777 

Here is the Sample for the group by

DropColumns(
    AddColumns(
        GroupBy(
            AddColumns(
                'DataSource',
                "ColumnNameAlias",
                VendorName
            ),
            "ColumnNameAlias",
            "VendorGroup"
        ),
        "CountValue",
        CountRows(VendorGroup)
    ),
    "VendorGroup"
)

Change DataSource and VendorName column on this query.

And for Sum, you will be doing only for specific columns

Thanks,
Stalin - Learn To Illuminate

[bugs777]

So I have managed to get the formula working but the new column I want isn't showing in my datatable?

See screenshots of formula and resulting datatable