Skip to main content
Community site session details

Community site session details

Session Id : nHWc7ioQgtr56IiKx0W216
Power Automate - Using Flows
Answered

Flow Error - Switch Condition on SharePoint Choice column

Like (0) ShareShare
ReportReport
Posted on 19 Feb 2020 01:20:27 by 66

Hey there,

 

I'm getting an error on my flow when I try to evaluate a Switch condition and trying to evaluate the Choice value. Here is the error below:

 

The execution of template action 'Switch' failed: The result of the evaluation of 'scope' action expression '@items('Apply_to_each')?['RevisionFrequency']?['Value']' is not valid. It is of type 'Null' but is expected to be a value of type 'String, Integer'.

 

And here is a screenshot:

image.png

 

What I'm doing is I want to check if the Choice value corresponds to any of my cases that I set up, but that error shows up. Can anyone tell me what I'm doing wrong?

  • Verified answer
    v-litu-msft Profile Picture
    on 19 Feb 2020 at 04:19:07
    Re: Flow Error - Switch Condition on SharePoint Choice column

    Hi @hexarthrius,

     

    I am glad you have solved your problem, the reason for the error will report is that if the condition couldn't get the expected type's value, it will report that type of alarm.
    If your problem has been solved, You could go ahead and mark your post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!

    Best Regards,
    Community Support Team _ Lin Tu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Verified answer
    hexarthrius Profile Picture
    66 on 19 Feb 2020 at 01:26:49
    Re: Flow Error - Switch Condition on SharePoint Choice column

    Update: So far so good, I was guessing that the list has blank values so I put a condition to check if there is value by putting on is equal to Null

     

     
     

    image.png

     

    The documents are around 405, I'll check if this yields some positive results. But still looking for some answers if anyone has already encountered and solved this.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 986 Moderator

#2
stampcoin Profile Picture

stampcoin 699 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 577 Super User 2025 Season 2

Featured topics

Restore a deleted flow
Loading complete