Power Platform Community Forum Thread Details

Dear all,

I have a txt file in the following format

247306,"http://removing domain name:7001/im/viewattachment/GDM%20-%20Tkt%2012870%20Item%20reservation%2014Jan2022_Completed.xlsm;jsessionid=2AA23A236DB99CFA45F738B50EF66778?issue=247306&attachment=GDM+-+Tkt+12870+Item+reservation+14Jan2022_Completed.xlsm&attachmentID=364615&fieldID=-16"
247306,"http://removing domain name:7001/im/viewattachment/2021.12.07%20Lacrima%20Plus%20Aspex%20transfer_Vision%20Care%20PLR%20Form%20-%20Sept%202021,%20Rev.%2004.pdf;jsessionid=2AA23A236DB99CFA45F738B50EF66778?issue=247306&attachment=2021.12.07+Lacrima+Plus+Aspex+transfer_Vision+Care+PLR+Form+-+Sept+2021%2C+Rev.+04.pdf&attachmentID=364526&fieldID=-16"
247305,"http://removing domain name:7001/im/viewattachment/GDM%20-%20Tkt%2012870%20Item%20reservation%2014Jan2022_Completed.xlsm;jsessionid=2AA23A236DB99CFA45F738B50EF66778?issue=247305&attachment=GDM+-+Tkt+12870+Item+reservation+14Jan2022_Completed.xlsm&attachmentID=364614&fieldID=-16"

Basically it has the file name mentioned first i.e 247306 and then the link is mentioned within double quotes. I would like ms flow to iterate through all the file names and save each file name as a list item. If there are two or more links per file name then the links should be saved to the same list item. each lines are separated by a line break.

Is it possible to do the above actions using "get file content using path" SharePoint connector. Unfortunately i do not have a premium connectors enabled in my organization

Thanks

Categories:

General topics