Power Platform Community Forum Thread Details

Hi everyone

Newbie here

I have a sharepoint list PP4 and am building a powerapp for adding new items , in my sharepoint site i also have an excel ( called SODP) that has 2 columns Org, Factory, and there is a line in the excel for each org and factory , it is not a 1-1 relationship , a Org can have several factories

eg Org:2223 Factory : 123

Org:2223 Factory :124

Org 2224 Factory: 140

In my sharepoint list (PP4) i have a column called Org ( Choice ) with all the Org values ( 2223, 2333,2444 etc ) , i have added that field to my powerapp form , user called use this dropdown to select Org , i now have added a dropdown called Factory from power app to the form this dropdown shows the values filtered from the selection of Org and returns me all matches of Factory from the excel (SODP ) , typically i will have around 3 dropdown choices

This filtering all works well -- my issue is when i save -- the Org is saved correctly but i dont know how to save the factory selection , back to the sharepoint list , so that when i edit the form the selected factory value sticks -- any help appreciated

Categories:

Building Power Apps