Unanswered

Multiple Conditions entries

(0) Share

Report

Posted on by Community Power Pla...

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

All responses (3)

Answers (1)

Community Power Pla... on at

Like (0)

Report

Re: Multiple Conditions entries

@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.
Community Power Pla... on at

Like (0)

Report

Re: Multiple Conditions entries

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.
Verified answer

v-yamao-msft on at

Like (0)

Report

Re: Multiple Conditions entries

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