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!
Solved! Go to Solution.
Hi @Anonymous
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
Hi @Anonymous
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
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
User | Count |
---|---|
184 | |
53 | |
41 | |
36 | |
30 |
User | Count |
---|---|
242 | |
82 | |
71 | |
69 | |
65 |