Share
ReportHere's my flow:
1) Flow triggered in powerapps. Email parsed to Flow. OK.
2) Get items from: sharepoint list. OK.
3) List rows present in: sharepoint excel doc. OK.
4) Apply to each: excel row, add sharepoint rows to sharepoint excel doc. OK. (The excel table populates fine.)
5) Get file metadata: excel doc. OK.
6) Get file content: excel doc. OK.
7) Get file metadata: excel doc. OK.
8 ) Send email (v2) with excel doc as attachment: Excel doc has several rows missing from sharepoint list.
Why might this be? I feel like I have tried everything (delays, isolating individual steps etc). I do note that when I removed steps 1-4, and pre-populated excel doc with the same info, it successfully sent all rows into the resulting excel attachment. So this leads me to believe that the 'get file content' task is being run before the excel doc has been fully populated...but adding a delay before the 'get file content' task, even of 30 seconds, and even for a small number of rows (eg 3) did not solve this!
Could the underlying cause be that the flow is attempting to run certain tasks in parallel, and if so, is there any way to prevent future tasks being run before present tasks are complete? I have tried initialising and evaluating variables to try to accomplish this without success-is there a better approach?
It does not matter whether the list starts off with only, say, 5 rows, or 50; some rows are always missing.
Very confused!
Any help would be much appreciated-thanks.
All responses (
Answers (
6,625
