Hi there,
Still in the process of building out my app.
I'm trying to PATCH a new record to SQL but I cant get the right formula when dropdowns are involved.
I have tried .Selected.Text, .Selected.Value, .Selected.Result, .Selected and keep getting errors.
The only time the code doesn't throw an error is when I use these values highlighted.
Which come from this code below where I am adding a blank to the dropdowns. But nothing happens when I run the Patch code since that's a reference to the blank and not the actual selected value. But .Selected.DataTypes isnt an option...
Example Selected.Value not working -
What am I missing here? Please help. Let me know if you need more info.
Note - the SQL table PK is an identity column that auto generates.
Follow up question -
If I can get this working to create new records, I want to then create a variable that once saved to SQL, the identity SQL number "Inventory ID" is returned. Can this be worked into the same code as above?
Code for editing:
Patch(EXPL_inventorytest,
Defaults(EXPL_inventorytest),
{
MediaBarcode: tMB.Text,
DataType: ddDataType.Selected,
Country: ddCountry.Selected,
MediaType: ddMediaType.Selected,
MediaNumber: tMediaNumber.Text,
Location: ddLocation.Selected,
DigitalFormat: ddDigitalFormat.Selected,
DataDescription: tDataDescription.Text,
RecordCreatedBy: tRecordCreatedBy.Text,
RecordCreatedDate: dpRecordCreatedDate.SelectedDate
}
)
