I have a Risks and Issues screen with an editable gallery that feeds a Risks and Issues dataverse table. The save button associated with each item in the gallery successfully patches all columns in the dataverse table, but the combo box fields (tied to choice columns in dataverse) go blank in the gallery after save. The text field datacard values still show up. Everything else seems to be working fine. Same thing happens with the Add button outside the gallery.
A few notes on my app:
- I used the Project column in the IT Portfolio gallery as a lookup to a Project column in this (Risks and Issues) table. I dont think I'm using the lookup correctly.
- I have an autonumber ID field in the Projects table that I relate to a manual LookupID field in the Risks and Issues table to filter the rows to those where the Lookup ID matches the Project autonumber.
- I dont have anything defined for the SelectedItems or Default controls for these combo boxes, not sure what they should be.
- Title is the primary name column.
- Syntax for the Save button and the Add New button are below, with screenshots before/after clicking Save:
Save button 'On Select' syntax
Patch
('Risks and Issues',ThisItem,
{crfc5_project:ProjectDataCard_1,
crfc5_lookupID: LookupDataCard_1,
'Risk or Issue':TypeDataCard_1,
crfc5_name: TitleDataCard_1.Text,
crfc5_description: DescriptionDataCard_1.Text,
'Risk or Issue Status': StatusDataCard_1.Selected.Value,
crfc5_duedate: DueDatePicker_1.SelectedDate})
Add button 'On Select' syntax
Patch
('Risks and Issues',
Defaults(
'Risks and Issues'),
{LookupID:'Gallery - Project List'.Selected.PortfolioAutonumber,crfc5_Project:'Gallery - Project List'.Selected,
Title:""})
Before Save
After Save
If there's a better way to do this, let me know! I a few similar screens with text and combo boxes in a gallery, all tied to individual dataverse tables.
Thank you so much.
