Unanswered

How to use Not IN filter on Data verse table power apps?

(0) Share

Report

Posted on by rbn_nue

Hi Folks,

I'm trying to use a dataverse table as the data source for a canvas app combo box control. I'm using some text based filters using "IN" operator which is working fine. I also want to filter out/remove some rows based on whether the Item is present in another table. I tried using Not( in ) option but it has delegation warnings. Below is the complete code in items property in Combo box:

If(!IsBlank(cmb_TrainingName.Selected.Name),

Filter(Employees, IsWorkerActive && !IsBlocked, ProjectCode in ShowColumns(Filter(Trainings, Name = cmb_TrainingName.Selected.Name),"pub_projectcode"), !(Employee_ID in ShowColumns(Filter('Training Details',TrainingID = cmb_TrainingName.Selected.ID),"pub_employeeid"))

)
)

Could any one please suggest a workaround to achieve this without delegation issue.

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

AndrewR1 1,572 Moderator on at

Like (0)

Report
Re: How to use Not IN filter on Data verse table power apps?

Hi @rbn_nue can you try replacing the Not with something like this:

RemoveIf(!(Employee_ID in ShowColumns(Filter('Training Details',TrainingID = cmb_TrainingName.Selected.ID),"pub_employeeid")))

Remove If will remove the options out of a combo box and the ! is the not operator in PowerApps.

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.
If you like my response, please give it a Thumbs Up.

Many Thanks
Andrew

Was this reply helpful? Yes No
rbn_nue on at

Like (0)

Report

Re: How to use Not IN filter on Data verse table power apps?

Hi @AndrewR1

This gives invalid number of arguments error for RemoveIf. Also, I had already tried with "!", it returns delegation warning as I mentioned in original post ( I have updated the post).

Thanks

Was this reply helpful? Yes No
v-jefferni on at

Like (1)

Report
Re: How to use Not IN filter on Data verse table power apps?

Hi @rbn_nue ,

You can narrow down the Filters step by step. Based on your codes, I changed them into:

If( !IsBlank(cmb_TrainingName.Selected.Name), With({wFilter1:Filter(Employees, IsWorkerActive && !IsBlocked)}, With({wFilter2:Filter(wFilter1,ProjectCode in Filter(Trainings, Name = cmb_TrainingName.Selected.Name).pub_projectcode))}, Filter(wFilter2,!(Employee_ID in Filter('Training Details',TrainingID = cmb_TrainingName.Selected.ID).pub_employeeid))) ) ) )

Best regards,

Was this reply helpful? Yes No
rbn_nue on at

Like (0)

Report

Re: How to use Not IN filter on Data verse table power apps?

Hi @v-jefferni

Thanks for the response. When I'm using this code delegation warning is not showing up. But could you confirm if that's the case, from my test it does not support delegation. I had put delegation limit as 2, then tried searching for values which are not showing up in the drop down of combo box, but it did no give any results.

Thanks

Was this reply helpful? Yes No
Verified answer

v-jefferni on at

Like (1)

Report

Re: How to use Not IN filter on Data verse table power apps?

Hi @rbn_nue ,

As I said, the formula narrows down filtering results step by step. Assuming data row limit is 500, we need to filter the table using delegable function/condition and get the result table where includes less than 500. If this is not possible, you'll need to create a collection to include the results and then filter this collection.

Best regards,

Was this reply helpful? Yes No