cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Form 1 + Form 2 --Flow--> Excel file.... Excel File empty

Hello, Everybody.

 

I have a little issue (which I believe I created but I can't reverse it) and I need help or at least an explanation with how I caused the problem.

 

I have two difference Forms.

I got Flow to get the data from both Forms and then transfer to an Excel File:

Apply to each

  Get response details

    Add a row into a table

      -  The headers from the Excel file I created do pop up and I add the dynamic contents from the Forms.

 

Excel file worked.  The data listed with no issues.

 

I began the next phase of my testing which was to go into external testing with others submitting Form responses.  I decided to use the same Excel file.  Instead of having my "internal" data from my own testing listed on the Excel file, I decided to delete the rows that had my data.  At this point, I have not been able to get Flow to add any new data submitted into the Excel file; or rather the Excel file is not accepting new data.  Either way, I'm longer getting the data into one Excel File.  Nothing else has changed (file name and location has not changed).

 

Please help.  Thanks!

6 REPLIES 6
Highlighted
Community Support
Community Support

Re: Form 1 + Form 2 --Flow--> Excel file.... Excel File empty

Hi @AllenW ,

 

I am afraid I did not understand what your issue is.

Could you provide more details or a screenshot to illustrate your issue?

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Regular Visitor

Re: Form 1 + Form 2 --Flow--> Excel file.... Excel File empty

Hi Barry @v-bacao-msft 

 

My goal is to have all the data from two Forms transferred to a single Excel file using Flow.

I have two Forms; each is for a different audience.

https://imgur.com/MVYrhOC

 

I created two Flow "functions," for its respective Form file.

https://imgur.com/siiQnM9

 

I made the commands in Flow.  I know the commands are good because I checked for errors and performed live tests with Form submissions with no issues.

https://imgur.com/jUcvlU3

https://imgur.com/vT6a3BY

 

I performed internal (Alpha) tests with me submitting data to the Forms.  All of the data from both Forms were inputted into the single Excel file as planned.

 

I proceeded with Beta testing using outside inputs (users).  I decided to delete the rows of data (that I submitted from my Alpha testing) [from the excel file].  As users started submitting data via Form 1 & Form 2, the information is not added into the Excel File as before.

https://imgur.com/4Mf2Xi5

 

Allen

Highlighted
Regular Visitor

Re: Form 1 + Form 2 --Flow--> Excel file.... Excel File empty

Highlighted
Community Support
Community Support

Re: Form 1 + Form 2 --Flow--> Excel file.... Excel File empty

Hi @AllenW ,

 

Have you checked the Flow run history?

 

Is Flow triggered?

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Regular Visitor

Re: Form 1 + Form 2 --Flow--> Excel file.... Excel File empty

Hi @v-bacao-msft ,

 

Flow Run history all said, "Succeeded."  The Flow was triggered by someone submitting data from Form.

 

I had a deadline, so I decided to create a new "Excel Survey" file with the same headers.  I edited the file destination to the new Excel Survey that I created.  Afterward, everything was working again.  I don't know how the first Excel file failed.  I'm not sure of its limitations since there were no errors.

Highlighted
Community Support
Community Support

Re: Form 1 + Form 2 --Flow--> Excel file.... Excel File empty

 

Great! Sometimes updating the connection, replacing files, or recreating a similar Flow can solve some problems.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Users online (5,239)