Solved: Incompatible types for comparison

XDUKERMANX · ‎07-10-2021

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

Chris

WarrenBelz · ‎07-10-2021

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

WarrenBelz · ‎07-10-2021

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.

XDUKERMANX · ‎07-10-2021

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!

WarrenBelz · ‎07-10-2021

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.