Missing Excel data in form filling

[VikashKhakholia]

Hello

I have build a flow to read an xlsx file with few rows and columns and save it to an array exceldata. Now I want to fill each row data into some form and I am using for each loop to do the job.. Now the loop is working fine and filling all data.. But to my surprise, at the end when I verify the  filled forms, everytime I am finding that some or the other few rows are missed to be filled... it is happening everytime and I have added multiple wait durations, still the same error.. can anyone advice any reason??

[FLMike]

Hello,

You first said that the loop is working fine and filling all data. But the you said its not, since some forms and rows are missing data. Then you mention its the same error, but I don't see any error messages.

Can you clarify please if the loop is or is not filling all the data? And can you be a little more clear on what its not populating? Is it always the same things missing? How many forms, how are you using the loop to populate the data etc?

Have you validated by looking at the array, that in fact the data is IN the array, or if not does whats missing in the array, match whats missing in the forms?

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

[VikashKhakholia]

1. there is no error message from Power automate.

2. whichever data the loop is filling, its filling it all correctly.. 

3. Is it always the same things missing? -- No.. random rows are missing.

4. Same form is being filled in a loop with each data row.

5. I have checked the array and it is complete.. there is no error in reading the excel. The data is complete in array exceldata.

I know its difficult to understand this and its sounds weird too.. but thats what is happening to me.. even I am also surprised how can some random row data is missing in the form.. 

To check the missing, I have set a command to write in excel in the last empty column of each row after every loop iteration, that the row is read and filled. and the result is every row has the message written.. but when checking in the form filled data, its still some random row is missing.. its very weird.