Unanswered

Using a choice column to to select beween options "Pass" and "Fail" whenever my test score column equals less than the required score to pass

(0) Share

Report

Posted on by blakelemay

Hello,

I made a flow between a Form Quiz and a Sharepoint list. Basically the list gives correct form responses a value of 1 and adds those up in a "Test Score" column. I have a choice column with a blue "Pass" bubble and a red "Fail" bubble. I want my Test Score column to select one of these options based on the test score. So the person submitting the quiz needs to have a score off 33 or higher. So, I basically want the column to act accordingly:

The value of the test score column is 33 or higher --> Select "Pass" bubble.

The value of the test score column is less than 33 --> select "Fail" bubble.

I understand that I could just make it a text column just to simply say "pass" or "fail", but that wont look as pretty so I have it as a back up option. I am very new to Power Automate and Sharepoint so I was hoping you guys could point me in the right direction!

Cheers.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (7)

Answers (0)

Sort by

VJR 7,635 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @blakelemay

This is a Power Automate Desktop forum used for Desktop flows.
From the content of your post looks like you are seeking help on Cloud flows which you will surely get here.
In which case you can close this thread.
Good day.

Was this reply helpful? Yes No
MichaelAnnis 5,727 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

If it’s in share point, it should have a UI to the Pass and Fail bubbles, so the logic would be the same regardless of flow or PAD.

if >= 33, then select pass bubble;
else, select fail bubble
endif.

Was this reply helpful? Yes No
blakelemay 23 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, Thanks for your help.

So where and how would i type that? is it exactly how you typed it?

Was this reply helpful? Yes No
MichaelAnnis 5,727 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

If you share a screenshot of your flow, I might be able to help better. Depends on how you are getting the total of the column.

Was this reply helpful? Yes No
blakelemay 23 on at

Like
a
(0)

Report
Copy link

Link copied!

Example: The answer to the form response (for Question number 6) goes to "Q6", "Q6V" searches for the right answer in "Q6". If "Q6" displays the right answer, it gets a value of "1", if not it gets a value of "0". The "Test Score" Column adds up all the "1" values. The "Pass/Fail" Column displays "Pass" if the score is 33 or higher, and "Fail" if he score is lower than 33. So what I have now works, I just want to see If i can have a bubble say "Pass" or "Fail" like you see in the "Retake?" column.

Again, thank you for your help!

Was this reply helpful? Yes No
MichaelAnnis 5,727 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Yeah, sorry. Not familiar. @VJR was right. You are working in a flow, and need a different forum. As a general rule, you are looking for conditional actions, but I'm not familiar with the ones in your program. Best of luck!

Was this reply helpful? Yes No
VJR 7,635 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @blakelemay

- What is the datatype of the "Retake" column and what is the type of "Pass/Fail" column?
- How did you get the "Yes" on the "Retake" column?
- Is this a Sharepoint list?
- Did you try passing "Pass" to the "Retake" column via the Flow and see what happens?

Was this reply helpful? Yes No