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:
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.
"&" 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.
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.
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.
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.
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.
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 '='.
We're excited to announce our first cross-community 'Can You Solve These?' challenge!
Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.
We are excited for the next Super User season.
FIll out a quick form to claim your community user group member badge today!
Features releasing from October 2020 through March 2021