cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Regular Visitor

Field name with line break in formula bar

Hello, 

I am importing an Excel Table, where one of the column titles has a line break:

"Office

Name"

When I try to select the field in the PowerApps formula bar I get an error...

 

Many thanks for your help

François

1 ACCEPTED SOLUTION

Accepted Solutions
Super User III
Super User III

Hi @francoisPAuser 

This is probably not the answer you want to hear, but I would suggest that you don't use Excel spreadsheets with line breaks in the field name.

I think this is unusual - I've not come across field names with line breaks in the time that I've been working with PowerApps.

I've just tried this and I notice that controls such as the data table and gallery controls don't properly recognise field names with a line break. Therefore, I suspect that PowerApps doesn't fully support this naming convention.

image.png

Therefore, I would recommend that you rename the field name without a line break. I would also recommend that you don't name your Excel table 'Table'. Table is the name of a function in PowerApps. If you give a data source the same name as a function, there is far greater scope for problems to occur.

View solution in original post

7 REPLIES 7
Super User III
Super User III

Have you tried Table.'office name' instead of
Table.'office
name'
It should be on the same line in Powerapps

Thanks for the quick answer.

Unfortunately if I hit backspace to bring it to the same line it does not recognize the field. 

To clarify there is a line break (entered with ALT+ENTER) in the Excel Table column title value, the line break in Excel is not just formatting because of column width. 

 

test copy.png

 

Please the Table should be your table name and not just Table.

Example Table1.'Home Office'

      or Employees.'Home Office' if Employees is the name of the Table.

 

So check the name of the Table in your excel. I hope the Table is properly formatted in you excel

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

 

Yes my table name in Excel is Table not Table1. 

i think I somehow need to convert this linebreak arrow in the formula bar (using the advanced formula bar now)

thanks

test2.png

 

No. Excel Table cannot be just Table.

To find out GoTo your Excel and recheck the Name Again.

If you imported the Excel, check similar like this:

Table1.JPG

 

If a live connection from Onedrive and how to format excel, watch this video:
https://youtu.be/-Z_13J02RPU?t=2

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Super User III
Super User III

Hi @francoisPAuser 

This is probably not the answer you want to hear, but I would suggest that you don't use Excel spreadsheets with line breaks in the field name.

I think this is unusual - I've not come across field names with line breaks in the time that I've been working with PowerApps.

I've just tried this and I notice that controls such as the data table and gallery controls don't properly recognise field names with a line break. Therefore, I suspect that PowerApps doesn't fully support this naming convention.

image.png

Therefore, I would recommend that you rename the field name without a line break. I would also recommend that you don't name your Excel table 'Table'. Table is the name of a function in PowerApps. If you give a data source the same name as a function, there is far greater scope for problems to occur.

View solution in original post

ok 😞 very clear answer thanks!

Helpful resources

Announcements
secondImage

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

Top Kudoed Authors
Users online (18,894)