Power Platform Community Forum Thread Details

Use flow to select Hyperlink, download and create a file in one drive

I would think it is possible to add data to an existing file but there are lots of details that are required. thinking about it for my flow, i'd probably save it to One Drive, then convert it to a table, then id list rows and put specific filter in that does a match. then compare it against an existing table data and add any that dont exist. (this could be one method) the other could you just get the file content add into the file, then run remove duplicates (using excel macro?). all depends on what your files look like and structure. Power Automate really likes Excel Tables and it makes it easier to get specific data sets. I have a formula for creating a dynamic table as well that i use as i have a program that takes a file and creates a table based on used rows. so this is also possible.

I'll try and detail it out as best as possible for you. This is what i did and this is specific to sales data from a specific retailer.

Thats the whole flow. here are the details

Split Email function

Split(outputs('EmailBody')?['body'], outputs('Enter'))

Select

From- this runs through each line and assigns a number

range(0,length(outputs('SplitEmail')))

String -

outputs('SplitEmail')?[item()]

Position -

Item()

Filter array, then searches each string and finds "Report Name". the email sender actually sends 2 emails. one for inventory and one for sales. i run the same flow but just have a condition to write different files.

Find Position - purely returns the position i added in the select statement of that line.

URL - uses the position of "Find Position +1" so i have the right line. then splits that specific line.

outputs('SplitEmail')[add(outputs('FindPositionURL'),+1)]

Remove Brackets - cleans up the URL so its usable

replace(replace(string(outputs('URL')),'[',''),']','')

Condition - does a search for specific words (As mentioned i use this flow for inventory and sales files. so it decides where and how to copy the files.

Here is the saving and creation part.

Upload file from URL - takes the Brackets remove output (URL Cleaned up) and downloads the file from that link. then saves it to the URL in one drive. (Backend sharepoint).

The next steps are to copy that file from one drive and save to sharepoint. i do this 2 times. one for current week and one for historical. the difference is one overwrites and one creates new file name.

This is important because on sharepoint, we automatically have our reporting tool read the file in, this essentially refreshes the data / appends data. the historical is purely for tracking purposes and make sure we track each week.

The last step is to take the received emails and move them to processed this is just so i know that emails are working.