Unanswered

Pass a Param into LookUp function

(0) Share

Report

Posted on by GermanAutomator

Hello everyone,

is it possible to pass a parameter into a lookup-function? I am trying to get PowerApps to show a different screen based on what group a person is part of, like HR or IT. This parameter is dynamically assigned to the app's URL and given in a SharePoint list.

So I am trying to get this fixed solution:

changed into something like this:

But the argument is invalid. Is there a known workaround?

Thanks very much!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

madlad 2,637 Moderator on at

Like (1)

Report
Copy link

Link copied!
You should be able to do something like this. Is Param("group") just the name of the datasource you want here? i.e. for IT would it just be "OE-IT"?

If this is the case,
I'm pretty sure you cannot dynamically pass the datasource for a lookup in like this. However, one thing you could try is something along the lines of:

Set( IsUserMember; !IsBlank( Switch( Param("group"); "OE-IT"; LookUp( 'OE-IT'; Name.Email = User().Email ); "OE-HR"; LookUp( 'OE-HR'; Name.Email = User().Email ); ect. ) ) )

This should do what you need, although I'm not 100% sure it's the most efficient way to do this. You'll have to pass in the correct values for your departments of course.

Hope this helps!

Was this reply helpful? Yes No
GermanAutomator 12 on at

Like (0)

Report
Copy link

Link copied!

That looks interesting, I'll definitely try that out. For me, it's not about efficiency, just functionality on this one.

Yes, the name of my SharePoint list where the names are stored is the same as the parameter that is passed!

Was this reply helpful? Yes No