Hello.
I hope somebody could help me here, please.
I have:
-PowerApp where I have a dropdown list with Product Types (this selections is reading from excel file named Products) and combo box where I have different SKU types, which should be depended on the product type selected before. (SKUs are also from excel file Products)
-Excel with two columns, one is Type and another one is SKU and both are connected to the app.
-Sharepoint list where I have column Product Type as a choice, in sharepoint choices i have the same options as in excel file. and i have column with SKU as multiple choice where i dont have anything, i selected option to add data manually. so i was thinking that in the moment when user will add several SKUs, all will be visible in the sharepoint list.
Everything works and it reads correctly, except column in sharepoint with SKU.
Whenever i am creating request and i am adding SKUs in the app, those are not populated in Sharepoint later. Product Type is there, but SKU is empty column.
Any idea how to make it working ? What type of formula i need to add in "Update" for SKU combo box to read all selected items?
thanks!
