Jan 18 2018 06:27 AM
I am building a new SharePoint list (we use SharePoint online) and in that list I have a lookup to Department. This also captures the department ID number. The next field I have is Positions. I also have a DepartmentalPositions list (separately) that I want to use as a "linking" table that contains the DepartmentNumber and PositionID. Ultimately what I want is when the department is selected to only display the positions that are linked to that department. How would I go about doing this? Eventually this list is also going to be part of a Power App.
Thanks and if I am posting to the wrong community, please let me know
Jan 20 2018 08:12 AM
SolutionJan 21 2018 08:10 AM
Juan,
Thanks for the response. I was able to do it by manipulating power apps and the use of some variables to store the IDs of the items.
Brad
Jan 21 2018 08:56 AM
Sep 27 2018 11:33 AM
Hi Brad,
I need to something similar. Can you share your solution?
Thanks,
TK
Jan 20 2018 08:12 AM
Solution