cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Experiencing very weird issue when sql table column names got spaces or _ etc

Hi 

I am facing very weird issues when the column names got space or _ etc and also table name got space or _ 

 

I am using small table from Power BI report and through service when I try to create PowerApps Visual  which is usually takes the filter data  through Power Aps application -->  screen1 ( Gallery) and then screen2 (Edit form) to update the data 

Usually Edit form is populated from screen1 Gallery  as Gallery1.Selected . This works perfect if my table name or columns does not fall into the issue as i described above  . If I use any tables which contains spaces or _ then Gallery1.Selected never ever work for editform items property (Edit form Item property=Gallery1,.Selected)

Does anybody has faced similar issue or is this a  known bug 

 

 

1 REPLY 1
Highlighted
Microsoft
Microsoft

Re: Experiencing very weird issue when sql table column names got spaces or _ etc

Hello,

 

If you have not tried before, I would suggest creating a sample app from Azure portal and then check how the properties are returned on the powerapps including the column names in edit form.

 

Please refer to the article below for more information:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/app-from-azure-sql-database

 

Screen1.png

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (8,030)