Answered

LookUp a specific record and Create Collection of certain values

(0) Share

Report

Posted on by RH-25092337-0

All - I am trying to lookup a record using the current user via the LookUp function.

Once I have the record, I would then like to build a collection via the ClearCollection function and write certain values from the record to that collection.

So far, I have the following and am stomped beyond here:

If(!IsBlank(LookUp(UserProfiles, Employee=currentUser), CREATE COLLECTION, DISPLAY MSG NO USER FOUND)

Any help - greatly appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Nirav Raval (Akira28) 153 Moderator on at

Like (1)

Report

Hi RH-25092337-0

May be can you try the below code Button - OnSelect  🤞

Set(
foundUser,
LookUp(UserProfiles, Employee = currentUser)
);

If(
!IsBlank(foundUser),


ClearCollect(
userCollection,
{
FullName: foundUser.FullName,
Email: foundUser.Email,
Department: foundUser.Department,
JobTitle: foundUser.JobTitle
}
),


Notify("No user found", NotificationType.Error)
)

If this post solved your issue, clicking 'Does this answer your question' will help others discover the solution and close the topic. If you found it helpful, a Like would be awesome!

Regards,
Nirav J Raval (Akira28)

Was this reply helpful? Yes No
RH-25092337-0 35 on at

Like (0)

Report

Hi Nirav (Akira28)

Thanks...this was exactly what I was looking for.

As an alternative, I found that:

(1) I could do the lookup for the profile in my first screen, and if found,

(2) Open another screen (UserProfiles) and within there, I could set the "Items" property on the UserProfile to the LookUp and it would retrieve all the values. However, my original way (and the way for which you responded) is a cleaner approach...in my opinion and have adopted such.

Thanks again.

Was this reply helpful? Yes No