To Filter employee status month wise in powerapps using sharepoint

[Syndicate_Admin]

Selecting a Month from Dropdown and on click of a button it should filter from different list in sharepoint which contains date field as mm/dd/yyyy

[v-jingzhang]

Hi @Syndicate_Admin 

Power Query is used to connect to and transform data. It doesn't have dropdowns or buttons. I guess you are probably building a Power App, so you can post the question at this correct forum (Building Power Apps - Get Help with Power Apps ) to seek more possible guidance and solutions. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.