web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps undefined

Power Apps

Answered

undefined

(0) Share

Report

Report

Posted on by Lavanya11

13

Hi Everyone,

I have created two tables

1. employee table with EID(text type) & CertID(lookup column)

2.Certificate table with CertID(text type) & CertName(text type)

Here I want to display the data of EID ,CertID and CertName in a gallery.

I have tried via Addcolumn Function AddColumns(Employee,"CertificateName",LookUp(Certification,CertID=CertID).CertName))

helpful if anybody clears this query and also can a lookup column be used in Filtering Vloopup function nad how?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (5)

Answers Img

Answers (1)

Sort by

Verified answer

Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@Lavanya11 - I think the below is what you're trying to do?

AddColumns( Employee, "CertificateName", LookUp( Certification, CertID = Employee[@CertID].Value, CertName ) )

Was this reply helpful? Yes No
Lavanya11 13 on at

Like
a
(0)

Report
Copy link

Link copied!

@Amik
Thank you . This solved my problem and need explanation on this question,
Can a Lookup column be used in Filter/VLOOKUP? and how just take my tables as example.

Was this reply helpful? Yes No
Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Lavanya11 - You have not provided much context with what you're trying to do, but in answer to your question, yes. A Lookup function can be used with a Filter function.

Was this reply helpful? Yes No
Lavanya11 13 on at

Like
a
(0)

Report
Copy link

Link copied!

I have created two tables
1. employee table with EID(text type) & CertID(lookup column)
2.Certificate table with CertID(text type) & CertName(text type)
Here I want to display the data of EID ,CertID and CertName in a gallery.
Same Probelm with filter Function.

Was this reply helpful? Yes No
Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Lavanya11 why does the solution I already provided not already answer your question? Why do you think you need the Filter function?

Was this reply helpful? Yes No

Join the conversation