Answered

Lookup - return results from other list with two requirements

Like (0) Share

Report

Posted on 8 Jun 2021 19:44:09 by Community Power Pla...

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:

General Questions

All responses (5)

Answers (1)

rubin_boer 4,841 Super User 2024 Season 1 on 08 Jun 2021 at 20:22:21

Like (0)

Report

Re: Lookup - return results from other list with two requirements

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
Community Power Pla... on 08 Jun 2021 at 20:22:20

Like (1)

Report

Re: Lookup - return results from other list with two requirements

Actually, i think i got it. I removed the " " around Yes and it works now. Thanks for your help!
RandyHayes 76,287 Super User 2024 Season 1 on 08 Jun 2021 at 20:22:00

Like (0)

Report
Re: Lookup - return results from other list with two requirements

@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... on 08 Jun 2021 at 20:18:00

Like (0)

Report

Re: Lookup - return results from other list with two requirements

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
Verified answer

rubin_boer 4,841 Super User 2024 Season 1 on 08 Jun 2021 at 19:57:48

Like (0)

Report

Re: Lookup - return results from other list with two requirements

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

Hope it helps