Unanswered

Using mutliple switch functions to make a string, patching this to a text field.

(0) Share

Report

Posted on by PonceletSeba

Dear PowerApps Community,

Trying to make a string depending on the values of some comboboxes. I am using two comboboxes, and then two switch functions to evaluate the combobox values. For some reason this is not able to patch correctly to a test field (results in "false" being written instead of my string).

This setup works whilst only using one combobox, so my guess is something is going wrong combining the parts of the string.

Patch(Wisselstukken;
{'Id (ID)': galStockList.Selected.'Id (ID)'};
{Place: 
(
(Switch(cboLocationSite.Selected.Value; "BIOPOWER"; "EBO"; "GREENPOWER"; "EGO")) 
&& "/" &&
(Switch(cboLocationMainRoom.Selected.Value; "ENGINES"; "E";"VOLTAGE DISTRIBUTION" ; "VD";"TECHNICAL" ; "T";"LABO"; "LB";"COMMON" ; "C";
"IT - SERVER ROOM";"IT";"OFFICES"; "O"; "STEAM TURBINE";"ST")
))
});;

Any idea?

Kind regards,

Sébastien

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

v-mengmli-msft on at

Like (1)

Report
Hi @PonceletSeba ,

Please try this:
Patch(Wisselstukken; {'Id (ID)': galStockList.Selected.'Id (ID)'}; {Place: ( (Switch(cboLocationSite.Selected.Value; "BIOPOWER"; "EBO"; "GREENPOWER"; "EGO")) & "/" & (Switch(cboLocationMainRoom.Selected.Value; "ENGINES"; "E";"VOLTAGE DISTRIBUTION" ; "VD";"TECHNICAL" ; "T";"LABO"; "LB";"COMMON" ; "C"; "IT - SERVER ROOM";"IT";"OFFICES"; "O"; "STEAM TURBINE";"ST") )) });

Best regards,
Rimmon Li

Was this reply helpful? Yes No
PonceletSeba 81 on at

Like (0)

Report

Thanks, apparently there is a huge difference between the use of && and &.

Was this reply helpful? Yes No
WarrenBelz 153,049 Most Valuable Professional on at

Like (1)

Report
Hi @PonceletSeba ,

I tend to keep "calculations" out of a Patch - try this

With( { _Site: Switch( cboLocationSite.Selected.Value; "BIOPOWER"; "EBO"; "GREENPOWER"; "EGO" ); _Room: Switch( cboLocationMainRoom.Selected.Value; "ENGINES"; "E"; "VOLTAGE DISTRIBUTION"; "VD"; "TECHNICAL"; "T"; "LABO"; "LB"; "COMMON"; "C"; "IT - SERVER ROOM"; "IT"; "OFFICES"; "O"; " STEAM TURBINE"; "ST" ) }, Patch( Wisselstukken; {'Id (ID)': galStockList.Selected.'Id (ID)'}; {Place: _Site & "/" & _Room} ) );;

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
PonceletSeba 81 on at

Like (0)

Report

Hi Warren,

My first attempt was to keep the calculations out of the patch functions using a variable "VarLocation" calculating everything under this variable. I might replace it in the future if problems rise up.

Kind regards,

Sébastien

Was this reply helpful? Yes No