cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MelindaK
Level 8

Escape "&" in drop down value

Hi all,

 

I am currently working on creating a new PowerApp for ordering items, and I have a text box which calculates the total cost based on the unit cost and quantity. I am using the text in the dropdown to filter the items to get the unit price, and I have just noticed that when the text contains "&" it stops reading after that character. 

 

This is the formula I am using:

If(Value(Quantity.Text) > 0 ,Value(Quantity.Text) * First(Filter(UnitaryOrderingFeederList, Unit_x0020_Name = UnitName.Selected.Value)).CostValue, First(Filter(UnitaryOrderingFeederList, Unit_x0020_Name = UnitName.Selected.Unit_x0020_Name)).CostValue)

 

And this is the error that shows up:

error.png

 

 

Has anyone had any similar issue? 

 

P.S. I should probably mention that I have tried to use a text convertion (Unit_x0020_Name = Text(UnitName.Selected.Unit_x0020_Name)), but it doesn't work.

 

 

 

MelindaK
10 REPLIES 10
Highlighted
hpkeong
Level 10

Re: Escape "&" in drop down value

Hi @MelindaK

 

"&" is similar to Concatenate.

I guess it confused the formula. Can you try changing to others to avoid conflicts to those "controlled keywords used by PowerApps".

 

I can;t really remember where but I know it is mentioned inside tutorial to avoid using some keywords.

 

Hope this helps.

hpkeong
MelindaK
Level 8

Re: Escape "&" in drop down value

Unfortunately, I do not have control over what is in that drop down. It is fed by a SharePoint list which is maintained by users. So, I need the solution to be as generic as possible. 

MelindaK
Power Apps Staff AndyPennell
Power Apps Staff

Re: Escape "&" in drop down value

This appears to be a bug in the query generation where the "&" is not being escaped correctly when we generate the query to the server for delegation. Thank you for the report, we are investigating.

MelindaK
Level 8

Re: Escape "&" in drop down value

Thank you for your reply. Please let me know if it gets fixed 🙂 

MelindaK
Power Apps Staff Reza
Power Apps Staff

Re: Escape "&" in drop down value

Hi Melinda,

 

What connector are you using?

 

Thanks

Reza

 

MelindaK
Level 8

Re: Escape "&" in drop down value

For connecting to the SharePoint list I am using the SharePoint connector. 

The function should filter the SharePoint list items based on their names. Some having the '&' in their names.

MelindaK
MelindaK
Level 8

Re: Escape "&" in drop down value

Is there any news regarding this problem? I am about to release a power app to users and without this fixed I will need to change all the entries that contain "&" in an existing list. 

 

Thanks,

MelindaK

MelindaK
MelindaK
Level 8

Re: Escape "&" in drop down value

Hi,

 

Has there been any updates on this? I still need a solution to this, it looks like the filtering doesn't work properly either with fields that have '+' in their names, forcing me to use 'in' instead of '+' - generating the blue icon. 

 

For example, if I have an entry with name 'F+T' it will not retrieve the value in another column unless I use 'in' in the filtering query. For any other value, it retrieves correctly even if I use '='.

 

Thanks,

MelindaK

MelindaK
Power Apps Staff KeremY
Power Apps Staff

Re: Escape "&" in drop down value

Hi everyone, we have a fix for this issue in the pipeline. It should be available by end of May. We appreciate your feedback and patience on it. 

Helpful resources

Announcements
thirdimage

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors
Users online (5,895)