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 / Correcting form behavi...
Power Apps
Answered

Correcting form behaviour after moving datasource to Sharepoint

(0) ShareShare
ReportReport
Posted on by 716 Moderator

The application started as a simple thing based on a spreadsheet.

After the limitations of using Excel as a datasource became enough of a pain, I recreated everything in Sharepoint using lists.

 

On my "New Ticket" page, I could not even figure out how to reconnect the data cards within the form to the new source. So I deleted them one at a time and re-added. Problem solved.

But in that process, I discovered that SP names things like "field_1" etc. I tried changing to the display name which interestingly will then not cause an error but simply won't work when you submit. So I changed them all back.

 

This morning it was time to mod the "Details" page. I was able to find the "field_X" names using the Edit Settings trick to see them in the url. I thought I was golden and changed all of the data cards to point to the correct fields. When all the data populated in the form for editing, I thought I was solid.

 

But no... there is something else happening I cannot figure out. Every single card is pointed to the correct field/fieldname and none of the controls show any errors. And the correct data from the source appears when the page loads.

 

But when I SubmitForm, an Unknown error occurs.

 

Does anyone know how to fix this without manually removing and adding the controls again?

 

And if the answer is no, is it possible to pre-define colour, border colour, fill, hover fill etc? Fixing formatting takes far longer than fixing the data connection itself.

Categories:
I have the same question (0)
  • Verified answer
    WarrenBelz Profile Picture
    154,928 Most Valuable Professional on at

    Hi @DCHammer ,

    Sorry to give you the bad news, but using the "import from Excel" option to create a SharePoint list is not the best idea as it creates underlying field names of field_x - I suggest you first recreate your SharePoint list directly in SharePoint and then you can paste in your data from Excel in Edit in Grid View with a View lining up the fields in both.

     

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

    MVP (Business Applications)   Visit my blog Practical Power Apps

  • DCHammer Profile Picture
    716 Moderator on at

    Thanks Warren. I fully expected that to be the answer. I didn't want to recreate the entire list so the import resulted in those odd field names and I'm just living with it.

    I had to delete every data card in the form and recreate them pointing to the new data source. It's been really good practice. 

    I also learned that you can make effective use of SP List field types and properties as well. When data was in Excel, there were separate tabs holding metadata (list choices mostly) that were a pain. Now they're in Choice fields in the primary data table and PA automatically knows how to handle.

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 March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 551

#2
WarrenBelz Profile Picture

WarrenBelz 430 Most Valuable Professional

#3
Valantis Profile Picture

Valantis 298

Last 30 days Overall leaderboard