cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mukeshserene
New Member

Power-apps drop-down custom Data Card, validation Issues while create/Update

I have a power App data form bound to a SQL server table. Have foreign keys and those foreign keys should be drop-downs so converted them to [Allowed Values] lists.

 

But I am not able to create new records in there as getting [An entry is required or has an invalid value. Please correct and try again.] validation messages.

 

Following are the settings:


powerapps-ExternalDataCard.pngpowerapps-InternalDataCard.pngpowerapps-Validation.png

 

 

3 REPLIES 3
v-monli-msft
Community Support
Community Support

Hi @mukeshserene,

 

I think this reason here should be PowerApps is using the Primary Key to identify the row in SQL Table, so changing the Primary key value within PowerApps may not work, as PowerApps can't identify the proper row.

 

For a workaround, please consider to have the Primary key set to auto_increment, which is handled by the data source side, so that it can't be changed (but readable) under PowerApps.

 

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hey Mona, Thanks for the reply,

We already have a Primary Key which is auto incremented from database side in the main table.

 

Though the issue is with the foreign keys/drop-downs and getting the validations issues while trying to save the information back to the DB (Dropdowns bound with another table/s from DB, Text is visible in drop-down/s though there is something wrong with the value/pk to FK binding).

Hi,

Have you solved your issue ? as i'm getting the same error.
Same table setup. same scenario

Helpful resources

Announcements
October Events

Mark Your Calendars

So many events that are happening this month - don't miss out!

Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Top Solution Authors
Top Kudoed Authors
Users online (2,046)