cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
noamshn
Helper I
Helper I

months and month's weeks dependent drop down list

Hello everyone,

Im trying to make 2 dropdown lists, the first one is months and the second one is the month's weeks. when I will not choose a month the month's weeks dropdown list will give me all the weeks. but when I will choose a month the month's weeks dropdown list will give me only the correct weeks in the chosen month.

Im not sure how to make it, I will be glad for help.

Thank you in advance. 

5 REPLIES 5
AbdulWahab
Helper V
Helper V

Hi noamshn,

 

Is it a model-driven app? or a canvas app?

 

Thanks
Regards,

Abdul Wahab
Power Platform/Customer Engagement Developer/Lead/Solution Architecture/Project Manager
Direct/WhatsApp:+923323281237
E-mail: abdulwahabubit@outlook.com
Skype: abdul.wahabubit
Linkedin: https://www.linkedin.com/in/abdul-wahab-a5b8b011a/

model-driven app

AbdulWahab
Helper V
Helper V

Hi noamshn,

 

Follow the below steps:

 

  1. Create two tables one for a month and the other for a week
  2. Create one to many (1-*) relationship between them.
  3. Configure rcords in both tables
  4. Configure lookup control property on the form

     

    AbdulWahab_3-1661152847442.png

    Let me know if I can provide more details.

Thanks
Regards,

 

Abdul Wahab
Power Platform/Customer Engagement Developer/Lead/Solution Architecture/Project Manager
Direct/WhatsApp:+923323281237
E-mail: abdulwahabubit@outlook.com
Skype: abdul.wahabubit
Linkedin: https://www.linkedin.com/in/abdul-wahab-a5b8b011a/

the problem for this solution is that every year I will need to link between the correct weeks to the month because its not constant. do you know an automatic technique to do this every year?

AbdulWahab
Helper V
Helper V

Hi noamshn,

 

Use 'power automate', 'workflow' + 'workflow extension' or 'plugin' to automate it.

 

Let me know if I can provide more details for you.

 

Thanks
Regards,

 

Abdul Wahab
Power Platform/Customer Engagement Developer/Lead/Solution Architecture/Project Manager
Direct/WhatsApp:+923323281237
E-mail: abdulwahabubit@outlook.com
Skype: abdul.wahabubit
Linkedin: https://www.linkedin.com/in/abdul-wahab-a5b8b011a/

 

 

Thanks

Regards,

 

Abdul Wahab

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.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

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,955)