cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
aymanhassanmct
Frequent Visitor

Dynamic check box items based on selections from drop down or combo box

Hello All,

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:

actual submission date 2.jpg

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:

actual submission date 3.jpg

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?

Thanks,

Ayman

 

 

 

10 REPLIES 10

@v-bofeng-msft

Any update please?

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,420)