Unanswered

Filtering ComboBox Items With qualities from 2 lists - no error, returns blank

(1) Share

Report

Posted on by CU12092006-0

I have 2 Sharepoint Lists. List A contains my primary data, where column x has repeat values. List B contains the same values as column x in the Title column, but only once. My Combobox "Items" formula is:

Distinct(Filter('List A', Status.Value="Approved", 'Item Title'=Item_Selected, LookUp(List B',Title='Columnx', 'Archived?'.Value)="No"),Title)

This is not giving me any errors, but returns blank. If I run, Distinct(Filter('List A', Status.Value="Approved", 'Item Title'=Item_Selected), Title) it works fine. I know it would be better to have a linked column between the two but these aren't my list, so I am somewhat limited in the changes I can make.

Thoughts on how to repair this?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Rajkumar_404 on at

Like (1)

Report
Hi @ayattaw

Try this formula,

Distinct(
Filter(
'List A',
Status.Value = "Approved" &&
'Item Title' = Item_Selected &&
LookUp('List B', Title = Columnx, 'Archived?'.Value) = "No"
),
Columnx
)

Thanks!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.

Was this reply helpful? Yes No
CU12092006-0 71 on at

Like (1)

Report

No dice.

Was this reply helpful? Yes No
CU12092006-0 71 on at

Like (1)

Report

Oh, I lied, sorry! I think that worked. I'll double check and if so I'll mark your comment as solution. Thank you!!! Can you help me understand my syntax error please?

Was this reply helpful? Yes No