Answered

Filter not working

(0) Share

Report

Posted on by arkroyal

Hi,

I have an App built from a SP list. I am trying to filter on open actions and where the user is included in the responsible column field.

I have set the OnStart condition to:

ClearCollect(collection, 'Delivery Tasks Tracker');
Set(varUser, Office365Users.MyProfile().DisplayName)

I have Set the Items condition to:

SortByColumns(Filter([@'Delivery Tasks Tracker'], Progress.Value = "Not Started"||Progress.Value <> "In Progress" && Responsible.DisplayName = varUser),"Title",If(SortDescending1, Descending, Ascending))

The progress filter worked fine until I added the extra filter on the responsible person which also doesn't seem to do anything.

Am I missing something obvious?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Jagadeeshk 457 on at

Like (0)

Report
Copy link

Link copied!

There are cases where sharepoint and powerapp shows different display names. Please ensure the same. Or try
Try
1. Set(varuser, user().email)
Filter( responsible.email=varuser)

Was this reply helpful? Yes No
Verified answer

arkroyal 27 on at

Like (0)

Report
Copy link

Link copied!

Managed to sort it I think. Added an And to the filter and it seems to work. Thanks for the suggested solution.

SortByColumns(Filter([@'Delivery Tasks Tracker'],And(Responsible.DisplayName = varUser||'Responsible 2'.DisplayName = varUser||'Responsible 3'.DisplayName = varUser||'Responsible 4'.DisplayName = varUser,Progress.Value = "Not started"||Progress.Value = "In progress")),"Title",If(SortDescending1, Descending, Ascending))

Was this reply helpful? Yes No