Can't get data from SharePoint Person or Group column

(0) Share

Report

Posted on by EBMRay

1,712

Hello everyone !

I am using the Expense Report template from powerapps.

After installing the app and trying to test it, the field Approver didn't find any data from the column ApproverName in SharePoint while the type of this column in the list is Person or Group.

By default the function of this field is Choices(Expenses, ApproverName).

I have invited all the users to whom will use the lists in the site. Also the users already exist in Azure Active Directory.

So what should be the function to read data from the ApproverName column in the list ?

Here are some screenshots about the Data of Approver fields:

Data of ApproverName.PNG

Thank you!!

Categories:

Building Power Apps

I have the same question (0)

All responses (14)

Answers (1)

Sort by

Pstork1 69,601 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Did you make sure you followed the setup instructions at https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/expense-report-install to create the SharePoint list behind the app and switch it over to use SharePoint as a data source?

Was this reply helpful? Yes No
EBMRay 1,712 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Pstork1
Yes i followed this tutorial to install the expense report.
I have created both lists in SharePoint, and i removed the default connections from data source and i have added back the SharePoint connections containing those lists (Expenses, LineItems).
I can read the data from CostCenter column in SharePoint that means i am connected but the Approver field didn't find any kind of data to read the users.
Here is a screenshot of CostCenter values between the SharePoint list and Powerapps:

And here is the issue in the Approver field in PowerApps:
Thank you!!

Was this reply helpful? Yes No
EBMRay 1,712 on at

Like
a
(0)

Report
Copy link

Link copied!

@Pstork1

I have fixed some errors and now i got 0 errors in the Appchecker but the issue remain the same.
The Approver field is not reading any data from the ApproverName column in SharePoint list of type (Person or Group).

The function of the Approver Field is Choices(Expenses.ApproverName).

What kind of functions we should use to trigger the users ?
I can read data from other fields, but i have no idea why this field won't read data it's weird..

Was this reply helpful? Yes No
Pstork1 69,601 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

I haven't played with that sample for a long time. What kind of data card or control are you populating with ApproverName?

Was this reply helpful? Yes No
EBMRay 1,712 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Pstork1
As i understand from your question, the Data of this combo box by default is the following:
and here is the ApproverName column settings in SharePoint:

I didn't change anything in the app, I just imported the app from the documentation as it is.

Maybe if you will install it back again you will see the issue.

Thank you !

Was this reply helpful? Yes No
EBMRay 1,712 on at

Like
a
(0)

Report
Copy link

Link copied!

@Pstork1
Any idea to deal with this issue ?

Was this reply helpful? Yes No
Pstork1 69,601 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

I pulled up a copy of the App this morning and worked through hooking it up to SharePoint. I found at least one typo in the instructions, "Cost Center" column needs to be created as "CostCenter" (no space). Other than that, and a lot of delegation warnings, mine ran without a problem. For the Approver Name field. It is setup to use a Search combobox rather than a dropdown. You have to click into the box and start typing a name. That will give you a dropdown list that match what you typed at which point you can pick one of them. Here's a screenshot.

Was this reply helpful? Yes No
EBMRay 1,712 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Pstork1

Yes there is a lot of warnings on startup, i ignored them.
I can see the data from CostCenter that i added them in the list that means i am connected to the right list.

The problem when i click on the Approver field i can't even type to search for users.
I tried something when i switch the ApporverName column in SharePoint to People and Groups instead of people only it shows (Everyone except extranl users).
and i tried to add new Drop down with the following function Expenses.ApproverName also didn't find the users.

But also i can't type to search for users, even i can't type to find myself.
Can you please show me screenshot of the Data of the combo box ? Or what may be the problem ?
Thank you!

Was this reply helpful? Yes No
Pstork1 69,601 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Switch the column back to people only. When you click in the box you should be able to type a couple characters and get a list like the one you show. Your settings are the same as mine. I'm not sure why its not working for you. Everything looks to be configured correctly.

Was this reply helpful? Yes No
EBMRay 1,712 on at

Like
a
(0)

Report
Copy link

Link copied!

@Pstork1
I switch it back to people only.
When i click in the box i can't type any kind of characters and there is no data in the list.
Les't try something,your app works perfectly so can u export your app and share it with me so i can import your app and try it.Maybe it will works for me.

Was this reply helpful? Yes No