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]

Can you not create a formula of the criteria to Keep/Remove?

If I understand your want, having this dropdown on each row within the results window, I don't believe this is possible.

[Kate13122]

this needs to be send to approvers and they would choose if the access should kept or removed.

But thank you for your answer. 

Regards

Katarina

[Robin_McIntosh · Accepted solution]

@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-templat...

Attached is a template and workflow example to try.