Person Data from Sharepoint does not showup when editing form

(0) Share

Report

Posted on by dhageuk

Hi,

I have the following:

Sharepoint1 <- contains the saved data

PersonList <- contains person lists

I have a problem when I try to edit form, the saved data from Sharepoint1 does not showup. This only happens when I try to change the Items property to use PersonList.

Below are the properties on edit form,

Items:

Distinct(Filter(PersonList, Column1 = ComboxBoxValue.Selected.Result).ColumnPerson, ColumnPerson.DisplayName)

DefaultSelectedItems:

Parent.Default

Default:

ThisItem.ColumnPerson

Update:

{
Claims: LookUp(PersonList, ColumnPerson.DisplayName=ComboBoxValue.Selected.Result, ColumnPerson).Claims
DisplayName: LookUp(PersonList, ColumnPerson.DisplayName=ComboBoxValue.Selected.Result, ColumnPerson).DisplayName,
Email: LookUp(PersonList, ColumnPerson.DisplayName=ComboBoxValue.Selected.Result, ColumnPerson).Email,
Department: "",
JobTitle: "",
Picture: ""
}

Any thoughts?

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

v-chengfen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @dhageuk ,
If you want to select the Person under the organizational structure,
please create the Office365USer connector first
Items:
Office365Users.SearchUser({searchTerm:DataCardValue16.SearchText,top:20})
Update:

Best Regards
Cheng Feng

Was this reply helpful? Yes No
dhageuk 10 on at

Like (0)

Report
Copy link

Link copied!

Thanks Feng!

I get the Person list from PersonList sharepoint that looks like this:

ID Column1 ColumnPerson
1 A Person A
2 A Person B
3 B Person C

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

Like (0)

Report
Copy link

Link copied!

Hi @dhageuk ，
I made a template for your reference
Items:
Distinct(Filter(PersonList, Column1 = ComboBox2.Selected.Value).ColumnPerson, ColumnPerson.DisplayName)
Update:
{ Claims: LookUp(PersonList, ColumnPerson.DisplayName=DataCardValue16.Selected.Result, ColumnPerson).Claims}
Here is result:

Best Regards
Cheng Feng

Was this reply helpful? Yes No
dhageuk 10 on at

Like (0)

Report
Copy link

Link copied!

Thank you.

My issue is that when I EDIT the form in canvas, the Person Field is empty. The same property (Item and Update) is used in the EDIT form. The saved data from sharepoint does not show.

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

Like (0)

Report
Copy link

Link copied!

Hi @dhageuk ,

Can you provide some screenshots of your scene?
In my scenario is no problem

Best Regards
Cheng Feng

Was this reply helpful? Yes No
dhageuk 10 on at

Like (0)

Report
Copy link

Link copied!

@v-chengfen-msft Are you in EDIT form? and then add the Item and Update properties in the edit form as well.
I am sorry I cannot share screenshots.

same issue as this but I cannot go the same route
https://powerusers.microsoft.com/t5/Building-Power-Apps/PowerApps-List-Form-Displaying-Saved-Data/td-p/1413789

Was this reply helpful? Yes No