Flow Failing at Switch (SharePoint value?)

(0) Share

Report

Posted on by cb23

326

Hello, I wondered if anyone could enlighten me about why this flow might be failing.

I am trying to use a switch to look up a column within a SharePoint list. I wondered if perhaps it couldn't read the number in the column so changed it so I edited this so that it returned a number and had the same issue (ActionFailed. An action failed. No dependent actions succeeded.)

Thank you. It's the last part of the flow that needs to work for testing to be complete!

Failed_Flow2.png

Flow_Failed_Switc...

I have the same question (0)

All responses (3)

Answers (1)

wskinnermctc 6,519 Moderator on at

Like (0)

Report

Re: Flow Failing at Switch (SharePoint value?)

A Switch can only compare text/string

If your absence count output is showing '1.00000000' and your Case is showing '1' then they will never equal.

Your case would need to have '1.00000000' so that it will equal the value in the Switch.

I would recommend trying to find something other than a number to use for the switch.

Was this reply helpful? Yes No
Verified answer

ManishSolanki 15,089 Super User 2025 Season 2 on at

Like (2)

Report
Re: Flow Failing at Switch (SharePoint value?)

Hi @cb23

Pls convert the decimal number to integer using int() function in an expression. Expression needs to be written in the expression box as shown below:

int(item()?['AbsenceCount1'])

Pls retest after adding an expression.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No
cb23 326 on at

Like (0)

Report

Re: Flow Failing at Switch (SharePoint value?)

Yay! This worked thank you you're a lifesaver!

Was this reply helpful? Yes No