cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Need Help When using Filter + Lookup

Hi PowerApps Community,

can you help me solve the attached issue around combining Filter with Lookup directly in Power Apps?

I have been crunching my brain for a few days now on what appears to be a potential "bug" but I am not sure... I guess the reason  is very simple if you know what you are doing (it seems like I don't 🙂

I attached a few screenshots and explanations (see Attachment .pdf). 

Hoping to learn from your experience,

Thanks a million!

Oliver

3 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Need Help When using Filter + Lookup

Hi @Oliclusive,

 

Please try this:

 

Filter(AddColumns('Downtime Slave Data',"NewColumn",LookUp('Machine Groups Data','SlaveID(Groups)'.Value=Text( 'SlaveID(States)'  )).'MachineName(Werma)'),"#"in NewColumn)

 

or

 

Filter(AddColumns('Downtime Slave Data',"NewColumn",LookUp('Machine Groups Data','SlaveID(Groups)'.Id= 'Downtime Slave Data'[@ID]  ).'MachineName(Werma)'),"#"in NewColumn)

 

Hope this helps.

Sik

 

View solution in original post

Highlighted
Helper I
Helper I

Re: Need Help When using Filter + Lookup

Hi @v-siky-msft ,

thank you for your quick reply!

 

No luck on both statements yet:

  • the first one brings me the same "empty list" as before (seems like it still can't find a match for "#"?)
  • on the second one, I get the error "invalid argument type"

See both screenshots attached.

 

A few additional questions form my end as your approach sparked a few ideas for my own "trial & error" approach:)

  • What was your thinking behind the additional "AddColumns-statement?
  • Why did you change the 'SlaveID(Groups)'='SlaveID(States)' to this one:
'SlaveID(Groups)'.Value=Text( 'SlaveID(States)'​

 

Thanks a lot already,

Cheers,

Oli

View solution in original post

Highlighted
Helper I
Helper I

Re: Need Help When using Filter + Lookup

Hi @v-siky-msft ,

 

on second noctice: your proposal inspired me to try this variant:

 
Filter(AddColumns('Downtime Slave Data';"NewColumn";LookUp('Machine Groups Data';'SlaveID(Groups)'='SlaveID(States)';'MachineName(Werma)'));Search_Open_1.Text in NewColumn)
 
.... and *tadaa* now it works !!
Fantastic - I owe you big time🙏!
Wonderful, what a great day  😎
 
Cheers, 
Oli

View solution in original post

3 REPLIES 3
Highlighted
Community Support
Community Support

Re: Need Help When using Filter + Lookup

Hi @Oliclusive,

 

Please try this:

 

Filter(AddColumns('Downtime Slave Data',"NewColumn",LookUp('Machine Groups Data','SlaveID(Groups)'.Value=Text( 'SlaveID(States)'  )).'MachineName(Werma)'),"#"in NewColumn)

 

or

 

Filter(AddColumns('Downtime Slave Data',"NewColumn",LookUp('Machine Groups Data','SlaveID(Groups)'.Id= 'Downtime Slave Data'[@ID]  ).'MachineName(Werma)'),"#"in NewColumn)

 

Hope this helps.

Sik

 

View solution in original post

Highlighted
Helper I
Helper I

Re: Need Help When using Filter + Lookup

Hi @v-siky-msft ,

thank you for your quick reply!

 

No luck on both statements yet:

  • the first one brings me the same "empty list" as before (seems like it still can't find a match for "#"?)
  • on the second one, I get the error "invalid argument type"

See both screenshots attached.

 

A few additional questions form my end as your approach sparked a few ideas for my own "trial & error" approach:)

  • What was your thinking behind the additional "AddColumns-statement?
  • Why did you change the 'SlaveID(Groups)'='SlaveID(States)' to this one:
'SlaveID(Groups)'.Value=Text( 'SlaveID(States)'​

 

Thanks a lot already,

Cheers,

Oli

View solution in original post

Highlighted
Helper I
Helper I

Re: Need Help When using Filter + Lookup

Hi @v-siky-msft ,

 

on second noctice: your proposal inspired me to try this variant:

 
Filter(AddColumns('Downtime Slave Data';"NewColumn";LookUp('Machine Groups Data';'SlaveID(Groups)'='SlaveID(States)';'MachineName(Werma)'));Search_Open_1.Text in NewColumn)
 
.... and *tadaa* now it works !!
Fantastic - I owe you big time🙏!
Wonderful, what a great day  😎
 
Cheers, 
Oli

View solution in original post

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

Top Solution Authors
Top Kudoed Authors
Users online (6,261)