You’re offline. This is a read only version of the page.
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!
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.
For your DefaultSelectedItems property of your column with the choice "Pass" or "Fail" in your form.
Share
Report
All responses (
Answers (
2,241If(
// 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,
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
Yes Correct
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
