cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
keremtsc
Helper I
Helper I

Creating a SharePoint endresult

Hello,

 

so I've created a flow which puts answers that were submitted in a MS Forms into a SharePoint List. After that it "scans" the answers and creates a endresult depending on them.

There are multiple questions with the same selection of answers. There are 4 in total:

 

1. Yes

2. No

3. Not applicable

4. Not reviewed yet

 

And 3 different endresults:

 

1. Approved

2. Not approved

3. Approved but revisit

 

The way the endresults are supposed to work is like this:

 

1. If all the answers are "yes" or "Not applicable" -> Approved

2. If there is one or more "no" answer -> Not approved

3. If there is one or more "Not reviewed yet" answer -> Approved but revisit

 

In this case the "no" has a higher priority than the "Not reviewed yet".

 

The 2. and the 3. endresults are working. I also managed to make the flow put the "approved" endresult in when every answer is yes. But I didnt make it work for answers when there is e.g. "yes" in 3 answers and "Not applicable" in the other one.

 

This is how my flow looks:

 

keremtsc_0-1637925840833.png

 

keremtsc_1-1637925840835.png

 

keremtsc_2-1637925840836.png

 

The "If yes" part looks the same as the other connectors . It is clear to me that this is wrong but , I just testet some things out here.

 

Thanks in advance

Kerem

1 ACCEPTED SOLUTION

Accepted Solutions
v-JessicaG-msft
Community Support
Community Support

Hi @keremtsc ,

 

Do you want flow to create "Approved" end results?

 

You could get its result by excluding all conditions that do not meet "approved". I have test for your reference, please refer to the screenshot below:

vJessicaGmsft_0-1638259845916.png

 

 

vJessicaGmsft_1-1638259845920.jpeg

 

 

Best Regards,

Jessica Gu

View solution in original post

1 REPLY 1
v-JessicaG-msft
Community Support
Community Support

Hi @keremtsc ,

 

Do you want flow to create "Approved" end results?

 

You could get its result by excluding all conditions that do not meet "approved". I have test for your reference, please refer to the screenshot below:

vJessicaGmsft_0-1638259845916.png

 

 

vJessicaGmsft_1-1638259845920.jpeg

 

 

Best Regards,

Jessica Gu

View solution in original post

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (2,573)