cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DmitryDol
Frequent Visitor

Complex Columns are not working in Power App

Hi,

 

I am quite new to the power apps and faced an issue with creating customized app based on SharePoint list. I have created an app which was fully working, however after some time it appeared that 'Person and group' as well as 'Choices' columns would not show results specified but rather a long list of items 1, 2, 3 ... etc or either just a blank list.

I have tried re-associating date linked and creating new column, but nothing helped. 

 

Could you please suggest if anyone faced this error and how I could fix it?

Also worth to note that Power app cards for other SharePoint lists are working fine.

 

Please see an example of 'Likelihood' column which supposed to have 3 choices as on the second image.

DmitryDol_0-1661121499083.png

DmitryDol_1-1661121709020.png

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-yujincui-msft
Community Support
Community Support

Hi @DmitryDol ,

 

Are you using Power Apps in Teams? 

 

Maybe you could try as follows: 

 

1. For Combo Box(Choice Column) Control: 

Cut and paste the formula for the combo box. 

vyujincuimsft_0-1661412878507.png

Or 

vyujincuimsft_1-1661412878508.png

2. For Combo Box(Person or Group Column) Control: 

Cut and paste the formula for the combo box. 

vyujincuimsft_2-1661412878510.png

Or 

vyujincuimsft_3-1661412878511.png

Result Screenshot: 

vyujincuimsft_5-1661412957413.png

 

 

Best Regards, 
Charlie  Choi 

View solution in original post

3 REPLIES 3
Kimii
Resolver II
Resolver II

HI @DmitryDol 
please check the Selection box's DataField & SearchField properties, 

in this case they should appear with [Value]

 

v-yujincui-msft
Community Support
Community Support

Hi @DmitryDol ,

 

Are you using Power Apps in Teams? 

 

Maybe you could try as follows: 

 

1. For Combo Box(Choice Column) Control: 

Cut and paste the formula for the combo box. 

vyujincuimsft_0-1661412878507.png

Or 

vyujincuimsft_1-1661412878508.png

2. For Combo Box(Person or Group Column) Control: 

Cut and paste the formula for the combo box. 

vyujincuimsft_2-1661412878510.png

Or 

vyujincuimsft_3-1661412878511.png

Result Screenshot: 

vyujincuimsft_5-1661412957413.png

 

 

Best Regards, 
Charlie  Choi 

Thank you @v-yujincui-msft . 

For the Choice field I retyped choice formula into item and it seemed to resolve issue by pulling correct output from the list.

With regards to the Person field changing display options worked!

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (2,458)