Calculating results on a submitted MS Form when submitting to the database.

Like (0) Share

Report

Posted on 21 Jan 2021 03:45:15 by nhale

Looking for suggestions. I have a flow setup to add the results of an MS form into my SQL database. This is all setup and working correctly. The form has ~ 100 yes/no questions. I need to be able to calculate the number of yes's and add this into a column in the record. Is there a way to iterate through each question on my form or create an array to loop through and do a count? I have spent some time looking but can't figure out conceptually how to make this happen. Thanks

Categories:

Business Process Flows

I have the same question (0)

All responses (2)

Answers (1)

nhale 79 on 22 Jan 2021 at 16:21:16

Like (0)

Report

Re: Calculating results on a submitted MS Form when submitting to the database.

Thanks, just wanted to make sure there was not a better way.

Was this reply helpful? Yes No
Verified answer

fchopo 7,972 Moderator on 21 Jan 2021 at 18:08:07

Like (0)

Report

Re: Calculating results on a submitted MS Form when submitting to the database.

Hello @nhale

Unfortunately that's not possible. You should do this calculation inside the record after stored in the database, for example.

Regards,

Ferran

Was this reply helpful? Yes No