Answered

CountIf Logical with Sharepoint

(0) Share

Report

Posted on by Community Power Pla...

Hi all,

I'm trying to create a textbox that says how many tasks are due/overdue. The data is stored in sharepoint, with the due date as a date and the completion status as a choice list. Right now it works if I only use the date to determine the number of tasks. However I need to only include assigned tasks so I need to add a second conditional to the formula. Right now I have it set up like so:

CountIf('Task Management',Value(Text(Due_Date, "[$-en-US]yyyymmdd")) < Value(Text(Today(), "[$-en-US]yyyymmdd")) && Status = First(Choices('Task Management'.Status)))

It stops working once I add the "&&" and everything past it. Does anyone have any advice?

Thanks,

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

WarrenBelz 153,127 Most Valuable Professional on at

Like (0)

Report
Hi @Anonymous ,
Your problem is here
Status = First(Choices('Task Management'.Status)))
Are you actually after the value chosen in the control?
CountIf( 'Task Management', DateDiff( Due_Date, Today(), Days )>0 && Status = YourDropdownName.Selected.Status )

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.

Was this reply helpful? Yes No
Verified answer

Community Power Pla... on at

Like (0)

Report

The dropdown menu with the choices is a field in the sharepoint, not a dropdown menu in the actual powerapp. But I was able to fiddle with it and get it to work.

Thanks!

Was this reply helpful? Yes No