web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Canvas apps connection...
Power Apps
Answered

Canvas apps connection to data in a Share Point list that was created through an Excel file: Be wary of line breaks in column headers!

(1) ShareShare
ReportReport
Posted on by 401

Hello!

Our organization experienced weird problems with a canvas app... and found a solution. I wish to share this solution with the community, in case anyone else ever has the same problem.

 

The problem:

  • I am the owner of a canvas app, and one of my colleagues is a co-owner.
  • When I try to edit the app, everything is fine:
    • CharlesS_0-1634824804540.png
  • When my colleague tries to edit the app, all of the formulas "break" with mysterious line breaks:
    • CharlesS_1-1634824852640.png
  • When my colleagues tries to edit the app, the code is pretty much broken everywhere, with these line breaks throughout the app, but always at the same places.

Problem exploration:

  • The app connects to a Sharepoint list where the data is stored.
  • The Sharepoint list itself was created using the "Create a list - From Excel" functionality in Sharepoint:
    • CharlesS_2-1634825076442.png
  • At first glance, everything in the Sharepoint list looks just fine.
  • However, we went back to the original Excel file from which the Sharepoint list was created.
  • We noticed that the column headers from the original file included line breaks:
    • CharlesS_3-1634825506324.png

Implemented solution:

  • We removed all line breaks (and also removed all non alphabetic characters, just to be sure) from the original Excel file.
  • We recreated a new Sharepoint list using the corrected Excel file.
  • We reconfigured the canvas app to use the new Sharepoint list as a data source.
  • Everything now works fine!

Hopefully this post will one day help somebody, somewhere!

 

Keep 'em flowin'!

 

Charles

Categories:
I have the same question (0)
  • poweractivate Profile Picture
    11,078 Most Valuable Professional on at

    @CharlesS Thanks, this may be important, actually - thank you for sharing it.

  • Verified answer
    v-qiaqi@microsoft.com Profile Picture
    Microsoft Employee on at

    Hi @CharlesS,

    Thanks for your sharing and I will mark here to help more users who may have the similar issue.

    Thanks for your contribution.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Vish WR Profile Picture

Vish WR 1,027

#2
Valantis Profile Picture

Valantis 644

#3
11manish Profile Picture

11manish 626

Last 30 days Overall leaderboard