Skip to main content

Notifications

Community site session details

Community site session details

Session Id : 4bWi9gEminugSAq4/Ss++G
Power Automate - General Discussion
Answered

Condition control from free text from a ms form response

Like (3) ShareShare
ReportReport
Posted on 4 Sep 2024 19:05:04 by 6
Hi, I'm trying create a simple flow that takes a response from a MS form question that is free text, I want the flow to terminate if the free text doesn't have a my operative number in, but if it has my operative number in then it will send an email. I can get the condition control to work if the form question is multiple choice but not if free text. Here is screen shots of the form question and the current flow.
 
I thought this would be a simple flow, but no :-(
 
 
Thanks for any help.
 
 
 
 
 
 
Categories:
  • Suggested answer
    David_MA Profile Picture
    10,874 Super User 2025 Season 1 on 04 Sep 2024 at 19:34:46
    Condition control from free text from a ms form response
    Set your condition up like this:
    This is the expression on the left: contains(outputs('Get_response_details')?['body/yourquestionhere'],'1234')

    Or you can do this:

    With this expression on the left: int(outputs('Get_response_details')?['body/yourquestionhere])

    To use the second option, I would make sure that you have your question set to only accept numbers:

  • creativeopinion Profile Picture
    10,411 Super User 2025 Season 1 on 04 Sep 2024 at 19:27:03
    Condition control from free text from a ms form response
     
    To troubleshoot your Condition, add Compose action(s) above your condition action to output the dynamic content you are using in your Condition. 
    Review the outputs from your Compose action(s) to see if what you are evaluating in your Condition action is what you are expecting.
     
    I cover how to troubleshoot a condition action in the first section of this YT Tutorial: 5 Power Automate Troubleshooting FAQs and Helpful Tips for Creating Better Flows
     
    In this Power Automate tutorial, I explore 5 frequently asked questions that pop up when troubleshooting a flow. If you’d like to to level up your Power Automate flow skills and learn how to troubleshoot your Power Automate flow—this tutorial is for you!
     
    IN THIS VIDEO:
    âś… How to troubleshoot a false Condition action result
    âś… How to get dynamic content when it isn’t selectable from the list of dynamic content
    âś… How to troubleshoot an Apply to Each action that isn’t looping through
    âś… How to troubleshoot a skipped Apply to Each action
    âś… How to troubleshoot a Filter Query
    âś… How to use a SharePoint yes/no column in a Filter Query
    âś… How to use Compose actions to troubleshoot a Power Automate flow
    âś… How to troubleshoot multiple emails being sent
    âś… How to troubleshoot multiple Teams messages being sent
     
    -- 
     
    You may also find these MS Form/Power Automate YT Tutorials helpful:
     
     

     

    In this Microsoft Power Automate Tutorial I’m going to cover where file uploads from your Microsoft Forms are saved. I’ll also show you how attach the uploaded files to an email and how to dynamically name the files and customize the recipient of the email based on the selections made in your Microsoft Form. I will also cover how to handle responses that don’t include any file uploads.

     

    IN THIS VIDEO:

    ‌✅‌ Two types of MS Forms

    ‌✅‌ Where Microsoft Personal (OneDrive) Form File Uploads are Saved

    ‌✅‌ Where Microsoft Group Form File Uploads are Saved

    ‌✅‌ How to Add a File Upload Question to an MS Form

    ‌✅‌ How to get a Microsoft Form ID

    ‌✅‌ How to get a Microsoft Form Response

    ‌✅‌ How to Get the Dynamic Content Microsoft Form File Upload Content

    ‌✅‌ How to handle Single and Multiple Microsoft Form File Uploads

    ‌✅‌ How to use a Scope action to Organize and Group Your Flow Actions

    ‌✅‌ How to Get the File Content from an MS Form File Upload

    ‌✅‌ How to Collect All Files Uploaded to a MS Form and Attach to an Email

    ‌✅‌ How to Handle MS Form Response When a File Isn’t Uploaded

    ‌✅‌ How to Create an Email Key

    ‌✅‌ How to Send an Email to a Specific Recipient Based on Form Selection

    ‌✅‌ How to Create a Dynamic Output Based on Form Selection

     

    -----

    How to Add Microsoft Form File Uploads to a SharePoint List Item

     

    In this Microsoft Power Automate Tutorial I’m going to cover how to add file uploads to a SharePoint list item. First, I’ll show you how to get the file name and content from the File Uploads from your Microsoft Form, then I’ll show you how to add those files to a SharePoint item.

     

    IN THIS VIDEO:

    âś… Two types of MS Forms

    âś… Where Microsoft Personal (OneDrive) Form File Uploads are Saved

    âś… Where Microsoft Group Form File Uploads are Saved

    âś… How to Add a File Upload Question to an MS Form

    âś… How to get a Microsoft Form ID

    âś… How to get a Microsoft Form Response

    âś… How to Get the Dynamic Content Microsoft Form File Upload Content

    âś… How to handle Single and Multiple Microsoft Form File Uploads

    âś… How to use a Scope action to Organize and Group Your Flow Actions

    âś… How to Get the File Content from an MS Form File Upload

    âś… How to Collect All Files from Multiple File Upload Questions

    âś… How to Handle MS Form Response When a File Isn’t Uploaded

    âś… How to Attach an MS Form Single File Upload to a SharePoint List Item

    âś… How to Attach Multiple MS Form File Uploads to a SharePoint List Item

    âś… How to Attach MS Form File Uploads to an Email

     

    -----

     

    How to Get a Microsoft Form RSVP Response into a SharePoint List

     

    IN THIS VIDEO:

    âś… How to get a Microsoft Form Response into SharePoint

    âś… How to get a Microsoft Form ID

    âś… How to get a Microsoft Form response

    âś… How to Build a Microsoft Form with Conditional Fields

    âś… How to used Branching in Microsoft Forms

    âś… How to format Microsoft Form multiple choice responses for a SharePoint multi-choice column

    âś… How to parse a Microsoft Form multiple choice response as string of text

    âś… How to convert a text response to a number

    âś… How to use the Switch action

    âś… How to create a custom email confirmation for a Microsoft Form submission

    âś… How to Create a Custom View in a SharePoint list

    âś… How to use the Compose Action

    âś… How to write Power Automate Expressions

     

    Hope this helps!

    If I helped you solve your problem—please mark my post as a solution âś….
    Consider giving me a đź‘Ť if you liked my response!

    👉 Level up your Power Automate skills by checking out my tutorials on YouTube
    👉 Tips and Tricks on TikTok and Instagram

     

     

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - General Discussion

#1
rpersad Profile Picture

rpersad 16

#2
David_MA Profile Picture

David_MA 10 Super User 2025 Season 1

#3
Michael E. Gernaey Profile Picture

Michael E. Gernaey 8 Super User 2025 Season 1

Overall leaderboard
Loading started