Answered

CountIf Logical with Sharepoint

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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

All responses (2)

Answers (1)

Sort by

WarrenBelz 156,536 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
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.
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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!