Intellisense Issue with Experimental Enhanced Formula Bar in canvas app for Power Apps

I have been using Experimental formula bar in Power Apps Studio for a week and so far, I really like it. I can

  • use Enter for a new line
  • bring up suggestions on-demand using pressing CTRL+ Space (which does not show all the time)
  • navigate around the formula bar with Up and Down arrow keys without getting into suggestions
  • expand the formula bar with one click without dragging down all the time
  • look through the items within a group in the property dropdown
Now I feel more like coding in the formula bar rather than using excel formula bar.

But there is one issue that I am encountering Intellisense issue with Experimental Enhanced Formula Bar where the code-completion doesn't remove the user entered partial words properly.

Based on my observation, it would just remove the alphanumeric characters immediately before the cursor and not removing the characters before a space or the single quote ' 
 
Scenario 1
The maker entered  'Phon
Pressed CTRL + Space and chose 'Phone Calls' from the list.
Outcome: ''Phone Calls'    (with x2 single quotes in the beginning)

Scenario 2
The maker entered  'Phone C
Pressed CTRL + Space and chose 'Phone Calls' from the list.
Expectation: 'Phone Calls'
Outcome: 'Phone 'Phone Calls'     (with space and all characters before space not being removed)

It's a bit annoying to move the cursor and remove the characters manually.
But when I posted on the Power Apps Community Forum, I got a response from Microsoft Community Support Team engineer suggested me to type data source name, Function name, operators ... directly without adding an additional single quote.

If you are having the same frustration as me with Experimental Enhanced Formula Bar, change the behaviour and type the word directly (until the Intellisense show up) rather than starting with a single quote. (until Microsoft has worked on some refinements for the intellisense)

Comments

Popular Posts