cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
smehro
Helper I
Helper I

Save user responses like Google Forms

Hi there,

 

I wish to save user responses for multiple choice questions as one can do in Google Forms. 

I tried using Excel online (Onedrive) in PowerApps to call for an action and save the response. However, it's does not work.

 

Annotation 2020-08-19 143515.pngAnnotation 2020-08-19 143544.png

1 ACCEPTED SOLUTION

Accepted Solutions

oh @smehro  this is because when the flow runs it means one row so if you what to modify the same row but another column you need to use update row action. To do that you need to create an ID as identyfier of user to add into KeyColumn

 

https://powerusers.microsoft.com/t5/Building-Flows/Form-Submission-Update-Row-in-Excel/m-p/286693

 

https://powerusers.microsoft.com/t5/Building-Flows/Update-row-in-Excel-after-listed-rows-have-been-f...



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

View solution in original post

6 REPLIES 6
renatoromao
Super User
Super User

Hi @smehro ,

 

Inside your Power Virtual Agents topic, it's right!

 

But inside the Power Automate, you create a card that is called "Create a table" (Excel connector). You need to fill all inputs that Power Automate show for you.

Below this card, you need to create a new card/action called "Create a row" (Excel connector) to connect with your table created above this new action. And inside the value of inputs, you can insert the Power Virtual Agents input.


Did I answer your question? Mark my post as a solution!
Thanks!

Renato Romão,

Connect with me here 😉

Power Virtual Agents course (+2.760 students) : English | Português

Great! So it worked now! Thanks @renatoromao (see 2 responses in column 1)

 

However, Let's say I have 100 users for my survey and I wish to save their responses individually like Google Forms (see attached image, where one row represents one user and columns represent their responses.)

 

Is it possible to do this here? 

 

fff.pnggot.png

hi @smehro  if you need to do this please create an excel file with a table and headers. Then you can can add the action add rown into a table.

 

Plase see https://www.youtube.com/watch?v=hjkftEtPPCg

 

 



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

Hi @smehro ,

 

Yes, you can create manually the headers inside your Excel file.

See the official video of Microsoft channel: https://www.youtube.com/watch?v=uDcdomNwuHg

 

And you can export the data using the Conversation Transcripts:

https://docs.microsoft.com/en-us/power-virtual-agents/analytics-sessions


Did I answer your question? Mark my post as a solution!
Thanks!

Renato Romão,

Connect with me here 😉

Power Virtual Agents course (+2.760 students) : English | Português

Hi @renatoromao @ChristianAbata 

It worked with manually creating the headers. However, the operation of adding a new row creates new rows. However,  I want the user_response in same row but different columns. So, for this I also tried the adding key column action, but it simply does not work. Can you identify my mistake?

I am attaching the screenshot for clarity. The screenshot I shared from Google Forms is what I wish for.

Thanks for your help!

Annotation 2020-08-20 194122.pngAnnotation 2020-08-20 1941483.png  

oh @smehro  this is because when the flow runs it means one row so if you what to modify the same row but another column you need to use update row action. To do that you need to create an ID as identyfier of user to add into KeyColumn

 

https://powerusers.microsoft.com/t5/Building-Flows/Form-Submission-Update-Row-in-Excel/m-p/286693

 

https://powerusers.microsoft.com/t5/Building-Flows/Update-row-in-Excel-after-listed-rows-have-been-f...



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

Helpful resources

Announcements
Canadian Cloud 2022 768x460.png

Register for a free PVA chatbot creation workshop.

Learn how to respond rapidly to your customers and employees at scale, using intelligent conversational chatbots.

MS Build PVA Carousel 768x480.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development for Power Virtual Agents.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Users online (1,987)