Then we append the owner object to the output array variable. We then build up the owner object using the Current Item (OwnerID) from the Apply to each owner loop, and the output of Select Properties. Next, we use a Select to get the property details for the owner using the output of the Filter array. The full Apply to each owner is below:įilter array takes in the value from List rows present in a table, and filters on the OwnerID equal to the Current Item. Within the loop we filter the items returned from Excel for each owner, then select each of the owner's properties, and build up our objects. Now we can loop over each of the unique owners (using output from Compose Unique Owners). Union(variables('owners'),variables('owners'))

We can use a union expression to remove duplicates, so we have a unique list of OwnerIDs. This will contain duplicate OwnerIDs which we'll remove in the next step. Next, we loop over the rows and append each OwnerID to the owners array. List rows present in a table gets the Excel items. Owners of type array that will hold each of the owners. Output of type array that will contain the final output. Note that all files files uploaded without an account are acessible by a unique URL that is hidden but accesible by anyone, so we recommend you to sign up with an account if you want your files to be private, only your account will be able to access your files.I've built a flow that gets what you're after. We allow time before deleting files just in case you're not done with the data, if you're done with viewing or converting a file and want to delete it right away, you can do it yourself through the API. We enforce a strict access policy and employees or external collaboratorsĪll data is automatically deleted forever HTTPS is enforced for all communications with our server.We follow widely accepted industry standard practices when it comes to security: We understand that some data uploaded might be sensitive, so we ensure that your data is only kept when needed.

We pride ourselves in building software that's easy to use, but security is also our top priority.

Converting excel to json