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.mic... Sample Code - github.com/cfe... Blog - clavinfernande...
Пікірлер: 38
@devnx3623 жыл бұрын
Thank you so much for the Power automate series, you explain very well Keep up the good work!
@AnthonyStraine7 ай бұрын
Finding your video has helped me greatly with a problem I was having. Thank you!
@richardcrosland56092 жыл бұрын
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
@richardcrosland56092 жыл бұрын
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
@Rajuthunder2 жыл бұрын
Excellent explanation bro it is really good tutorial video to beginners like me
@clavinfernandes85662 жыл бұрын
I am glad you liked it..
@E1knight2 жыл бұрын
Great job man, Thank you V.much
@DeepDeep-zd5jq8 ай бұрын
Hello clavin very informative video if we want to read a file in parquet format from azure how we can achieve this? thanks
@MohammadAli-ts2ev2 жыл бұрын
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?
@aliyusxАй бұрын
what is 'ScriptParameters/csvContent*'
@mwmstals2 жыл бұрын
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!
@nikitapawar9264 Жыл бұрын
How can I read multiple CSV files from the same folder in Sharepoint?
@DeepDeep-zd5jq3 жыл бұрын
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.
@tusharmehtadxb2 жыл бұрын
can we able to store csv data directly to sharepoint list, if yes please share url if you have., Thanks.
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.'.
@clavinfernandes85662 жыл бұрын
You should Convert base64ToString, not into base64.
@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
@jerryldavis39444 ай бұрын
@@ebodonell This is still causing issue. The workaround was not successful. Could you let me know If you still get the issue var result = []!;
@shuxialiu81712 жыл бұрын
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!
@clavinfernandes85662 жыл бұрын
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.j58152 жыл бұрын
I have the same error, however apparently you can ignore that error it works anyway!
@BroccoliBobTheGOAT32 жыл бұрын
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?
@richardcrosland56092 жыл бұрын
this could be if your csv has , in the data somewhere.
@SJ-kd4rw3 жыл бұрын
Hi , I have tried but i am getting some hexadecimail type code output from compose like this --PK
@sriranjani68763 жыл бұрын
am also getting like that what should i do?
@iamdeepshekhar2 жыл бұрын
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'])),',')
@marcmalacaso37622 жыл бұрын
Good Evening, is there a similar process that will work for converting from UTF8?
@marcmalacaso37622 жыл бұрын
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
@saratchandra73883 жыл бұрын
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.
@clavinfernandes85663 жыл бұрын
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/ .
@saratchandra73883 жыл бұрын
@@clavinfernandes8566 we don't have developer version in excel
@clavinfernandes85663 жыл бұрын
@@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
@michaelbauer7033 жыл бұрын
where did you get the excel script from?
@clavinfernandes85663 жыл бұрын
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
@iamdeepshekhar2 жыл бұрын
@@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