Dynamic check box items based on selections from drop down or combo box
Using PowerApps, I need to create the following entry (Update) form) and also create the ideal Excel table on OneDrive to store data entered to this form.
The form should look like this:
Each product has its corresponding countries from total 20 options, and the data that needs to be manually updated is a date for each country. So when a product item selected, the list of countries change to fit the selected product. A user needs to first select a product, then check some or all countries, and enter dates in front of selected countries, and submit this to an Excel table (To be created). Then the process repeats with the same product and Lift ID as the dates are not always available for all countries at once, or with different product or Lift ID.
The products and selected countries currently looks like this:
Where 1 means this is supported country for that specific SKU or Product. The list of checkboxes in the PowerApps form should dynamically change to the selected countries that have the value of 1 for the selected Product.
Is this possible with PowerApps? How to create the form and the table that stores the data submitted by it?