Get Rows from CSV file using Power Automate

The tutorial shows how can you Get Rows from the CSV file using Power Automate and Excel Script.
This is my solution to the Power Automate idea - powerusers.microsoft.com/t5/P...
Sample Code - github.com/cfernandes-muhimbi...
Blog - clavinfernandes.wordpress.com...

[@devnx362]

Thank you so much for the Power automate series, you explain very well
Keep up the good work!

[@user-ef3hk9gc4y]

Finding your video has helped me greatly with a problem I was having. Thank you!

[@E1knight]

Great job man, Thank you V.much

[@richardcrosland5609]

Great video explanation of how to parse a file. Thank you for sharing, its helped me alot!
My next task is to work out how to only output if a row has a certain value
So in your example, only if a certain grade was achieved

[@richardcrosland5609]

Ok, so worked that out pretty quickly.
To do that I embedded a condition ahead of the compose stage. In there you can set an "is equal to" condition

[@MohammadAli-ts2ev]

Thank you for the informative video.
In Power automate/Flow, how can we set the value of cell A2 (of Excel Online for Business) to a variable?

[@Rajuthunder]

Excellent explanation bro it is really good tutorial video to beginners like me

[@clavinfernandes8566]

I am glad you liked it..

[@mwmstals]

Hi Clavin, i have a follow up question. This video was very helpful in understanding Power Automate. In this example you create a pdf file. But would it also be possible to create a Excel Table or Sharepoint list from the CSV file? Thank you so much!

[@DeepDeep-zd5jq]

Hello clavin very informative video if we want to read a file in parquet format from azure how we can achieve this? thanks

[@tusharmehtadxb]

can we able to store csv data directly to sharepoint list, if yes please share url if you have., Thanks.

[@DeepDeep-zd5jq]

Hi I have List row collection form CRM 5000 batch records in do until loop I want to merge all records and create CSV file in azure blob.but unable to merg all collection of 5000 batch records in Ms flow.

[@nikitapawar9264]

How can I read multiple CSV files from the same folder in Sharepoint?

[@shuxialiu8171]

Thank you for sharing! I’ve tried the office script, it returns an error for var result line, saying “can’t infer the data type of this variable. Please declare a type for the variable. “ Any suggestion for the solution? Thanks in advance!

[@clavinfernandes8566]

Can you please confirm if you have used the code - github.com/cfernandes-muhimbi/Blog-Resources/blob/main/Get%20Rows%20from%20CSV%20file%20using%20Power%20Automate/Get%20Rows%20from%20CSV%20file%20using%20Power%20Automate.js

[@adamt.j5815]

I have the same error, however apparently you can ignore that error it works anyway!

[@marcmalacaso3762]

Good Evening, is there a similar process that will work for converting from UTF8?

[@marcmalacaso3762]

This is how my data is formatted in the CSV file
"LastName, FirstName","MMM D, YYY","MMM D, YYY",Hourly,task,hours,area,"MMM DD, YYY","MMM D, YYY",employeetype

[@saratchandra7388]

HI,am using automated flow because my file is created in specific folder in sharepoint. After it is created my file is csv then I need to convert it into xlsx format.my csv in excel format.not having premium license.could you provide possible workaround am trying hard to get this done.Thank you in advance.

[@clavinfernandes8566]

Hey Sarat, Using Excel Script you cannot create a new file but you can for sure parse rows and fill them in an existing XLSX file. If you want to directly convert the file CSV to XLSX then you will have to use a third-party connector e.g. www.muhimbi.com/ .

[@saratchandra7388]

@@clavinfernandes8566 we don't have developer version in excel

[@clavinfernandes8566]

@@saratchandra7388 You can ask your Office 365 Admin to activate Office Scripts for you. docs.microsoft.com/en-us/microsoft-365/admin/manage/manage-office-scripts-settings?view=o365-worldwide

[@VikashKumar-iq1nj]

I am trying same steps but getting this error while converting into base64: Unable to process template language expressions in action 'Compose' inputs at line '0' and column '0': 'The template function 'base64ToStringoutputs' is not defined or not valid.'.

[@clavinfernandes8566]

You should Convert base64ToString, not into base64.

[@SJ-kd4rw]

compose function: base64ToString(outputs('Get_file_content_using_path')?['body']['$content'])

[@clavinfernandes8566]

Are you using a CSV or an XLSX file?

[@robertcamp3155]

I’m getting “
” on the last value of my parsed data. It seems like some component of the script is causing. Anyone see the same thing or know why it’s happening/how to fix it?

[@richardcrosland5609]

this could be if your csv has , in the data somewhere.

[@SJ-kd4rw]

Hi , I have tried but i am getting some hexadecimail type code output from compose like this --PK

[@sriranjani6876]

am also getting like that what should i do?

[@iamdeepshekhar]

This is because you must be using the xlsx file type. Use CSV and use this compose function concat(trim(base64ToString(outputs('Get_file_content')?['body']['$content'])),',')

[@michaelbauer703]

where did you get the excel script from?

[@clavinfernandes8566]

Hey Mate, You can ask your Office 365 Admin to activate Office Scripts - docs.microsoft.com/en-us/microsoft-365/admin/manage/manage-office-scripts-settings?view=o365-worldwide

[@iamdeepshekhar]

@@clavinfernandes8566 Hi Clavin, as checked the Office Scripts is activated(for Everyone) Yet I am not able to see the Automate Section in the Microsoft Excel.
Please suggest

[@jallabalaram4331]

[4, 7] Office Scripts cannot infer the data type of this variable. Please declare a type for the variable.
This is the error Im facing while running the script

[@ebodonell]

If anyone else gets this error add an ! after the square brackets on the result var

[@jerryldavis3944]

@@ebodonell This is still causing issue. The workaround was not successful. Could you let me know If you still get the issue
var result = []!;