Unanswered

SharePoint Person Or Group column Not Integrating with PowerApps

(0) Share

Report

Posted on by v-maper Microsoft Employee

Hello,

Whenever I use the "Person or Group" column from SharePoint to enable users to look-up a person within our org it works great until I try to look-up that value on the next screen of my app. On this screen I have a field that is set to show to the value submitted from that coloumn. (Ex: App is opened to submit a help request. On this screen there would be a field called "requestor" where the requestor could begin to fill in their name and the app would automatically populate matching names within our org. Once the request is submitted, a requestor could track the help request and see their name as the requestor [i.e. ThisItem.ColumnName]).

Unfortunately, once a request is submitted with the requestor name, the next screen on my app does not autopopulate the frequestor field based on the information gathered from the requestor. Any feedback on how I can enable this?

Thank you,

Marcella

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

v-monli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-maper,

If this "Responser" is a People and Group column, and you created the app using SharePoint list, then it should work with the EditScreen when submitting. I think the issue you are facing is on a custom screen you created by your self? Would you please share more detailed configuration of this screen? What are the included controls and related formulas?

Regards,

Mona

Was this reply helpful? Yes No
v-maper Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi Mona,

Here are the controls and formulas we are using: DisplayForm, LabelBox with embedded Item Formula: ThisItem.ColumnName.

Here is how we are using them:
Enable Person or Group Coloumn in SP List to generate "Requestor Name" field in our form
Once name is typed into the "Requestor Name" field in our form, the requestor can look-up their name and submit the form
Once the form is submitted, the "Requestor Name" field appears in our SP List- but does not appear on a screen where we have a DisplayForm of the submitted "Requestor Name" field

We have tried to submit the LabelBox using the formula using ThisItem.ColoumnName and it doesn't appear either. Instead, we get an error message that reads: "Invalid Argument Type, Expecting one of the following: Text, Number, Buulean."

Please let me know if you have any feedback. I will attached some screenshots to help you better understand the issue momentarily.

Thank you,
M

Was this reply helpful? Yes No
v-maper Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Here are the images to go with the explanation of the response I just now submitted:

Step 1 works well... a requestor can go in and submit a form after the person or group coloumn auto-populates their nameStep 2 does not work as well. It creates an error message where the "Requestor Name" field should appear

Was this reply helpful? Yes No
v-maper Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

B.U.M.P

Was this reply helpful? Yes No
Gigaenvy 147 on at

Like
a
(0)

Report
Copy link

Link copied!

I was trying to do the same thing but with ..." &Author. Same error.

Was this reply helpful? Yes No
Gigaenvy 147 on at

Like
a
(0)

Report
Copy link

Link copied!
Just figured it out. It's long and ugly but pulls the people from Office 365 email as entered into the SP list column for People and Group.

In your gallery, text label:

"Record Created by: "&Author.Displayname

Was this reply helpful? Yes No