Answered

Lookup - return results from other list with two requirements

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi!

I'm stuck on this one, I've searched everywhere and I know I'm close but I cant quite seem to find the correct formula to get this to work. I created a SharePoint lookup column that is linked to another list, in PowerApps I am able to return the results of the needed column but I need to get even more granular with my results.

For Example, on the list that I am connecting to, there is a Application column and a updated column. I need to return the results for everything in the Updated column that equals "Yes".

In the DataCardValue card I have set the Items field to SortByColumns('Dataset Name'.Application, "Title"). How can i add the Updated column data and exclude everything that is not set to "Yes"? Any help would be greatly appreciated

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

Verified answer

rubin_boer 4,843 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

hi @Anonymous try SortByColumns(Filter(Dataset,Updated="Yes").Application,"Title",Ascending)

Hope it helps
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I've tried that but doesn't seem to work. The formula doesn't return any errors but no data is being pulled in to the dropdown. Wonder what's missing
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous

The formula you are trying is returning a single column table with the column named "Application". Then you are trying to sort on the Title column....it does not exist! Only the Application column.

Change your formula to the following:

SortByColumns(Filter(Dataset, Updated="Yes"), "Title").Application

I hope this is helpful for you.
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Actually, i think i got it. I removed the " " around Yes and it works now. Thanks for your help!
rubin_boer 4,843 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

hi @Anonymous text search is case sensitive so Yes does not equal yes.

here the combobox items = SortByColumns(Filter(colSomething,state="yes").name,"name",Ascending). the left gallery display's collection colSomething wher eyou can see state and name