Answered

How to save/write People Picker info to Dataverse table

(0) Share

Report

Posted on by koen_EUN

Hello,

I'm trying to create a Dataverse database & accompanying Power App to manage basic course information. One of the fields (columns) in the database (table) is 'Course coordinator':

For the 'Data type' I had selected the 'Customer' value, because (while our course coordinator is a colleague and not a 'customer') it was the only 'person' data type in the list.

In my app I use the following for the Items. I can search and select users without problem

Office365Users.SearchUserV2({searchTerm:DataCardValue4.SearchText,top:5}).value

However, when hitting the Save button, I get an error saying that a required field is not filled.

The field is required in the database and in the app, but somehow the value does not seem to bet stored.

The OnSelect of the Save button is simple:

SubmitForm(FormNewCourse)

Would I need to do anything extra to take and 'store' the value (person) in this database field? Or is the 'Customer' field/data type not the right one for this purpose?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report

Hi @koen_EUN ,

I would suggest leveraging User table if this is an internal user of the organization and utilize Contact if this is an external user to the organization. The Customer type is a field that has the ability to be an Account or Contact and is used in areas like Opportunities, Quotes, and other in Dynamics 365 where you could be selling to an individual user (Contact) or a business (Account).

Keeping as a Customer table will over-complicate your system I expect and moving to the User or Contact will simplify the ability to persist the information in the form.

Hope this helps. Please accept if answers your question or Like if helps in any way.

Thanks,

Drew

Was this reply helpful? Yes No
koen_EUN 8 on at

Like (0)

Report

Hi @dpoggemann
Thanks for your reply. When you say 'leveraging the User table', are you talking about the Power App or about the Dataverse table?
In the Power App I'm already using Office365Users as a data source. In the Dataverse table there's only one 'people' option when adding a column, which is Customer (in a spoiler container because of image height):
Spoiler (Highlight to read)
Would you have any reference to documentation to this User or Contact field? I'm wondering if it might not be available with our subscription, is that possible?

Many thanks

Was this reply helpful? Yes No
Verified answer

Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report

Hi @koen_EUN ,

I am talking about in the Dataverse. Choose "Lookup" from your drop down and this will allow you to select other tables in the Dataverse for the column. You will see Users as a choice in the selection, same with Contacts.

Hopefully this helps. Please accept if answers your question or Like if helps in any way.

Thanks,

Drew

Was this reply helpful? Yes No
koen_EUN 8 on at

Like (0)

Report
Hello @dpoggemann,
Thanks so much. That (replacing the Database field with Lookup > User) seems to do the trick. When adding the field in the Power App, the people picker now shows up automatically, and I can search & select colleagues.

Just two more questions, if I may:
Would you have an idea why for this field in the PowerApp the 'Image' field might be greyed out?
Secondly, I used the following formula to look up the current user and select them for the Default value.
Office365Users.SearchUserV2({searchTerm:User().Email}).value
Could you (point me to information that will) tell me how to do this with the Dataverse User Lookup being the data source?

Was this reply helpful? Yes No