Convert CSV File to Excel by Using Power Automate
Vložit
- čas přidán 2. 11. 2023
- Convert CSV File to Excel by Using Power Automate
Hello everyone, My Name Is Ravindra, I Welcome All of You on My Channel. In This Channel I Am Sharing My Knowledge on Microsoft Power Platform, Power Apps, Power Automate & Power BI
About This Video: -
In This Video I Am Converting CSV text file To Excel Without Using Premium Connector in Power Automate, And Also Without Using Office Script. Csv Text File Will Convert By Power Automate Dynamically
Disclaimer
video is for educational purpose only. Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for "fair use" for purposes such as criticism, comment, news reporting, teaching, scholarship, and research. Fair use is a use permitted by copyright statute that might otherwise be infringing. Non-profit, educational or personal use tips the balance in favor of fair use.
There is lots of hard work behind it, I think you know it's better ❤️
==================================
🤝 Let’s connect on social:
🔗 Ravindra Jadhav LinkedIn: / ravindra-jadhav-powerp...
For More Information Connect on Different Platforms-
linktr.ee/jadhav_ravi_oo7
But if record is 3500 rows then its take too much time
Hi Ravindra, thanks for sharing, this is very helpful! But I want to check with you that if my file is dynamic contents, in Meta Data step, what should I put instead? In my understanding in the way that shared in video example is the static contents? Thanks in advance!
Good Question, create sequence and by using apply to each perform that select action dynamically
Good 🤩
Thanks 😋
@@jadhav_ravi_oo7 I am facing issue while loading excel file (Chinese special characters) to SQL DB (Sink)... Source Preview is working fine but in DB it is getting stored as "????" Can you help here?
Hello Ravindra, thanks for the video, it works quite nicely :) I'm now just struggling with one issue... I've got 290 rows in the csv file, but the flow now only copies the first 100 rows from the csv and then loads until timeout. Any suggestions?
Use error handling in power automate
Hey Ravindra
I followed your instructions but got this error
Unable to process template language expressions in action 'Range' inputs at line '0' and column '0': 'The template language expression 'outputs('Mapping')[sub(length(outputs('Headers')),2)]' cannot be evaluated because array index '28' is outside bounds (0, 25) of array
how to fix ??
at 28th Line Null Value Is Presents That Why You Get This Error
I have to tatal 26 columns.. headers are updating but values for 3 columns not updating.. any suggetion regarding this
used string function to overcome this problem
Nice video. I have one question, what is in the "Columns name" output formula? I don't know what i should write there.
Headers Names of your excel table, or you can kept it blank then also no problem
Thank's for your positive feedback ❤❤
Hi I have created exactly like you said in your video.I'm taking files from sharepoint instead of onedrive but in create table activity im geting "BadGateway" error . kindly help
Hi Ravindra, thank you share video, I followed your step by step to create power automate and ran it. But got error in last step - add a row into table and error is no table was found with name ‘New’
Because , Your Table Was Not Created. Check The Create Table Action
How do you name the Excel WorkSheet? How to copy multiple CSVs as separate worksheets in the same excel file?
You Have To Use Apply to Each Action For Multiple CSV Files To Store Data In Single One, 2. While Creating An Work Book There You Can Provide Name
Re-Watch Video For Good Understanding
Select Bad Request: The 'from" property is of type 'String'. The value must be an array.
Re watch video
Im getting blank column values even though everything is done correctly. Triple checked, and converted to string too
Why did you select 4, but create 5 column names??
Re-Watch Video, And See Steps Before Select Action, See the Split Action
I've got the same error, did you solve this problem?
What about table with more than 100k+ lines
It Will Work. Take Time
Bro while doing select contain invalid expression bro help me
I given same as you mention
Re-Watch Video, And See Steps Before Select Action
last column values are not showing
Increase The Number Of Columns In Your Select Action
Hii did get select expression
Hello, I did the other way not using the select function. How can I show the contents of the last column the second way you showed us? Great video!@@jadhav_ravi_oo7
Were you able to solve it? To have the values in the last column displayed
Hard code the last column name in select action, it will show.