Unanswered

QUick question regarding my form

(0) Share

Report

Posted on by Dougers1

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:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

BenUnlox 64 on at

Like (0)

Report

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

Forms-Branching-T...

Was this reply helpful? Yes No
Dougers1 99 on at

Like (0)

Report

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 ?

Was this reply helpful? Yes No
Dougers1 99 on at

Like (0)

Report

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

Was this reply helpful? Yes No
RobElliott 10,321 Super User 2025 Season 2 on at

Like (0)

Report

@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.

Was this reply helpful? Yes No
Verified answer

Dougers1 99 on at

Like (0)

Report

perect thanks

Was this reply helpful? Yes No