Answered

Using LookUp to get Data Specific fiekd from mssql Table

(0) Share

Report

Posted on by Mrrcomp

I trying to add code to the App OnStart to get a specific value base on loggedinUser but can't seem to find the correct syntax

Set(varLoggedInUser,User());

Set(CurrentUser,User().Email);

Set(CurrentRole,LookUp('[dbo].[InquirersDetail_t]',Email=CurrentUser));

Suggestions?

MRRCOMP

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

You need to add the specific ColumnName you want to hold in the variable:

Set(varLoggedInUser,User());

Set(CurrentUser,User().Email);

Set(CurrentRole,LookUp('[dbo].[InquirersDetail_t]',Email=CurrentUser,SpecificColumn));

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
Mrrcomp 99 on at

Like
a
(0)

Report
Copy link

Link copied!

@eka24

Thanks for your quick response I tired your solution however

1) CurrentUser is not an object but a single string (email) (i.e. I can set a text box fx=CurrentUser and it displays the email of the logged in user)

Regards

MRRCOMP
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Do you have an email collumn in your table. Also what ColumnName do you want displayed in the Lookup?

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
Mrrcomp 99 on at

Like
a
(0)

Report
Copy link

Link copied!

@eka24
yes there is a Email filed and the field I want returned is Role

Regards

MRRCOMP
Verified answer

eka24 20,925 on at

Like
a
(1)

Report
Copy link

Link copied!

Set(varLoggedInUser,User());

Set(CurrentUser,User().Email);

Set(CurrentRole,LookUp('[dbo].[InquirersDetail_t]',Email=CurrentUser,Role));

I hope Role is also a column in your table.

Try the above. If it doesn't work, take a screenshot of the form for any errors

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.