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
Solved! Go to Solution.
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.
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.
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.
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
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:
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.
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.
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.
ok ๐ very clear answer thanks!
Check out new user group experience and if you are a leader please create your group
Did you miss the call?? Check out the Power Apps Community Call here!
See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.
User | Count |
---|---|
269 | |
227 | |
77 | |
38 | |
37 |
User | Count |
---|---|
340 | |
226 | |
121 | |
71 | |
55 |