I have a list in which the Project Manager column (text) needs to auto-populate based on the Project Name (choice) column. Essentially there are a small group of project managers, each assigned to a group of Project Names. When the user opens the form and selects a Project Name from the drop down list, I want the Project Manager field to auto-populate. I'm just not sure what the best route is here. Would Power Automate be an option? The column conditional formatting seems to only give me the option of selecting a color if a column has specific values.

Any help would be appreciated.

Thanks