So you have an excel file, with a lot of rows and one column with a hyperlink to a supporting document.
Just for clarification as the term is overused (in general not by you) what is an MS List to you?
A SharePoint List, A pure MS List, what?
The answer however is yes. Now I am going to assume you mean a SharePoint list.
1. You would Schedule to flow to run ever so often
2. You would have a row in the Excel that represents your unique id for that row
3. You would use List Rows Present in a Table, to loop through all the rows
4. You would check first to see if that row already exists, just in case of updates
4a. If it does NOT exist, in the No Side you would:
----Grab the Data and put it into the list
----Grab the Link to the file
-------Grab the File Content using the Link from the previous step
-------You would use the Add Attachment Action OR you may need to use the HTTP SharePoint Action if its a large attachment.
---------Personally I would have a row in the Excel that is simply an "Imported Status" where after you did the previous steps of creating the row
and adding the attachments, you would update the Row to let everyone know it was completed.
This would allow you to write the SharePoint List Row ID value into the Excel so now you have them linked both by the Excel unique row id AND the
new ID from creating the record.
That is how I would do it. I believe this should answer your question and if so, if you could Mark as Such and Maybe a Like.
If you have specific questions as you build it, I'd suggest adding a new question, link to this question and feel free to "At" me or whomever so we can review and help you get it correct :-)
Cheers!
