cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Smatera9681
Level: Powered On

Help Desk Canvas App show not completed tickets

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

 

 

3 REPLIES 3
v-siky-msft
Level 10

Re: Help Desk Canvas App show not completed tickets

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))

Annotation 2019-10-24 181521.png

Best Regards,

Sik

If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly.

 

Smatera9681
Level: Powered On

Re: Help Desk Canvas App show not completed tickets

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

 

Untitled.jpg

 

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?

Smatera9681
Level: Powered On

Re: Help Desk Canvas App show not completed tickets

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

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (5,557)