cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate II
Advocate II

people picker on sp form don't work, again

Very strange situation... i have app with several SharePoint form on which are People and Groups field. On one screen i have form with one combobox which is people picker. When I added that field in form I received error msg on Items property  "Choices([@Zaposleni].Zaposleni)"!!! When add .DislplayName on the end of formula, error disappear, but search capability stop work. I tried to change many property and back, save app, clear cache, open app, refres all data sources, change property... and problem is same. 

When add combobox outside of form, everything work perfect, and when I try to copy same combobox to the form card, everything stop working and i receive error msg.

 

On other screen in same app I have different form for different sp list on same site collection and everything work perfect, without any error message and with "normal" settings "Choices([@ZahtevZaGO].Zamena)"

 

in att, you can find screen shot of my problem. I read every post abotu people picker bug and problem 😞

 

Please, anyone who can help me will be great.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: people picker on sp form don't work, again

Hi @Gidrone_NS ,


Are the combo box and choices formulas generated in default?

This seems to be an SharePoint connection problem, sporadic, no magic bullets.

However, i have an alternative work around to avoid these error. Use Office365 connector to get all uers instead of orginal choices function.

1. Add Office365 user connection

2. Set Combo box Items property: Office365Users.SearchUserV2().value

3. Set Update property of data card: 

 

{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Claims:"i:0#.f|membership|"& DataCardValue16.Selected.Mail,
Department:"",
DisplayName:"",
Email:"",
JobTitle:".",
Picture:"."
}

 

Then you can patch the office users patch to Person column without any error.

Best regards,

Sik

 

View solution in original post

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: people picker on sp form don't work, again

Hi @Gidrone_NS ,


Are the combo box and choices formulas generated in default?

This seems to be an SharePoint connection problem, sporadic, no magic bullets.

However, i have an alternative work around to avoid these error. Use Office365 connector to get all uers instead of orginal choices function.

1. Add Office365 user connection

2. Set Combo box Items property: Office365Users.SearchUserV2().value

3. Set Update property of data card: 

 

{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Claims:"i:0#.f|membership|"& DataCardValue16.Selected.Mail,
Department:"",
DisplayName:"",
Email:"",
JobTitle:".",
Picture:"."
}

 

Then you can patch the office users patch to Person column without any error.

Best regards,

Sik

 

View solution in original post

Highlighted
Advocate II
Advocate II

Re: people picker on sp form don't work, again

Hi @v-siky-msft ,

 

Thank you, this resolve my problem. 

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

Top Solution Authors
Top Kudoed Authors
Users online (7,034)