cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
Super User
Super User

Re: Field name with line break in formula bar

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
Highlighted
Community Champion
Community Champion

Re: Field name with line break in formula bar

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

Re: Field name with line break in formula bar

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

 

Highlighted
Community Champion
Community Champion

Re: Field name with line break in formula bar

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.

 

Highlighted
Regular Visitor

Re: Field name with line break in formula bar

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

 

Highlighted
Community Champion
Community Champion

Re: Field name with line break in formula bar

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.

Highlighted
Super User
Super User

Re: Field name with line break in formula bar

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

Highlighted
Regular Visitor

Re: Field name with line break in formula bar

ok 😞 very clear answer thanks!

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!

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