Skip to main content
Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Answered

Depending on form response set a variable

(0) ShareShare
ReportReport
Posted on by 7

Hi Power Automate Community!

I'm trying to automate our company's new start process. We have a Microsoft form which gathers all the appropriate information, and I have this triggering a flow. From this Flow the plan is that based on the Job Title selected, it would then alert specific teams of their actions. The problem is we have over 100+ job titles! And I do not want to do a unique Switch Case per job title. I know that a lot of job titles will have the same requirements, so I was wondering if there was a way to use a Variable.

Is there a way I could set a Variable, have the flow look at the Job Title field, and if the Job Title = x, y or z. Set the Variable appropriately? This way I could massively reduce the number of switch cases in my flow!

Thanks,

  • fracturechris Profile Picture
    7 on at
    Re: Depending on form response set a variable

    This worked perfectly, Thanks!

  • Verified answer
    Ellis Karim Profile Picture
    11,143 Super User 2025 Season 1 on at
    Re: Depending on form response set a variable

    Please have a look at the first part of this solution which when given a US states (in your case a Job Title) returns the state's abbreviation (Team to alert):

    Routing files into Sharepoint document library subfolders from Form submission

     


    Ellis
    ____________________________________
    If I have answered your question, please mark the post as Solved.
    If you like my response, please give it a Thumbs Up.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1