Skip to main content

Notifications

Announcements

Upwork and Microsoft Power Platform Partnership
Welcome to the Power Platform Communities
Check out the New Agent Creator Community
News and Announcements icon
Community site session details

Community site session details

Session Id : vPrG5oNVmB0EiKQpXnMUu0
Power Platform Community / Forums / Power Automate - Building Flows / Separate data from for...
Power Automate - Building Flows
Unanswered

Separate data from form by age group

Like (0) ShareShare
ReportReport
Posted on 3 Jun 2025 08:22:59 by TG-03060814-0 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.
Categories:
Business Process Flows
  • David_MA Profile Picture
    David_MA 11,517 Super User 2025 Season 1 on 03 Jun 2025 at 14:27:16
    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
    TG-03060814-0 2 on 03 Jun 2025 at 14:01:32
    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.
     
    flow.PNG
  • stampcoin Profile Picture
    stampcoin 2,325 on 03 Jun 2025 at 11:41:54
    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

News and Announcements

Upwork and Microsoft Power Platform Partnership
Welcome to the Power Platform Communities
Check out the New Agent Creator Community

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 > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 566 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 516 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 492

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans