Load the office365's contact automatically with MSSQL

(0) Share

Report

Posted on by samsam

185

Hi,

When I was using the SharePoint List and the column type is "Person or Groups", PowerApps is able to recognize this column and look for my office365's contact.

However, when a SQL database is being used, PowerApps is recognize it as a normal "TEXT" (VARCHAR) only. It does not lookup office365's contact automatically.

How can I make it happen if using MSSQL database?

Thanks in advance

Sam

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

v-xida-msft on at

Like (1)

Report
Hi @samsam ,

Could you please share a bit more about your scenario?

Do you want to configure the VARCHAR field in your SQL Table as a Person Pickup field within your app?

If you want to configure the VARCHAR field in your SQL Table as a Person Pickup field within your app, I afraid that there is no direct way to achieve your needs in PowerApps currently.

As an alternative solution, you could consider remove the original Text Input box from the VARCHAR field data card in your Edit form, instead, add a ComboBox control within it.

I have made a test on my side, please take a try with the following workaround:

1. Go to the Edit screen, and then select the Edit form.

2. Unlock the VARCHAR field data card in your Edit form.

3. Remove the original Text Input Box from it, instead, add a ComboBox control manually within it. Set the Items property of the ComboBox to following:

Office365Users.SearchUser({searchTerm:ComboBox1.SearchText})

then set the ComboBox control Layout to Person layout.

Set the Update property of the VARCHAR field data card to following:

ComboBox1.Selected.DisplayName

set the SelectMultiple property of the ComboBox to following:

false

Note: You need to add Office 365 Users connector as data source in your app firstly.

Please check the following GIF screenshot for more details:

After that, you could pickup a person in your Org from the ComboBox like below:

Please consider take a try with above solution, check if the issue is solved.

Best regards,

Was this reply helpful? Yes No
samsam 185 on at

Like (0)

Report

Do you want to configure the VARCHAR field in your SQL Table as a Person Pickup field within your app?
I only know the VARCHAR data type in SQL to store a Person Contact.
If there is other data type that has better way to store office 365's user/contact, I am happy to use it

@v-xida-msft thanks for the work around, the field looks great when selecting email from the drop down menu.
However, it comes up with another problem.... my contact has more than 100 contacts, and I have to scroll down to look for a name (Wayne) that is started with "W".

Is there any way to make it easier to select the office 365 user/email?
It looks like SharePoint List's Person and Groups has better user experience on contact selection

Thank you 🙂

Was this reply helpful? Yes No
v-xida-msft on at

Like (1)

Report

Hi @samsam ,

Currently, within SQL Table, there is no direct data type to store the Contact info from your Office 365 Org. You could use the VARCHAR field to store the displayname of the person.

As an alternative solutuion, I think the solution I provided above could achieve your needs. Actually, it is not necessary to scroll down to look for your specific person within the ComboBox, you could directly type search key within the ComboBox, then the related person would be filtered within your ComboBox.

Please make sure you have set the IsSearchable property of the ComboBox to true, then you could type the search key within the ComboBox as below:

Please consider take a try with above solution, check if the issue is solved.

Best regards,

Was this reply helpful? Yes No
samsam 185 on at

Like (0)

Report

@v-xida-msft Thank you, you do help me a lot 🙂 Everything works perfectly
Cheers~

Was this reply helpful? Yes No