Answered

Else_Value - Some help please

(0) Share

Report

Posted on by SDH_84

I've designed a basic ticketing system.

I've got a gallery I'm trying to apply a If filter to. I have a drop down filter with some users listed. I am trying to show if no users are selected, show all list items that have been created that are over 5 days old, excluding any with the status "Completed"

The a 2nd filter which returns specific users.

If(

//If user filter is set to "-"
DDUser_1.Selected.Result = "-",
Filter(QualityHelpdesk,Today()DateAdd(Created,5),Status.Value<>"Completed"),

//If user filter is set to <>"-"

DDUser_1.Selected.Result <> "-",
Filter(QualityHelpdesk,Today()DateAdd(Created,5),Status.Value<>"Completed"),
)

I'm getting the error

Any help / advice would be greatly received.

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

iAm_ManCat 18,256 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hey, you've got no comparison between your today and dateadd and your second filter has a comma at the end but no further condition below it

If( //If user filter is set to "-" DDUser_1.Selected.Result = "-", Filter( QualityHelpdesk, Created < DateAdd(Today(),-5), Status.Value<>"Completed" ), //If user filter is set to anything other than "-" DDUser_1.Selected.Result <> "-", Filter( QualityHelpdesk, Created < DateAdd(Today(),-5), Status.Value<>"Completed", //Filter by user UserNameColumn=DDUser_1.Selected.Result ) )

I added pseudocode for the user filter, you'll need to adjust that for your particular column name
SDH_84 44 on at

Like
a
(1)

Report
Copy link

Link copied!

@iAm_ManCat Thanks so much. I was staring at that for far to long!

I did have to add one extra bit to the formula:

//Filter By User
'Assigned To'.DisplayName = DDUser_1.Selected.Result)
)

But now it's all working as I expected.
iAm_ManCat 18,256 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Awesome, glad I could help - sometimes its good to have a second pair of eyes look things over 🙂