Unanswered

Complex Flow Using Switch Actions Failing on Set Var

(0) Share

Report

Posted on by MarshallPlexi

I am building a new Flow to migrate data from a SP list data source (for a Power Apps) to a new Dataverse table based on Shane Young's excellent video: Import SharePoint to Dataverse for Teams with Power Automate
I am NOT using this for Teams but the same steps from the video apply with regards to the color choice column.
This is a manually triggered Flow and I first initialize ten variables for use later when adding a new row to DV. Then the Flow gets all items from a SP list and adds new rows to a Dataverse table which contains the appropriate column data types.
Within the Apply to Each there are eight (should be ten but this is a work in progress) Switch actions whose purpose is to determine the Dataverse equivalent ID to the SP list choice column selection. So when a record contains a value from a SP choice column, I set the respective variable to the DV ID equivalent of that selected choice). All SP list columns for this Flow are choice columns and I will add the easy columns later once the errors have been resolved.
Here are some images of my Flow for reference:

Overview of Flow Actions:
Flow - Migrate List Data to DV ERR 1.png
The first Switch action works great but it throws an error on the DHC Predictor Score Value (Get Items) action.

Here is what the DHC Predictor Score Switch action looks like. I confirmed these values by hard-coding a choice selection and peeking the code to retrieve the DV ID value.

Flow - Migrate List Data to DV ERR 3.png

Here are screenshots from the error page.
Flow - Migrate List Data to DV ERR Details 1.png

Any help is appreciated.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

MarshallPlexi 16 on at

Like (0)

Report

UPDATE: I can replace the Switch actions with Conditional actions and it will work but I'm still interested in how to make this flow work using Switch actions. Can anyone provide some insight?

Was this reply helpful? Yes No
Verified answer

v-jefferni on at

Like (0)

Report

Hi @MarshallPlexi ,

Am not sure but this kind of error may cause by datatype of the input parameter. I found a thread with an explanation that seems to make sense:

https://powerusers.microsoft.com/t5/General-Power-Automate/Switch-Case-not-working-with-setting-variables/td-p/76200

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
MarshallPlexi 16 on at

Like (0)

Report

@v-jefferni - Thank you for your response! Ensuring the data types are set to integer was the solution.
I made two updates to try to resolve this issue. First, I changed from string to integer when initializing the varDHCPredictorScrore & varDHCCloser variables.

Second, I added two Compose actions to force integer data types for the varDHCPredictorScrore & varDHCCloser variables and the Switch actions use the outputs from the respective Compose actions (code shown below).

Here is the complete, updated Flow.

This is an expanded view of the most important actions in more detail.

Then here is the end of the Flow.

Thanks again!

Was this reply helpful? Yes No