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

Question

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".

Any ideas how to solve this?

eva vogel · Answer

Hello&nbsp;Merethe Stave,&nbsp;you can work with your SharePoint List and the Trigger Action "When a SharePoint Column is modified", see article here:&nbsp;https://api.smartredirect.de/api_v2/ClickGate.php?p=mGrZ7Eo09S&amp;k=d147d08aaa00abb30599c12c4dc624bb&amp;url=https%3A%2F%2Fflow.microsoft.com%2Fen-us%2Fblog%2Frun-a-flow-when-a-sharepoint-column-is-modified%2F&amp;q=power+automate+cascaded+columns+in+sharepointand 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:&nbsp;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.&nbsp;Kind regards,Eva&nbsp;

Forum Discussion

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