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 / 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,735 Super User 2026 Season 1 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

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!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 531 Most Valuable Professional

#2
Haque Profile Picture

Haque 261

#3
Kalathiya Profile Picture

Kalathiya 221 Super User 2026 Season 1

Last 30 days Overall leaderboard