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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / MS Forms --> Google Sh...
Power Automate
Unanswered

MS Forms --> Google Sheet "Successful", but not...

(0) ShareShare
ReportReport
Posted on by 4

I have four Microsoft Forms that I want to organize in one Google Sheet to share with those who respond. So I set up four "Forms to Sheets" flows to add rows to one of four different "worksheets" (one tab for each form). After I set them up, I tested them by responding to the forms and it worked fine. But now others have been responding and only the first worksheet/flow/form is recording responses, even though they all said that the flow was successful... Can someone help me figure out what's going on?

 

 

I put two of the setups/"success" pages below: The one that's working is "CAN-" and one of the one's that is not working is "DRI-". "CAN-" is the first worksheet of my Google sheet and "DRI-" is the second (and then I have two others not pictured). I only included these two for simplicity purposes and because these are literally the exact same question with the exact same setup and I didn't do anything different in their associated worksheets. It's bizarre to me because they all worked when I tested them, but now only one is. TIA!

 

DRI- Setup.PNGDRI- Success.PNGCan-Setup.PNGCAN- Success.PNG

Categories:
I have the same question (0)
  • Christopher S Profile Picture
    Microsoft Employee on at

    Hi @santalin22 

     

    Can you please check on a run for the Flow that is not adding the data that is succeded and check if actually the insert row action is fine?

     

    Best Regards

    --

    If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions help users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

  • santalin22 Profile Picture
    4 on at

    I am so sorry, but could you rephrase that? I don't understand what you want me to do.

     

    Oh, and update: "CAN-" isn't working either now...

  • Christopher S Profile Picture
    Microsoft Employee on at

    Hi @santalin22 

     

    On the Flow execution history, you can open a run that shows as "successful" but that you can identify that didn't updated the file and paste a screenshot of the action in that specific run to check if it actually succeeded.

     

    Best Regards

  • santalin22 Profile Picture
    4 on at

    Oh my god, I'm so dumb... So I was making formulas and such on the Google Sheet where the responses were. I ended up just making separate worksheets for my formulas and the responses, thinking that might be the issue. Then, I was just scrolling through one of the old responses worksheets (now my formula worksheet), and I realized that waaaaaay the heck down the sheet, there were the responses, still being recorded, but now out of sight. So it was working all along, I just couldn't see it. 

     

    Anywho, thanks for the help!

     

    Searchable text for the next person with this issue (made based off what I was trying to Google): My Microsoft Forms to Google Sheets flow said it successfully entered the responses/executed the flow, but stopped showing up in my Google Sheet. Turns out, they actually were being recorded, but halfway down the sheet because I started making formulas to analyze the responses at the top of the sheet. Solution: make a separate worksheet for the flow to put the responses and use array formulas in a separate worksheet.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 1,027

#2
Valantis Profile Picture

Valantis 815

#3
Haque Profile Picture

Haque 630

Last 30 days Overall leaderboard