CODEWITHSUNDEEP
formulapowerapps
OlaOkland
OlaOkland

Reputation: 95

Onselect formula

I am using the Service Desk template in Microsoft PowerApps.

However, I would like to modify the Dashboard with a date picker (called “DatePicker2”)

For “All tickets” there is this Onselect formula; If(ThisItem.TicketTypes="All tickets";UpdateContext({type:"All"});

I would like to show all tickets, but based on the value in DatePicker2 (correlates to the CreatedDate in the “Tickets”- table.

Any ideas on how to modify the Onselect formula?

Best regards Ola

Upvotes: 2

Views: 376

Answers (1)

LauraV
LauraV

Reputation: 61

I modified the OnSelect formula as following and worked:

If(ThisItem.TicketTypes="All tickets",UpdateContext({datetype:Text(DatePicker2.SelectedDate),type:"All"});

You will also need to update the formula for the Items in TicketsGallery to:

If(type="All",Filter(Tickets,datetype in DateCreated)

Upvotes: 2

Related Questions