Share
Report
18Hi All.
So, I am trying to create this flow that runs every night and goes through the uploaded .xlsx files whose `ProcessingStatus eq 'Not Started'`. After the trigger the flows does "get files(properties only)" - that's where I specify the SP Site and Drop/Document Library.
There are Customer, Operating System and Device Tables in the uploaded Excel Workbooks.
The idea is to go over the Customer Table, grab the info, and create a customer item in the Customer List.
Then go over the Operating System table, grab the info, and create an operating system item in the Operating System List.
The next step would be to go over the Device Table and create a device list item.
The problem is: the device list has a lookup into its owner [the customer] and into its operating system - the flow will want me to pass the ID of the respective looked up items - the id of the corresponding customer and operating system items associated with the device.
However, upon device item creation, I can't refer to the ID of the created customer item and created os item, because I get the error saying I am in a loop. The point is: I do need the loop, since there may be multiple files to process.
I even removed the "apply to each row" action that would sit after "list rows .." and contain the "create item" action, and used an index[just trying the first row only] in the create item actions to try to decrease the number of loops. But that doesn't help either.
Thanks in advance.
All responses (
Answers (
