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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / item is not being crea...
Power Apps
Answered

item is not being created in SQL table from mobile phone

(1) ShareShare
ReportReport
Posted on by 7,390 Super User 2024 Season 1

Hey guys! I am building an app and the app is working very weel on browser.
When I do it in the cellphone, it says that Item_ID is mandatory.

In my database I have that as an AutoNumber and when I create in the browser it has no problem but when I create in my mobile phone it says that the ID is mandatory and does not work

 

Please help me

Categories:
I have the same question (0)
  • Drrickryp Profile Picture
    Super User 2024 Season 1 on at

    @Nogueira1306 

    If you have the option, remove the required property from the auto number field.

  • Nogueira1306 Profile Picture
    7,390 Super User 2024 Season 1 on at

    But the field is the ID and that ID is the primary key

    I need an ID and i set it as an auto number

  • Drrickryp Profile Picture
    Super User 2024 Season 1 on at

    @Nogueira1306 

    Autonumbers are created automatically by Powerapps and don't need to be set to required. If you set the required property, PowerApps will expect user input before submitting your data.

    SQL tables generate their own ID, why not use that?

  • Nogueira1306 Profile Picture
    7,390 Super User 2024 Season 1 on at

    The only thing I have is:

     

    ID PRIMARY KEY AUTONUMBER

     

    So, I need to remove AUTONUMBER?

     

  • timl Profile Picture
    36,634 Super User 2025 Season 2 on at

    Hi @Nogueira1306 

    It's very strange that your app works in a browser but not your cell phone.

    A few things I would try first would be to make sure that the Power Apps player on your phone is up to date. If it's an Android device, I'd clear the cache in the app settings.  I'd then republish the app to ensure that the mobile device is picking up the latest version.

    If you follow these steps, do you still see the same error?

  • Nogueira1306 Profile Picture
    7,390 Super User 2024 Season 1 on at

    I stil see the error.

    What I have in my SQL is this:

    ID PRIMARY KEY AUTONUMBER(1;1)

  • Verified answer
    Nogueira1306 Profile Picture
    7,390 Super User 2024 Season 1 on at

    The solution was to remove the IDENTITY(1,1) and set the ID to this:

     

    ID: First(Sort(Table; ID; Descending)).ID + 1;

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
Kalathiya Profile Picture

Kalathiya 402

#2
WarrenBelz Profile Picture

WarrenBelz 380 Most Valuable Professional

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 293 Super User 2025 Season 2

Last 30 days Overall leaderboard