cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ALP1
Helper V
Helper V

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

1 ACCEPTED SOLUTION

Accepted Solutions
WarrenBelz
Super User III
Super User III

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.

View solution in original post

11 REPLIES 11
WarrenBelz
Super User III
Super User III

Hello @ALP1 ,

I share your frustration on the limited amount of data the MSForms connector brings back, an example being the result of Tests.

I am a little confused with your question however as your screenshot shows the fields from Forms, not the Excel table you are trying to write to. What does the Excel file panel look like?

Sorry if I wasn't clear.

Here's a screenshot of my excel form

 

new_excel.png

Here's a screenshot of my forms

 

my forms.png

 

As you can see, I didn't add the Name field because it's a private form.

 

I don't know why but I'm sure you'll tell me I have to add the Name field to the form 😫

Hello @ALP1 ,

I meant the Flow screen where you call the Excel form.

MS Forms will only display the fields from that form (or am I missing something)?

Oh sorry

flow1.png

It's a group form, i insert my form ID to retrieve the data.

 

Flow2.png

You are posting to Teams - where do you connect with the Excel form to tel Flow to look for the field?

Sorry for the delay.

 

I add an excel action to my flow like this

 

 

flow3.png

I can now add the Name field as we can see.

However, this is not good since in my team this lists all the records contained in the file excel

 

teamspng.png

 

 

Hi @ALP1 ,

Your screen shots are too low resolution to read.

So that I can try to answer you properly, can you please detail, step by step, exactly what you are trying to do in the process (from where, to where).

Hi WarrenBelz,

 

First of all, I want to thank you for support that I appreciate.

For the screenshots, if I click on them they look good for me and  I can zoom in on them.

 

Here's the process.

I have a form that employees have to fill out.
As this is an internal form, the name field is automatically entered into the excel file corresponding to the form.

I didn't take care to add a Name field to the form because it's useless.

 

Then when an employee responds to the form, I would like his answers to appear in my Team channel. It'll be easier for me and my team

 

So I create a flow with automatoe

 

So here's the process

1. I ask to log in to my group form
2. I ask to collect the answers of this form
3. I ask to publish the answers of this form in my team's

 

 

So far everything works perfectly except that I can't recover the name field of the excel file.

As a advised, I added the excel connector that allows me to recover the name field.

I used the action List rows present in a table but I can not set it because every time I add an answer to the form, I have the answer that appears in teams but also all the previous answers.

So, if I have 10 records in the form, it's the 10 records that will appear in teams plus the last record

 

First step - The employee responds to the form

 

01.png

Step Two - The Flow Starts

 

02a.png

02b.png

 

03.png

Step Three - Answers appear in Teams

 

04.png

As you can see, it's all the answers in the excel file that appear in my channel.

How to get that last record ?

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Top Kudoed Authors
Users online (48,213)