Power Platform Community Forum Thread Details

I'm trying to create a flow that automatically adds a row to a number of different files, based on a number of things.

Trigger: When a file is create (properties only)

Then I have a step to list the rows from a file that already exists - this is a file that provides a list of all folders where the files are, these files need a row added.
>
Get tables - get tables from the new file that has been created
>
For each - for each table
>
List rows present in table - list rows present from the tables

I then what to add these rows to files saved on SharePoint.
The rows from the new file have a column with an ID. This ID is listed in the file mentioned above after the trigger, along with the document library where each of these files are saved - columns in file ([ID number], [Document library], [File name]).
I'm stuck here - everything I try fails. I can't seem to pick out the files that need updating.

I have probably confused anyone reading this by now. This is what I'm trying to do.

I get sent an email on a regular basis with lots of data for different site ID's. I have a flow that automatically saves the file that comes in, but what I really need to do is add the relevant row for each ID to a standalone file for each ID. So that a full history record is created for each site ID.

So if the incoming file has 10 site ID's on it, the flow needs to find the relevant documents (file name would be "ID & site history" eg. AB12345 site history) and add a new row of data from the incoming file.

Categories:

Building flows