Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

Separate data from form by age group

(0) ShareShare
ReportReport
Posted on by 2
Hi,
I designed a form and i want the data in this form to be separated based on age group.
I have used power automate for this process but my data is still arriving on the same sheet when the data is filled in from the form.
 
Any suggestion on what to do and how to achieve my goal will be highly appreciated.
  • David_MA Profile Picture
    11,329 Super User 2025 Season 1 on at
    Separate data from form by age group
    You need to provide more details on what you are doing and what you want to accomplish as the information you have currently provided is too vague. For example, what is "this form"?
    1. Are you referring to an Excel spreadsheet?
    2. A Microsoft Forms response?
    3. A SharePoint/Microsoft Lists list form?
    4. Something else?
    Where is your data arriving from?
    1. An e-mail?
    2. From a forms response?
    3. An Excel file since you mention "the same sheet". If it is Excel, how does this arrive?
    What is the logic for separating the data based on age group and where and how?
    • If the data is coming from a Microsoft Forms response, you cannot separate it there. You would need to process it and send it somewhere else for processing.
    • Does the data need to go into different Excel files or different SharePoint lists based on the age groups?
    • What do you even mean by separating the data by age group?
  • TG-03060814-0 Profile Picture
    2 on at
    Power Automate
    Hi stampcoin,
     
    Have attached the screenshot of the flow.
    After testing it, the data are still going to the same sheet, but my aim is to have them in different sheet based on the age group.
     
  • stampcoin Profile Picture
    2,133 on at
    Power Automate
    Please share the flow screen shot if possible or provide more details as much as you can.
     

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

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May 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 >