Unanswered

Populate a user lookup field with the currently logged in user on an Entity Form

(0) Share

Report

Posted on by USSJona

Hi,

I have tried to associate the current user with an insert basic form without success. I have a custom table with a lookup field to the 'User' table.

I have tried 'Associate Current Portal User on Insert' and 'Associated Table Reference' and 'Metadata Prepopulate' and 'Metadata Save Value On Save' individually and a combination of these without success.

I get the impression from the options I get and from reading posts from people with similar issues, that these options are targeted at the 'Contacts' table and not the 'User' table.

The closest I achieved was using 'Associated Table Reference' and hiding the Lookup field in the form. This saved the record without the user name, even though its a required field?

On submit of the form I either get 'The form could not be submitted for the following reasons: Staff List is a required field'(if the field is visible) or 'The requested record was not found' (if the field id hidden)

Please Help

All responses (3)

Answers (0)

USSJona 17 on at

Like (0)

Report

Re: Populate a user lookup field with the currently logged in user on an Entity Form

Hi All,

Can anybody help with the above please ?

Many thanks,
USSJona 17 on at

Like (0)

Report

Re: Populate a user lookup field with the currently logged in user on an Entity Form

Hi Ragavanrajan,

Thanks for your reply, I have seen those post before. I have tried the suggestions in the posts without success. I notice these posts and others all relate to the 'Contacts' table, I'm using the 'User' table.

I have a custom table (SAC HW Request), it has a lookup field linked the 'User' table (HWR Staff List).

The attached screenshots show the setup with 'Associate Current Portal User on Insert' and Metadata, I've tried both options 'Prepopulate' and 'Set Value On Save' with the same result. The errors are shown in screenshots with 'HWR Staff List' hidden or not.

The Metadata Prepopulate screenshot shows my only 'User' option that I can select, I think this is where the error is coming from.

Where am I going wrong ?Form GeneralForm Additional SettingsMetadata AttributeMetadata PrepopulateForm with Staff ListForm Staff List hidden
ragavanrajan 7,036 Most Valuable Professional on at

Like (0)

Report

Re: Populate a user lookup field with the currently logged in user on an Entity Form

Hi @USSJona

Two key things to understand here

1. Associate Current portal user on insert

2. Entity form metadata- Populate field link to Step 1

Please have a look at the below thread. Hope it helps

https://powerusers.microsoft.com/t5/Power-Apps-Portals/How-to-select-current-signed-in-Contact-by-default-in-a-custom/td-p/572954

Hope it helps.
------------

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