how to create dropdown menu on rows level

Kate13122

Dear community,

May I kindly ask you to help me with the dropdown menu that I need to have in one of my projects? 

The main purpose is : 

Name           Access keep/remove 

AA                Keep

BB                Remove

CC                Keep 

The dropdown menu should contain one column with these two options on row level as is possible in excel. 

Something like this: 

and if the coloring would be possible to set up to recognize them, it would be great. 

Could you please advise if this is possible? 

Thank you all,

Regards

Katarina

Robin_McIntosh

@Kate13122  I understand what you are wanting now.  You'll need to create an Excel template (but saved as .xlsx) with your Data Validation list and any formatting then output your data to said template with Overwrite Sheet or Range but be sure to check Preserve Formatting on Overwrite.

Here's a link to the How-To:  https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-do-I-output-to-an-Excel-template-file/ta-p/1244/jump-to/first-unread-message

Attached is a template and workflow example to try.

Discussion_DropDownList_Excel.yxmd

Output Template.xlsx