Answered

Multiple Conditions entries

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello All,

I've hit a roadblock in my flow. I have a sharepoint list with around 3 quiz results. Whenever someone finishes a quiz it is recorded in a List A which will trigger List B(below) I want to update a column (Level1Complete) when all quizzes have been taken and send an email. I feel like the size of my flow will be huge if I were to check for a value for each column per user and if a user completed all then Level1Complete will be updated to Yes but the problem is that I have two more quizzes in the list.

Is there a way to do this that I'm not thinking of? Again it's to check if a user has completed all quizzes which will update a column.

Screenshot_2018_1_10_Edit_your_flow_Microsoft_Flow

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

v-yamao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous,

I would like to know more details about your scenario. What are the two lists Quiz Results and QuizStatus?

According to your description, it seems that you are trying to create a flow to update a column “Level1Complete” in a list when all quizzes have been taken then send an email.

To check whether all the fields in a list have been taken, we could try to combine functions “and” and “empty”.

I have made a small test on my side, the function I am using is:
@and(not(empty(triggerBody()?['Title'])),not(empty(string(triggerBody()?['opcy']))))

PS: the column ‘cpcy’ is of type float, while a string is asked in the empty function so I use string function to convert it to an expected type.

The flow might be configured likes below:

Please take this for a reference.

Reference material:

https://docs.microsoft.com/en-us/azure/logic-apps/logic-apps-workflow-definition-language

Best regards,
Mabel Mao

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello @v-yamao-msft

The Quiz Result list is a list of all quiz taken by users. Users can retake a quiz for a higher grade and that will also be recorded.
The Quiz Status list is a compiled version where when an item is created in Quiz Result. Quiz Status will record the user and mark the quiz they have done and if a user retakes a quiz it updates the user's score. So instead of having multiple rows for one user Quiz Status creates one row per user and records the grade under the corresponding quiz column.

All of my columns are string type. I'll try and fiddle with your function.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@v-yamao-msftI was able to get it working with your function. One of my title has an apostrohe for example ['User's Grade'] which gives me an error when I try to update the item.

Was this reply helpful? Yes No