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.
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
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?
Please help. Thanks.
RR
Solved! Go to Solution.
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:
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}
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:
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}