cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Watch Now

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (6,768)