I have an Azure Logic app which picks a file from the Sharepoint site. In the next step, I want to parse the file contents to read them line-by-line and to pass each line in an Azure function I have already created.
At this stage I am unable to fetch and loop through each line of the file. I can get the complete file only.
Any suggestion on how to achieve this?
As of now there is no out-of box connector or function in LogicApp which parses a CSV file line by line. You can always vote for new features feedback.azure.com/forums/287593-logic-apps?query=CSV
You will have to pass the whole content to the Azure Function that you already have and perform the necessary operation on it
Or
There is a CSVToJson connector available in LogicApps github repo to use
https://github.com/logicappsio/CSVtoJSON
Not officially supported but should be able to use it.
Currently, there is a feature is Azure Logic App which can read Excel file from the given location.
Take a look at this blog - https://www.pmichaels.net/2018/04/22/what-can-you-do-with-a-logic-app-part-two-use-excel-to-manage-an-e-mail-notification-system/, it's written pretty well and should give you a heads-up about using the feature.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With