How can I add columns with dropdown menu to a lookup column?

%3CLINGO-SUB%20id%3D%22lingo-sub-1815872%22%20slang%3D%22en-US%22%3EHow%20can%20I%20add%20columns%20with%20dropdown%20menu%20to%20a%20lookup%20column%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1815872%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20have%20two%20lists%2C%20one%20with%20resources%20and%20one%20with%20projects.%20The%20project%20list%20has%20a%20column%20%22Resources%22%20which%20is%20linked%20to%20the%20%22Resource%20list%22.%20When%20a%20resource%20is%20chosen%20I%20want%20other%20columns%2C%20like%20%22role%22%20(which%20is%20a%20drop%20down%20menu)%20to%20automatically%20appear%20in%20the%20project%20list%20when%20I%20choose%20resource%20from%20the%20resource%20list.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECurrently%20only%20certain%20types%20of%20columns%2C%20e.g.%20simple%20lines%20of%20text%20and%20dates%2C%20and%20a%20few%20others%20(not%20relevant%20for%20the%20information%20I%20want)%20is%20possible%20to%20add%20to%20%22allow%20multiple%20values%22.%26nbsp%3B%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22Add%20column%20to%20multiple%20values%20in%20lookp%20list.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F229093i044774E35A4A6345%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Add%20column%20to%20multiple%20values%20in%20lookp%20list.png%22%20alt%3D%22Add%20column%20to%20multiple%20values%20in%20lookp%20list.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20ideas%20how%20to%20solve%20this%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1815872%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1815978%22%20slang%3D%22de-DE%22%3ESubject%3A%20How%20can%20I%20add%20columns%20with%20dropdown%20menu%20to%20a%20lookup%20column%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1815978%22%20slang%3D%22de-DE%22%3E%3CP%3EHello%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F17936%22%20target%3D%22_blank%22%3E%40Merethe%20Stave%3C%2FA%3E%2C%20you%20can%20work%20with%20your%20SharePoint%20List%20and%20the%20Trigger%20Action%20%22When%20a%20SharePoint%20Column%20is%20modified%22%2C%20see%20article%20here%3A%20%3CA%20href%3D%22https%3A%2F%2Fapi.smartredirect.de%2Fapi_v2%2FClickGate.php%3Fp%3DmGrZ7Eo09S%26amp%3Bk%3Dd147d08aaa00abb30599c12c4dc624bb%26amp%3Burl%3Dhttps%253A%252F%252Fflow.microsoft.com%252Fen-us%252Fblog%252Frun-a-flow-when-a-sharepoint-column-is-modified%252F%26amp%3Bq%3Dpower%2Bautomate%2Bcascaded%2Bcolumns%2Bin%2Bsharepoint%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fapi.smartredirect.de%2Fapi_v2%2FClickGate.php%3Fp%3DmGrZ7Eo09S%26amp%3Bk%3Dd147d08aaa00abb30599c12c4dc624bb%26amp%3Burl%3Dhttps%253A%252F%252Fflow.microsoft.com%252Fen-us%252Fblog%252Frun-a-flow-when-a-sharepoint-column-is-modified%252F%26amp%3Bq%3Dpower%2Bautomate%2Bcascaded%2Bcolumns%2Bin%2Bsharepoint%3C%2FA%3E%3C%2FP%3E%3CP%3Eand%20working%20with%20cascaded%20drop%20downs%20is%20usually%20a%20thing%20to%20make%20with%20PowerApps%20app.%20Here%20is%20a%20good%20video%20from%20April%20Dunham%20to%20do%20it%20within%20a%20sharepoint%20list%3A%20%3CA%20href%3D%22https%3A%2F%2Fwww.sharepointsiren.com%2F2018%2F03%2Fcascading-dropdowns-in-powerapps-sharepoint-lookups%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.sharepointsiren.com%2F2018%2F03%2Fcascading-dropdowns-in-powerapps-sharepoint-lookups%2F%3C%2FA%3E%3C%2FP%3E%3CP%3EHope%20that%20helps.%20SharePoint%20is%20better%20to%20manipulate%20with%20PowerApps%20(Forms)%20and%20Power%20Automate%20(Workflows)%2C%20in%20my%20eyes.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EChild%2C%3C%2FP%3E%3CP%3EEva%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

Hi, I have two lists, one with resources and one with projects. The project list has a column "Resources" which is linked to the "Resource list". When a resource is chosen I want other columns, like "role" (which is a drop down menu) to automatically appear in the project list when I choose resource from the resource list. 

 

Currently only certain types of columns, e.g. simple lines of text and dates, and a few others (not relevant for the information I want) is possible to add to "allow multiple values". Add column to multiple values in lookp list.png

 

Any ideas how to solve this? 

1 Reply

Hello @Merethe Stave, you can work with your SharePoint List and the Trigger Action "When a SharePoint Column is modified", see article here: https://api.smartredirect.de/api_v2/ClickGate.php?p=mGrZ7Eo09S&k=d147d08aaa00abb30599c12c4dc624bb&ur...

and working with cascaded drop downs is usually a thing to make with PowerApps App. Here is a good video from April Dunham to do it within a sharepoint list: https://www.sharepointsiren.com/2018/03/cascading-dropdowns-in-powerapps-sharepoint-lookups/

Hope that helps. SharePoint is better to manipulate with PowerApps (Forms) and Power Automate (Workflows), in my eyes.

 

Kind regards,

Eva