months and month's weeks dependent drop down list

[noamshn]

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. 

[AbdulWahab]

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/

[noamshn]

model-driven app

[AbdulWahab]

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

   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/

[noamshn]

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]

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