Scenario:
I have a set of data as below, where i need to showcase the report status in a label as comments:
Report1 | Report2 | Report3 | COMPLETENESS STATUS | ACCURACY STATUS | TIMELINESS STATUS | AREA | Currency |
5 | 3 | 2 | Not Completed | No | No | USA | USD |
3 | 5 | 6 | Not Completed | No | No | USA | USD |
Solved! Go to Solution.
Hi @ikarthik ,
Try this
"Completness :" &
CountRows(
Filter(
Source,
Currency="USD",
AREA="USA",
'COMPLETENESS STATUS'="Not Completed"
)
) &
" Report(s) not Completed" & Char(10) &
"Accuracy :" &
CountRows(
Filter(
Source,
Currency="USD",
AREA="USA",
'ACCURACY STATUS'="No"
)
) &
" Report(s) Inaccurate" & Char(10) &
"Timeliness :" &
CountRows(
Filter(
Source,
Currency="USD",
AREA="USA",
'TIMELINESS STATUS'="No"
)
) &
" Report(s) not Impacted"
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Use Char(10) Example:
Hi @ikarthik ,
Try this
"Completness :" &
CountRows(
Filter(
Source,
Currency="USD",
AREA="USA",
'COMPLETENESS STATUS'="Not Completed"
)
) &
" Report(s) not Completed" & Char(10) &
"Accuracy :" &
CountRows(
Filter(
Source,
Currency="USD",
AREA="USA",
'ACCURACY STATUS'="No"
)
) &
" Report(s) Inaccurate" & Char(10) &
"Timeliness :" &
CountRows(
Filter(
Source,
Currency="USD",
AREA="USA",
'TIMELINESS STATUS'="No"
)
) &
" Report(s) not Impacted"
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Use Char(10) Example:
Wow! It's worked. Appreciate for quick response 😀
Check out new user group experience and if you are a leader please create your group
Did you miss the call?? Check out the Power Apps Community Call here!
See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.
User | Count |
---|---|
257 | |
247 | |
82 | |
36 | |
30 |
User | Count |
---|---|
299 | |
267 | |
117 | |
66 | |
45 |