Hi, I have a collection and it is Grouped based on the EmployeeID. And I'm summing up the pay for the week.
But within that Grouping, there is a comments section. How do I get all the comments to combine into one field and be distinct?
Solved! Go to Solution.
@TB05 ,
To obtain that, there is small change in my previous formula. Put "," instead of char(10). I supposed that the delimatator is ",".
And on text property of the label use (you may need to adjust the formula):
With(
{
CommentsCollection: Split(
AllCommentsForEmployeeID,
","
)
},
Concat(
ForAll(
Distinct(
CommentsCollection,
Result
) As temp,
CountIf(
CommentsCollection,
Result = temp.Result
) & " " & temp.Result
),
Value & ", "
)
)
So, in other word, you don't need the number of appearence for each word? Check this out...
With(
{
CommentsCollection: Split(
ThisItem.AllCommentsForEmployeeID,
","
)
},
Concat(
Distinct(
CommentsCollection,
Result
),
Result & ", "
)
)
@TB05 ,
Based on your description, I supose that you grouped by the datasource and sum pay for the week using something like:
AddColumns(
GroupBy(YourDataSource,"EmployeeID","Result"),
"PayForTheWeek",
Sum(Result,PayForTheWeekColumn)
)
Why don' t you add a new column to concat the comments column from each group by like this:
AddColumns(
GroupBy(YourDataSource,"EmployeeID","Result"),
"PayForTheWeek",
Sum(Result,PayForTheWeekColumn),
"AllCommentsForEmployeeID",
Concat(Result,Comments & Char(10))
)
I used Char(10) to put comments each onnew line.
Hope it helps !
That worked great, one other question...so now in the text box, I have the following:
So, is there a way to count the DR and the Tier 1, Tier 2 and have them display like this:
4 DR, 2 Tier 1, 1 Tier 2, 1 Tier 3, 1 MSK or something like that??
Thanks for your quick response.
@TB05 ,
To obtain that, there is small change in my previous formula. Put "," instead of char(10). I supposed that the delimatator is ",".
And on text property of the label use (you may need to adjust the formula):
With(
{
CommentsCollection: Split(
AllCommentsForEmployeeID,
","
)
},
Concat(
ForAll(
Distinct(
CommentsCollection,
Result
) As temp,
CountIf(
CommentsCollection,
Result = temp.Result
) & " " & temp.Result
),
Value & ", "
)
)
Thank you, that worked great! Only had to change Split(ThisItem.AllComments......
Sorry to bother you, what if I just want to see in the text field, one word. I have another text field that has
multiple RPI, RPI, RPI and I only want to show one. I tried to work your code to show one RPI but not successful.
So, in other word, you don't need the number of appearence for each word? Check this out...
With(
{
CommentsCollection: Split(
ThisItem.AllCommentsForEmployeeID,
","
)
},
Concat(
Distinct(
CommentsCollection,
Result
),
Result & ", "
)
)
Thanks Again! That worked great. I have applied it to multiple text fields.
Have a great weekend!!
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.
User | Count |
---|---|
208 | |
98 | |
59 | |
51 | |
42 |
User | Count |
---|---|
259 | |
160 | |
84 | |
79 | |
57 |