@Jukie
Ok, this is a test end product, but you'll need to adjust the 'Save' to be your Patch function.
Controls:
1. ComboBox, your current original one. I've named mine cbGroups
2. Lefthand gallery, I've called mine galGroup but you can call it whatever suits you. Set the Layout to Title only.
2.1 Items property of LH gallery
cbGroups.SelectedItems
2.2. For the Title label select the field that will display your Group name, eg
ThisItem.Value
// or ThisItem.GroupName
// use Intellisense to help you select the correct field
2.3 With the gallery selected, Add a Dropdown with the following features. Name this dropdown ddStatus
// Items property
["In Review","Approved","Partially Approved","Declined"]
// AllowEmptySelection property
true
// Default property
""
3. Add a button with this code
ClearCollect(
colData,
{
'Participating Group Status':
Concat(
ForAll(galGroup.AllItems,
{
combinedGrps: lbGroup.Text & " - " & ddStatus.Selected.Value
}
),
combinedGrps, Char(10) // Char(10) adds a linebreak in your text
)
}
)
Note: the above code will need to be adjusted to match/meet your Patch needs, eg
Patch(
yourDataSource,
Defaults(yourDataSource),
{
'Participating Group Status':
Concat(
ForAll(galGroup.AllItems,
{
combinedGrps: lbGroup.Text & " - " & ddStatus.Selected.Value
}
),
combinedGrps, Char(10) // Char(10) adds a linebreak in your text
)
}
)
The above creates a NEW record, but if you need to update an existing record, it'll need to change.
Using the above collection we created, add a new gallery. This is just to display the value created by the button. Set the Items of this new gallery to colData and adjust the label reference to display the text you are going to eventually Patch.
Let me know if this helps, or you need a little more assistance.
