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
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (5,646)