web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / QUick question regardi...
Power Automate
Unanswered

QUick question regarding my form

(0) ShareShare
ReportReport
Posted on by 99

 i have created a form on teams that have several branching sections  and it works great , my only issue now is that the spreadsheet that collects the response's it a bit to long and messy, is there anything i can do to that will look for specific category from  one of the columns   and then pull that information onto a new named tab with the same name as the category.

if possible rather than pull hat full row if only brings over the columns related to the category - hope this makes sense 

 

 

David

Categories:
I have the same question (0)
  • BenUnlox Profile Picture
    64 on at

    Hi @Dougers1,

     

    I would recommend using a different spreadsheet than the one that Microsoft Forms automatically generates for you as it can get a bit funny if you try to customize this. 

     

    Then you should be able to use the steps in the example Flow (screenshot attached) to populate your various tables (which would only have the relevant columns) based on the initial category.

     

    Does that help at all?

     

    Thanks,

    Ben

  • Dougers1 Profile Picture
    99 on at

    Hi Ben 

    woul i still be able to have a landing page that  user could input the data?   like forms does?

     

    if not could i copy n paste the data from form to new sheet ?

  • Dougers1 Profile Picture
    99 on at

    why cany i see the form i created on teams  when i use the drop down i see some forms but not the one i created

    Dougers1_0-1696680434671.png

     

  • RobElliott Profile Picture
    10,321 Super User 2025 Season 2 on at

    @Dougers1 if it's a group form you need to paste in the form ID as a custom value, it won't appear in the dropdown.

  • Verified answer
    Dougers1 Profile Picture
    99 on at

    perect thanks

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 523 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 406 Moderator

#3
abm abm Profile Picture

abm abm 245 Most Valuable Professional

Last 30 days Overall leaderboard