Switch function

[nliu]

Hello,

I would like to use a switch function in my datasource property in my form. But it seems like the form is not connected to any of my SP List. Do you know why and how can I fix it ?

Note : all my SP List has the same columns/structure

Thank you, 

[WarrenBelz · Accepted solution]

Hi @nliu ,

Your syntax looks OK, but I cannot check the validity of your Variable.

I just did a quick test using the same logic and got the same result as you until the Variable was set to one of the choices.

Once I did that, all was well.

Note that in Design mode, Variables quite often reset.

Try putting a label the the variable, set it and then check if it is one of your choices.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[eka24]

Insert a dropdown and put in the items property:

["DT","DTECA","DTECE"] Add all other list of items you have.

Then in the Datasource of the form :

Switch(Dropdown5.SelectedText.Value,

"DTECA",ZA_Hardard_List,

"DT", ZA_Cost)

Change ZA_Hardard_List,ZA_Cost to your datasoucrces. Also add all other datasources.

If you like this reply, please give kudos. And if this solves your problem,
please accept this reply as the solution.

[nliu]

@eka24 @WarrenBelz 

Thank you both for your answers, here a screen where my variable "myTarget" is set :

Set(myTarget; "DTEXXX") is set on each button. But yes I try to click on one of this button and the form appears and the data was connected to right datasource. So as long as you don't choose on which datasource you are working with, the data will no longer be connected to the form.

[WarrenBelz]

Hi @nliu ,

Are you saying it is working as designed or do you have another question?

If working, please consider accepting either or both of the proposed solutions.

[nliu]

Yes it is working as designed 🙂