Answered

preselect lookup field's value

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello Community!

I'm trying to build an event inscription management app.

It all starts in CDS with 3 different entities: Events, Inscriptions and Users.
Event contains data for the event, location, date, name of event, etc.
Inscription contains data such as the inscription number, days of presence, manager approval, etc.
User contains a bit more personal data such as the user's name, email, allergies, restriction, location and other personal info.
Those entities are related this way: Event -(one to many)- Inscriptions -(many to one)- Users

Thus, I have 2 lookup fields in Inscriptions, one that picks an event and another that picks a user's name (In my case called Participant).

When creating or modifying an user profile via a form (Users entity), the name and email address fields are pumped from the AD via the User().Fullname and User().Email functions under Default in a text field and the display mode is set on Displaymode.view. No problem here!

Now, When comes the time to re-do the same with the user's name (lookup field now), under Default I replace ThisItem.Participant (contains the user's name in my case) with User().Fullname , I get an error (see image). So how do I solve this problem without messing my entities' relationships? Is there a workaround?
The whole purpose of this is to make sure that an user cant only submit an inscription for himself and no other user.

Many thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

WarrenBelz 156,454 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anonymous ,
I will start with what I believe may be a simple solution and go from there if this is not the case.
The error appears to be a Delegation warning on User().Email (User().FullName would receive one too as neither are delegable filters).
The easy workaround is to set Global Variables on App OnStart and use these in your filter
Set(vUserName,User().FullName); Set(vUserMail,User().Email)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @WarrenBelz for your quick response!

Unfortunately this workaround did not solve my issue as I get a unexpected text or number error.

Was this reply helpful? Yes No
WarrenBelz 156,454 Most Valuable Professional on at

Like
a
(2)

Report
Copy link

Link copied!

Thanks @Anonymous ,
That eliminates one of the bigger delegation issues, but does not solve your issue and it is strange that a variable of the same value produces a different error.
However I am not a CDS expert, so I will tag one of my colleagues @Anonymous for an opinion.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

@WarrenBelz thanks for the tag, I'll see if I can help but I've not worked with CDS before so maybe ... maybe not? I will also tag @PowerAddict here as well just to check my input. He has good working knowledge of CDS.

@Anonymous
It would appear you are trying to replace a record (ThisItem.Participant) with a value (User().FullName) which is causing the error. My idea would be to trying using this record call instead:

LookUp(Users, Participant.FullName = User().FullName, FullName)

You could also use @WarrenBelz suggestion for variables if the above throws errors - always good to throw the User().FullName and User().Email into variables because they can cause a number of issues.

Now, I'm not across all of the attribute (column) names in the CDS entities but where I have 'FullName' above in reference to the 'Users' entity it maybe called something else, not sure?

Let me know how you get on, and maybe @PowerAddict can confirm/correct the above as required 🙂

Was this reply helpful? Yes No
Verified answer

PowerAddict 7,316 Most Valuable Professional on at

Like
a
(2)

Report
Copy link

Link copied!

Thank you @Anonymous and @WarrenBelz for the tag.

@Anonymous, the explanation of the issue given by @Anonymous is correct.

It expects a record of type User and User().FullName just gives you text. Also, it is very easy to get confused with the Users entity and the User() function. User() function is just to retrieve values like name, email and image of the current logged in user. Whereas the Users entity is the complete list of user records.

You can however use the User() function to do a lookup on the Users entity.

LookUp(Users, 'Full Name' = User().FullName)

You should be able to use this as your Default property of the dropdown of users. One suggestion, use email as the lookup value, rather than fullname as technically there is a possibility of 2 people having the same full name especially since FullName only gives you FirstName + LastName.

Also, if you dont want the user to be able to select a diff user, you may want the User dropdown to be disabled or view only. Set the datacard's DisplayMode property as:
DisplayMode.View or DisplayMode.Disabled.

My lookup expression may not be exactly right as I am not in front of my computer but am fairly certain it should work.

Let me know if it doesn't and I should be able to test it out in a few minutes.

Hope this helps.

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution.

Thanks!
Hardit Bhatia
The Power Addict
https://thepoweraddict.com

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz , @Anonymous and @PowerAddict!

It worked by setting my the Default to Lookup(Users, 'Full Name' = vUserMail)
Where vUserMail is the variable proposed by @WarrenBelz on my appstart which stores the user's name.

Thank you all for your support!

Was this reply helpful? Yes No
PowerAddict 7,316 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Glad I could help! Good luck with the rest of your app! Feel free to reach out in case of any questions!

Thanks,
Hardit Bhatia
The Power Addict
https://thepoweraddict.com

Was this reply helpful? Yes No