Help Desk Canvas App show not completed tickets

(0) Share

Report

Posted on by Smatera9681

I am using the Help Desk App, currently I have the following screen

My Ticket Screen.jpg

I have the following logic that shows the tickets above under the My Ticket Screen

Refresh(HelpDesk);
ClearCollect(AllTickets,HelpDesk);
If(isAdmin ,
Set(TicketToRunFlow,First(Sort(AllTickets,Created,Descending))),
Set(TicketToRunFlow,First(Sort(Filter(AllTickets,Author.Email = MyProfile.Mail || Author.Claims = MyProfile.UserPrincipalName ),Created,Descending)))
);
If(RunFlow, HelpDeskFlow.Run("'" & TicketToRunFlow.ID & "'"));
If(RunFlow, Set(RunFlow,false))

I also have this logic under the My Ticket Screen Gallery Icon Screen

If(
isAdmin,
Sort(
AllTickets,
Created,
Descending
),
Sort(
Filter(
AllTickets,
Author.Email = MyProfile.Mail || Author.Claims = MyProfile.UserPrincipalName
),
Created,
Descending
)
)

I am looking to show only the items when my TaskStatus shows everything but the Completed Items

Anyone have any ideas on how to do that

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

v-siky-msft on at

Like (0)

Report
Hi @Smatera9681 ，

Do you want your TicketScreenGallery display all items except completed Items?
You can add a filter condition to AllTickets.
Please modify your second formula as below, and put it to Items property of gallery.
If(isAdmin,Sort(Filter(AllTickets,TaskStatus in ["NOT STARTED","IN PROGRESS","DEFERRED","WAITING ON CSR"]), Created, Descending), Sort( Filter(AllTickets, (Author.Email = MyProfile.Mail || Author.Claims = MyProfile.UserPrincipalName) && TaskStatus in ["NOT STARTED","IN PROGRESS","DEFERRED","WAITING ON CSR"]), Created, Descending))
Best Regards,
Sik
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly.

Was this reply helpful? Yes No
Smatera9681 22 on at

Like (0)

Report

Unfortunately I added the information you had me add and this is what happens

As you can see the syntax has some red in it, and nothing populates in my ticket like yours does in your above picture

Any ideas on what i am missing?

Was this reply helpful? Yes No
Smatera9681 22 on at

Like (0)

Report

Does anybody have any insight on this? Any help would be greatly appreciated

Was this reply helpful? Yes No