
Announcements
Hello,
Below is a list structure.
Based on the above, my requirement is If Audit Month selection is June, then for an Auditor, count the number of Fails against a Parameter. Maximum number of Fails are placed under Param-1, then 2 and so on. like for Auditor Sam, Parameter-1 has 2 Fails. it is placed under Param-1, Parameter-2 has 1 Fail hence under Param-2.
Need a solution.
Regards
Hi @Sam70 ,
The logic is not complete. How about some parameters has the same number of fails? How to place them? For example, if parameters from 1 to 4 of Sam are all 2, what's the result? Actually, I don't think this logic can be applied in PowerApps, you can use formula to know the number of failed for each parameter, however, I can't find a way to "sort by numbers and put results into columns".
Best regards,