You’re offline. This is a read only version of the page.
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!
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.
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
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...
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!
#1
WarrenBelz
146,524
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,906
Most Valuable Professional
Share
Report
All responses (
Answers (
