Hello
I'm facing an issue on Collection, Transform Rows to Columns.
My Collection looks like
Title | Quarter | Score |
XYZ | Q1 | 80 |
XYZ | Q2 | 60 |
XYZ | Q4 | 50 |
ABC | Q1 | 90 |
ABC | Q3 | 76 |
I'm looking for
Title | Q1 | Q2 | Q3 | Q4 |
XYZ | 80 | 60 | 50 | |
ABC | 90 | 76 |
How to achieve this ?
Thank you for your support.
BR
ananda
Solved! Go to Solution.
Please consider changing your Formula to the following:
ForAll(
GroupBy(yourData,
"Title",
"_recs"
),
{Title: Title,
Q1: LookUp(_recs, Quarter="Q1", Score),
Q2: LookUp(_recs, Quarter="Q2", Score),
Q3: LookUp(_recs, Quarter="Q3", Score),
Q4: LookUp(_recs, Quarter="Q4", Score)
}
)
This will produce the results that you have asked for.
I hope this is helpful for you.
Check this out and see if it helps:
Please consider changing your Formula to the following:
ForAll(
GroupBy(yourData,
"Title",
"_recs"
),
{Title: Title,
Q1: LookUp(_recs, Quarter="Q1", Score),
Q2: LookUp(_recs, Quarter="Q2", Score),
Q3: LookUp(_recs, Quarter="Q3", Score),
Q4: LookUp(_recs, Quarter="Q4", Score)
}
)
This will produce the results that you have asked for.
I hope this is helpful for you.
WOW, Worked liked charm..
Kudos...
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 |
---|---|
183 | |
51 | |
47 | |
32 | |
32 |
User | Count |
---|---|
266 | |
91 | |
78 | |
68 | |
67 |