Check certain fields have responses before showing a field

  • 17 July 2020
  • 1 reply
  • 4 views

Badge +1

I have a Nintex Form on a SharePoint list. The list has 11 choice fields.

 

At the bottom of the form is a "Ready to submit" Yes/No field. When the user ticks this and saves the item, this triggers a PowerAutomate flow.

 

I want the "Ready to submit" field to be hidden until responses have been given for all 11 choice fields.

 

I was thinking perhaps I could create a variable that counts up the number of nonblank responses, then create a rule that hides the "Ready to submit" field unless the variable = 11?

 

Would that work? Could someone give me some guidance on how to create that variable?


1 reply

Badge +8

Hi @sandra_mcg,

just an idea: isNullOrEmpty() returns you a boolean (true,false // 1,0).

You can sum the number of non-empty-fields using

8414i48930D3C479BA7BA.png

And then validate against this number being 11.

Reply