web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / In a Row Count "Correct"
Power Apps
Unanswered

In a Row Count "Correct"

(0) ShareShare
ReportReport
Posted on by 239

Hi, 

I have a Microsoft form for internal auditing, and I need to calculate if the specialist has passed the audit. The workflow: 

  1. QA Team completes Form 
  2. New row is added to the Audit Dataverse Table. 

My approach is to add a formula column in the Audit table that counts the number of times the word "Correct" appears in the row. 

We have 65 metrics that this formula needs to look at. Any suggestions on how to set up this formula?

 

Thanks

I have the same question (0)
  • a33ik Profile Picture
    3,306 Most Valuable Professional on at

    Hello,

    I'm afraid you won't be able to do that because the Audit table is not customizable.

  • gulshankhurana Profile Picture
    1,397 Moderator on at

    Hi @gfeldhake 

     

    Is it a canvas app or model driven app?

     

    Kind regards

    Gulshan

  • Michael E. Gernaey Profile Picture
    53,184 Super User 2025 Season 2 on at

    Hi,

     

    Is this a custom Table called Audit (I hope), (as @a33ik  mentioned it wont work in the actual Audit table)

     

    Would you be willing to use a Flow that is triggered when a form is submitted? Then you could use Power Automate aka flow to count it and write back, or you would use a Plugin, that runs when its created, it could do what you are asking and write back... but again to a custom table.

     

    I would suggest using a Flow, easier to manage and support etc etc


    Cheers
    If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
    Thank You
    Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
    https://gernaeysoftware.com
    LinkedIn: https://www.linkedin.com/in/michaelgernaey

  • GF-02121351-0 Profile Picture
    239 on at

    Yes, sorry for the confusion the real name of the table is QA Performance Audit, and it is a custom table. 

     

    I am not opposed to a Flow at all. I have one that creates the Dataverse row when a new record is submitted. 

    How would you set up the flow to count if correct? 

     

    Thanks

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 840 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 332 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 275

Last 30 days Overall leaderboard