Here are the basics and the balance is between app overhead and usability. This app collects the company holidays for the upcoming year. For 2021 we have 761 due to country, regional and local differences and as we add and lose employees or holidays that number changes. The person submitting the holidays might be submitting for up to 20 countries at a time.
The usability part is allowing them to select multiple regions for a single holiday in a country rather than creating an individual holiday for each region. These are saved into a collection (I know) but there is a good reason. If holidays for a country already exist in the Holiday table for a previous year, as soon as the country is selected, they are uploaded and the submitter can edit them rather than entering new ones, but they can also add new ones to the collection. When they are done the collection is patched to the Data Source.
The app also does some behind the scenes actions that require each holiday to be in a collection as a single item for each country or country/region pair, thus the 'duplicates'.
There may be some ways I can clean it up and make it better once I have it working. I had already planned on asking you to look at some of the parts once I have it working the hard way to see how it can be optimized.
Here is another question:
When the holidays are saved into the main holiday collection the regions are added as a text value using concat. For edit purposes the DefaultSelectedItems is set to this:
If(
!NewItem && EditItem, Filter(RegionsColl, Region in varRecord.Region),
CheckboxAllRegions.Checked, RegionsColl
)
Which gives me this:
Looking at this it would appear that it's not blank or empty. However, If I modify a property, date must be modified, and then save including my new formula statement, it works BUT doesn't recognize that the combobox has any items in it.
If(!IsEmpty(ComboBoxRegion), Collect(TempHolidays, ForAll(ComboBoxRegion.SelectedItems As _item, {Region: _item.Region , Date:Text(DatePickerHolidayDate.Value), Country: DropdownCountry.Selected.Name, HolidayName: LabelHolidayNameCombined.Text}),
IsEmpty(ComboBoxRegion), Collect(TempHolidays, {Date:Text(DatePickerHolidayDate.Value), Country: DropdownCountry.Selected.Name, HolidayName: LabelHolidayNameCombined.Text}
)
)
);
