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

Combobox Distinct Filter not updating Sharepoint Choice Column

Hi,

I have Sharepoint list and using another Sharepoint list for choices with name OutletSpecialEvent. From this list will populate Operation and Nomor & Nama Outlet column.

 

ramadhanira_0-1665631574241.png

 

 In Power Apps on Items: DataCardValue8 (Operation), I insert this formula:

 

 

 

 

 

Distinct(OutletSpecialEvent,Operation)

 

 

 

 

 

On Items: DataCardValue9 (Nomor & Nama Outlet), I insert this formula:

 

 

 

 

 

Filter(OutletSpecialEvent,Operation = DataCardValue8.Selected.Result).Title

 

 

 

 

 

 

ramadhanira_1-1665631658809.png

 

Distinct & filter succesfully populate data from OutletSpecialEvent Sharepoint list. But, when I tried to submit new form, this field doesn't update Sharepoint choices column

 

 

2022-10-13 10_34_21-CDOInfrastructure - SpecialEventRequest - All Items - Brave.png

 

Please help. Thanks.

 

RR

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-qiaqi-msft
Community Support
Community Support

Hi @ramadhanira,

Could you please tell me that both of Operation and Nomor & Nama Outlet column are Choice type in SpecialEventRequest?

Generally, a Choice type column has its own options in column setting as below:

vqiaqimsft_0-1665638993919.png

Not sure why you pull values from another list.

 

If they are Choice type, then you should set the Update property of the data card as below:

{Value:DataCardValue8.Selected.Result}
{Value:DataCardValue9.Selected.Title}
Best Regards,
Qi

View solution in original post

2 REPLIES 2
v-qiaqi-msft
Community Support
Community Support

Hi @ramadhanira,

Could you please tell me that both of Operation and Nomor & Nama Outlet column are Choice type in SpecialEventRequest?

Generally, a Choice type column has its own options in column setting as below:

vqiaqimsft_0-1665638993919.png

Not sure why you pull values from another list.

 

If they are Choice type, then you should set the Update property of the data card as below:

{Value:DataCardValue8.Selected.Result}
{Value:DataCardValue9.Selected.Title}
Best Regards,
Qi
ramadhanira
Frequent Visitor

Thanks a lot @v-qiaqi-msft solved.

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 (5,446)