cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ALP1
Continued Contributor
Continued Contributor

How to retrieve the Name field from my private form

Hi everybody,

 

I have a little problem with Automate and Forms.

I have created a group forms and  tick Only members of my organization can answer.

 

I create a flow because I want to get the answers in teams but i can't add the column Name.

 

In my excel forms i have the column Name

name.png

 

but i can't choose Name in automate

 

not name.png

I wonder if this is normal behavior and if I have to add a Name field to my form ?

I also tried another solution to avoid creating a flow by ticking receive a mail notification of each response but but I never get any e-mail.

 

I hope to be clear. Thank you for your help

11 REPLIES 11
WarrenBelz
Super User
Super User

Hi @ALP1 ,

Firstly, I have to tell you that I use Forms and Flow (and SharePoint) a lot, but not Excel often (only for static tables) , so my trouble shooting skill here are quite low.

However I have one thought - is your column in Excel called "Name"? This is generally a "reserved" word and using it can cause issues such as the one you are having.

ALP1
Continued Contributor
Continued Contributor

Thank you for your response.
Yes the Name column is a reserved column because it was added automatically by forms in the Excel file.

Otherwise, I'll make it simpler... I added the Forms connector to my channel.
It's not what I wanted but at least it will be that.

Helpful resources

Announcements
October Events

Mark Your Calendars

So many events that are happening this month - don't miss out!

Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Top Solution Authors
Top Kudoed Authors
Users online (2,387)