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 / Error with SubmitForm(...
Power Apps
Answered

Error with SubmitForm() and Gallery selection

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hello!

I have created an app from an excel file (the plan is to use an SQL in the future, but while I'm working on the prototype I don't have access to this).

 

The app used fine until yesterday, when suddenly SubmitForm(form_name) stopped working and giving the error that the specified record was not found. I have not renamed the form, nor the excel file. When googling most other users had problem with required fields not being filled out, but that's not the case here.

 

The form is linked to a Gallery connected to my excel file. The titles presented in the gallery are "ID's" for each row. At the top I have dummy1, then dummy2, etc... When running the app, I may click on dummy4, but it'll directly jump back to dummy1. It's almost like it's locked to that value. However, if I click several times, it usually changes...

 

Both of these two faults occured at the same time, so my guess is that they are connected. It's not related to change of filenames nor required fields not being filled out... does anyone have any idea of what fault is causing this?

 

Thanks in advance!

H

error_message.png
Categories:
I have the same question (0)
  • PowerNuggets Profile Picture
    360 on at

    Hi @Anonymous

     

    Try removing the connection to your data source and adding it again.

     

    If the issue still exists, please consider re-typing the Patch formula in your submit

     


    _____________________________________________________________________________________
    Like my answer? - Hit that Thumbs Up. Resolved the Issue? - Hit Accept as Solution.

     

    KR,

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Hi @PowerNuggets !

    Thank you for your response!

    I've tried both refreshing the data source in power apps, and removing it and adding it again.

     

    I have tried renaming the form and deleting the

    SubmitForm(Form1)

    and then writing it again, still not working 😞

  • Verified answer
    Community Power Platform Member Profile Picture
    Microsoft Employee on at

    I solved it by connecting the data source by using a unique column from the Excel table instead of auto generating the ID!

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 320 Most Valuable Professional

#2
11manish Profile Picture

11manish 210

#3
Valantis Profile Picture

Valantis 167

Last 30 days Overall leaderboard