Answered

On AppStart: find the ID from a SP table where the email adress is the same as the logged inn O365 user and then store the id as a var

(0) Share

Report

Posted on by PowerTegga

Hi.

I have a list in SP Online with columns for ID, Name and email adress. When the app starts I want to find a match between User().EMail() and the email adress in the table, and then store the ID from the table as a variable to use later in the app.

Whats the best method to get this done?

Thanks in advance

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

SkiDK 1,016 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @PowerTegga
You can put this in OnStart:

Set(UserId, LookUp(SP_List, Email = User().Email, ID))

Maybe a better idea is to create an object of your user, so you can always access all of your user information that comes from SharePoint, simply like this:

Set(User, LookUp(SP_List, Email = User().Email)) You can then access id by: User.ID as well as all other information that comes from your SP list

Hope this helps!

Was this reply helpful? Yes No
PowerTegga 77 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for your answer, @SkiDK .

Your answer sounded like a good idea, but there seems to be a problem with this. See the strange error in my attachment. This is when I put the mouse over the Lookup function.

Do you have any idea what might cause this?

Was this reply helpful? Yes No
Verified answer

v-siky-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @SkiDK ,

It is not suggested to apply the User() function into the formula directly, please try with this:

Set(VarUser, User().Email); Set(VarID,LookUp('SP list', Email = VarUser.Email).ID)

Hope this helps.
Sik

Was this reply helpful? Yes No
SkiDK 1,016 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @PowerTegga
That's a weird error. What is the result if you do next:

LookUp(gmPersoner, Email = User().Email).ID

But as @v-siky-msft says, it is better to first store current user in a variable and then to use that object. Works for delegation and it also will be more performant. So what is the result if you try next:

Set(varUser, User()); Set(varUserId, LookUp(gmPersoner, Email = varUser.Email).ID);

If that doesn't work, could you show the structure of 'gmPersoner', and if its a collection where and how it's initiated?

Was this reply helpful? Yes No
PowerTegga 77 on at

Like
a
(1)

Report
Copy link

Link copied!

I found out that the problem was that I needed to save and close the app first. When I opened it again it was all good. I guess thats because the function is placed in "App" (Startup).

Thanks both of you.

Was this reply helpful? Yes No