Hi All
I would like to create a new collection from the below collection with only columns found in colDisplayColumns collection
Below collection holds data with n number of columns
ClearCollect(coltableData,MYData);
Below collection holds columnsNames to be displayed
ClearCollect(colDisplayColumns,DisplayColumnsTable);
Required New collection of coltableData with columnsNames only specified in colDisplayColumns collection
e.g If coltableData has 10 columns and colDisplayCOlumns holds values of only those columns that have to be shown .SO i want to create a new collection coltableData with only those 5 columns .
Example
coltableData : Location Date Value Amount
New York 12/19/2020 5 10
New York 12/23/2020 3 20
New York 12/25/2020 2 30
colDisplayCOlumns : ColumNames InternalColumnName
Value cr12_Value
Amount cr12_Amount
Date cr12_Date
Desired Collection:
Date Value Amount
12/19/2020 5 10
12/23/2020 3 20
12/25/2020 2 30
I have tried dropcolumns function but it accepts only hardcoded string values not dynamic values.
Can any one please help me on this one
Solved! Go to Solution.
Hi @Hetvik ,
Unfortunately this is difficult to achieve.
You cannot use a string to refer to a column name (not allowed in powerapps).
Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.
Hi @Hetvik ,
Unfortunately this is difficult to achieve.
You cannot use a string to refer to a column name (not allowed in powerapps).
Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.