cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
XDUKERMANX
Frequent Visitor

Incompatible types for comparison

Hi,

 

This is my first post so please be gentle with me. I'm building my first ever app and I think I've done quite well so far but still feel like I have no idea what I'm doing.

 

I'm trying to create an app to log service desk tickets and be able to view them in PowerApps. I also want to include a manager dashboard so KPI's can be viewed in real time.

 

I've managed to create a "LogACall" page with a user lookup and all info on that page gets patched in to a SarePoint list.

 

I'm now trying to create the dashboard where I need to filter out different rows from the list based on specific values in specific columns. I want to be able to count only "Incidents" out of the CallType column but only from this month, I don't want to see them all.

 

CountIf('Service Desk Tickets Demo CP'.DateTimeLogged = Value(Now(),"mmmm/yy") && CallType = "Incidents")

 

I know this formula is wrong in many ways but can't seem to find the correct info on how to correct it as it's quite specific.

 

 

Thanks

 

Thanks

Chris

1 ACCEPTED SOLUTION

Accepted Solutions
WarrenBelz
Super User
Super User

Hi @XDUKERMANX ,

Try this - the top statement is to filter the newest records and also to avoid a Delegation warning

With(
   {
      wTickets: 
      Sort(
         'Service Desk Tickets Demo CP',
         ID,
         Descending
      )
   },
   CountIf(
      wTickets,
      Text(
         DateTimeLogged,
         "mmyy"
      ) = 
      Text(
         Now(),
         "mmyy"
      )  &&
      CallType = "Incidents"
   )
)

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

View solution in original post

3 REPLIES 3
WarrenBelz
Super User
Super User

Hi @XDUKERMANX ,

Try this - the top statement is to filter the newest records and also to avoid a Delegation warning

With(
   {
      wTickets: 
      Sort(
         'Service Desk Tickets Demo CP',
         ID,
         Descending
      )
   },
   CountIf(
      wTickets,
      Text(
         DateTimeLogged,
         "mmyy"
      ) = 
      Text(
         Now(),
         "mmyy"
      )  &&
      CallType = "Incidents"
   )
)

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

OMG copied it in and worked like a charm straight away. Thank you very much! 

 

I'm trying to teach myself using this website which has been an amazing resource.

 

Looking at the formula though I'm unclear on what the  "wTickets:" and "ID" is referring to. If you could explain for me to better understand that would be great. If not then you've helped me out massively anyway.

 

Thanks again! 

Hi @XDUKERMANX ,

Firstly, I have a blog site at PracticalPowerApps - you might want to read the first 7 articles.

To your questions - wTickets (you can call it whatever you want) is a temporary Table capturing the newest records (500-2,000 depending on your Delegation Settings) - the sort by ID Descending turns the List "backwards" to do this (the ID in SharePoint is a unique sequential numerical generated when the List item is created) .

The CountIf() statement is not Delegable (so you will have some blue lines under your code if you do it directly on the List), so you make the Table first, then do the CountIf() on the Table, which is now a "local" item and therefore not subject to Delegation restrictions. Please read my blog on Delegation first, then read this again.

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

 

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,228)