In a Row Count "Correct"

(0) Share

Report

Posted on by GF-02121351-0

239

Hi,

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

QA Team completes Form
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

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (0)

a33ik 3,306 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hello,

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

Was this reply helpful? Yes No
gulshankhurana 1,397 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @gfeldhake

Is it a canvas app or model driven app?

Kind regards
Gulshan

Was this reply helpful? Yes No
Michael E. Gernaey 53,960 Moderator on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
GF-02121351-0 239 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No