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 / Wrong values being sub...
Power Apps
Unanswered

Wrong values being submitted from Form.

(0) ShareShare
ReportReport
Posted on by 43

On the form attached, I've entered / selected all my data but when I click the tick icon (top right) to call SubmitForm (i.e. send data to the database), it's not sending the key values. As you can see from the screenshot, it should be sending a Document_Type of "Order", a DocumentNo of 'SO000006' and a LineNo of 20000. Instead it's sending a Document_Type of "Quote", a DocumentNo of '' and a LineNo of 0. I guess these must be default values. The Default mode of the form is 'New' (i.e. insert a new row). What can cause this?

 

Here's the error: The requested operation is invalid. Server Response: Dynamics NAV: Request failed: The remote server returned an error: (400) Bad Request. (Document No. must have a value in Service Line: Document Type=Quote. Document No.=, Line No.=0., It cannot be zero or empty.)

PowerApps_Screenshot_271119.jpg
Categories:
I have the same question (0)
  • v-monli-msft Profile Picture
    Microsoft Employee on at

    Hi @NW-PA ,

     

    What is your data source?

    What is the OnSelect property of the submit button?

    What is the Item property of the Form control?

    Did you just add the default data cards to the Form or did you customize anything of this Form control? 

     

    Regards,

    Mona

  • NW-02041031-0 Profile Picture
    43 on at

    What is your data source? A Dynamics NAV connection to a table via a web service wrapped around a custom API Page in an AL Extension.
    What is the OnSelect property of the submit button? I've tried SubmitForm and Patch. I've already detailed the error I get with SubmitForm. With the Patch function I get Key fields are generated by the server and can't be specified.
    What is the Item property of the Form control? I've tried: BrowseGalleryServiceLines.Selected and empty with no success.
    Did you just add the default data cards to the Form or did you customize anything of this Form control? I added the default data cards to start with but I've had to add a few comboboxes.

  • vrathee Profile Picture
    2 on at

    I am facing same issue. Any solution for the same?

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 Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Vish WR Profile Picture

Vish WR 414

#2
Valantis Profile Picture

Valantis 387

#3
timl Profile Picture

timl 344 Super User 2026 Season 1

Last 30 days Overall leaderboard