cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Gidrone_NS
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
v-siky-msft
Community Support
Community Support

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
v-siky-msft
Community Support
Community Support

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

Hi @v-siky-msft ,

 

Thank you, this resolve my problem. 

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Top Kudoed Authors
Users online (54,775)