Dropdown filter

[Ramole]

Hi 

i would like to filter my data based on monthly dropdown whats formula to use please and here is my currant formula and how can i added dropdown 

Sort(
Filter(
Shipments,
StartsWith(
Company.Value,
SearchBar.Text
)
),
OrderDate,
Descending
)

[eka24]

Please give further explanation on the dropdown. What table are you using.

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[chsanche]

Hi @Ramole 

As you already have a filter formula there, please check on the following URL where it is indicated how to use the filter with multiple conditions: https://powerusers.microsoft.com/t5/Building-Power-Apps/Filter-multiple-condition/td-p/142832

You will be able to add the second condition that you need.

Best Regards,

--

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions help users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[Ramole]

Hi @eka24 

I have a field of orderdate so i would like to populate those dates on the dropdown example if i select the dropdown orderdate 4/24/2020 to filter only those dates 

Thanks  

[eka24]

Try:

Sort(Filter(Shipments,Search(Company,SearchBar.Text),Dropdown1.Selected.Value),OrderDate,Descending)

OR

Sort(Filter(Shipments,Search(Company.Value,SearchBar.Text),Dropdown1.Selected.Value),OrderDate,Descending)

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[Ramole]

Hi @eka24 

Whats code or formula should i have to use on the dropdown please 

Thanks 

[eka24]

Your table that contains the orderdates. Example If it is in the Shipment table put:
   Shipment in the items of the Dropdwon

After that if it does not work, give a screen shot

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[Ramole]

Hi @eka24 

Please advice me whats best way to do it if i need to search textbox and dropdown, the dropdown i would like to show me the dates of orders like Jan 2020 or Feb 2020 like that and here is my code please 

Sort(
Filter(
Shipments,
StartsWith(
Company.Value,
SearchBar.Text
)
),
OrderDate,
Descending
)

Thanks

[eka24]

Can you display your structure of your Table to enable me look at it.

[Ramole]

Hi @eka24 

CompanyName        Lookup Item

CollectonDelivery      Yes/No Item

Note                        Single line of text Item
Order date              Date and Time Item

Order Status           Choice Item

Shipping Method  Choice Item

Shipping Route    Choice Item

TrackingNumber  Single line of text

TotalPieces          Number
Weight                Single line of text
Length                Single line of text
DeclaredValue    Currency
CODAmount      Currency
CODType            Choice
FreightCharges  Currency
Width                Single line of text
Height              Single line of text