Switch error

[Aye3]

Hello! Can someone please help me with this error? I'm not sure what it means 

[David_MA]

The error message essentially means you are trying to pass multiple values through the switch. You can only pass one value at a time. Is your region value a choice field? If so, you need to pass the one from the dynamic content that shows value after the field (i.e., Region Value).

[Aye3]

Yes region value is a choice. Also, can you re-explain what I need to pass? I'm not sure 

[Nived_Nambiar]

Hi @Aye3 

As @David_MA  suggested , pass this value in the switch action

Thanks & Regards,

Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

[Aye3]

Oh I see. I put the region value in switch. However the error still comes up but the email gets sent

[Nived_Nambiar]

Hi @Aye3 

may be for one of the iteration, Region Value is AB that is the reason it send the email - could you confirm what are other values for other items ?

Thanks & Regards,

Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

[Aye3]

The other values are SK, MB, ON, QC. USA, OTTAWA and AT. I added other cases but I'm receiving an new error.

               

[David_MA]

Based on the error message, one of your list items does not have the region populated. I would make this a required field in your list. Otherwise, add a condition to your flow to check if the field is null. I would have thought the switch would use the default if the value was null, but every time I have used a switch, I have used it on a field that is required.

[Aye3]

Region is a required field, I think it has something to do with this:

After I run the flow, I get a blank entry show up on the SharePoint list

[David_MA]

I don't think I understand your flow process if the field is required in your list. Is the flow not triggered by the list item? Are you adding these rows to the list as part of your flow? If it is triggered when an item is added to the list, you'll need to figure out how people are adding items without populating the required fields.

[Aye3]

Oh sorry, I'm not that good at explaining things lol. My flow is triggered when someone adds a new item to the SharePoint List.

[David_MA]

Are you sure the region field is required? I don't understand how the flow can fail with a null choice if it is required. You should double check your list settings on that question. If it is required, it should have a red asterisk after it.

[Aye3]

Yes, region value is a required field.

[Nived_Nambiar]

Hi @Aye3 

I could see column Name is Region Value not Region, would that be the reason why it got null ?  I am not sure whether u have renamed the column name from Region to Region Value in between.

If Region Value was the column- could you try the following expression in switch and see whether that works ?

items('Apply_to_each_2')?['RegionValue/Value']

Or see in switch action, check whether there is any dynamic content with name Region Value Value , if yes use that instead

Thanks & Regards,

Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

[Aye3]

Hi @Nived_Nambiar

I have selected Region Value Value for switch but I still see an error. Also, whenever I run my flow, I get a blank entry added to my list. I'm not sure what is causing this but I think that's why the flow isn't working

[Nived_Nambiar · Accepted solution]

Hi @Aye3 

You can iterate through output of html table as it is string in output. Either use the select action which you have used to create HTML table.

Also in select action update the Region Value dynamic content with Region Value Value dynamic content 🙂

Thanks & Regards,

Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Thanks & Regards,

Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

[Aye3]

Hi @Nived_Nambiar 

I updated the select action, I put Region Value Value. Can you please take a look at the second half of my flow?