Question - Pass or Fail based on fields being chosen yes or no

(0) Share

Report

Posted on by PowerNovice

Hi,

I have a form, this form is connected to a sharepoint list - i also have a column in my sharepoint list for "Pass" or "Fail" - at the moment this is populated as empty.

I need to fill this with either pass or fail based on the outcome on the dropdown boxes within the form.

i.e. 12/12 say "Yes" - it need to populate "Pass"

10/12 say "Yes" and the remainder say "No" - It needs to populate "Fail"

Do any of you guys know the best way of doing this. I have tried doing a count of all that say yes and then comparing that in order to populate but this does not work. I cant seem to get the variable to initialise within onstart.

Any help would be much appreciated.

Thank you!

Categories:

General Questions

Mobile App

I have the same question (0)

All responses (10)

Answers (2)

AARON_C 2,233 Most Valuable Professional on at

Like (0)

Report

Re: Question - Pass or Fail based on fields being chosen yes or no

Hi @PowerNovice,

Can you please show me your current form.

Was this reply helpful? Yes No
PowerNovice on at

Like (0)

Report

Re: Question - Pass or Fail based on fields being chosen yes or no

Hi @AARON_C ,

Please see below;

Was this reply helpful? Yes No
AARON_C 2,233 Most Valuable Professional on at

Like (0)

Report

Re: Question - Pass or Fail based on fields being chosen yes or no

@PowerNovice

Okay, so if any of the drops down say no, you want the outcome to be fail?

Was this reply helpful? Yes No
PowerNovice on at

Like (0)

Report

Re: Question - Pass or Fail based on fields being chosen yes or no

Yes Correct

Was this reply helpful? Yes No
PowerNovice on at

Like (0)

Report

Re: Question - Pass or Fail based on fields being chosen yes or no

Wait sorry @AARON_C i have one dropdown which needs to be no in order to pass as well "No obvious damage" = No not Yes

Was this reply helpful? Yes No
Verified answer

AARON_C 2,233 Most Valuable Professional on at

Like (1)

Report
Re: Question - Pass or Fail based on fields being chosen yes or no

@PowerNovice

For your DefaultSelectedItems property of your column with the choice "Pass" or "Fail" in your form.
If( // Logical condition DataCardValue1.Selected.Value = "No" || DataCardValue2.Selected.Value = "No" || DataCardValue3.Selected.Value = "No", // If true {value: "Fail}, // Else {value: "Pass"} )
This works in dataverse.

Please tick Accept as solution if the answer is useful.
Thanks,
@AARON_C

Was this reply helpful? Yes No
PowerNovice on at

Like (0)

Report

Re: Question - Pass or Fail based on fields being chosen yes or no

Hi @AARON_C ,

The column uses a text datacard - i cant seem to find that property DefaultSelectedItems, so i have put it in the default, but i am getting an error.

Was this reply helpful? Yes No
AARON_C 2,233 Most Valuable Professional on at

Like (0)

Report

Re: Question - Pass or Fail based on fields being chosen yes or no

@PowerNovice

Try this on the Default property then and change the it to just "Fail" and "Pass"

Was this reply helpful? Yes No
PowerNovice on at

Like (0)

Report

Re: Question - Pass or Fail based on fields being chosen yes or no

Hi @AARON_C ,

That works thank you!

Was this reply helpful? Yes No
Verified answer

PowerNovice on at

Like (0)

Report

Re: Question - Pass or Fail based on fields being chosen yes or no

Was this reply helpful? Yes No