How to Import CSV Data to SharePoint List with Power Automate | Tutorial

This demo is awesome🤘! It shows me how to import CSV data into SharePoint List with Power Automate flows in a very clear and easy way. I love 😍 how the video explains every step of the process, from triggering the flow to filtering the data and using expressions. The tips on how to handle empty values and speed up the process are very helpful too. Error handling FTW. I also appreciate how the video covers importing multiple CSV files at once, which is something I always wanted to learn. This demo is very well structured and informative, thank you 🙏 for sharing it!

[@RezaDorrani]

Wow! So happy to hear the appreciation for each and every facet of the video 💕 Thank You so much. Im glad to hear that error handling part was useful.

[@borien]

Thanks so much! This was clear, concise, and very helpful. I especially appreciate you structuring the exercise in such a way that we check and understand the output of each step. Thanks!

[@RezaDorrani]

Glad it was helpful! Thanks so much for watching.

[@luizfurtado3624]

That is really great, I had a similar use case recently! Just a small piece of advice for the use of concurrency: I had a large batch of data to import (10K plus lines), but I need to implement some data transformation for a couple of fields from my csv. After a couple of tests, I realized that some SharePoint fields had the wrong value, and these are actually mixed values from other lines in my spreadsheet! When I ran the same tests without concurrency, all went well. I'm guessing (and this is a very wild guess) that the use of concurrency somehow makes Power Automate keep some values from the transformation action between transactions. So, I ended up by decoupling my flow into a child flow that receives some smaller batches of data to work with the data transformation and SharePoint insertion, and just returns to the main flow a list of items created with success or any errors that might occur with the insertion. So, my parent flow runs with concurrency, while the child flow runs without it. But here also I understand that, for this scenario, perhaps Power Automate is not a good fit, but it worked at the end of the day.

[@RezaDorrani]

Thanks for sharing your scenario. Only known limitation with concurrency is using variables within it.

[@luizfurtado3624]

@@RezaDorrani yes, but I used some compose actions to create work with my data transformations, but still got a similar behavior. But still going to look forward, this project is not yet over! :) Thanks for always sharing your knowledge and findings!

[@Dustin.Stubbs]

Thanks this was very helpful. I was getting a that was messing things up for me. I resolved by switching the Split Array Expression to skip(split(outputs('CSVData'),decodeUriComponent('%0D%0A')),1) which removed the and This also allowed me to get rid of the "New Line" step.

[@RezaDorrani]

Great

[@anoopt6236]

Thank you both @RezaDorrani and @Dustin.Stubbs😊

Thank you so much, I fight with the problem a long time.

[@DanFirelink]

Your content is extremely well done. This guide was exactly what I was looking for and very easy to follow. Thank you! I only have one question about your description column. How would you handle change the flow if someone had entered comma's in that field?

[@RezaDorrani]

You're very welcome! Issue is with commas. You would need to ensure the data does not contain commas. I showed that in video, where prior to importing the data, I do replace all commas with spaces.

[@DanFirelink]

@@RezaDorrani awesome, thanks for the quick response!

[@the_power_ride]

Very usefull video ❤ Thanks man

[@RezaDorrani]

Glad it helped

[@TheMitrovic]

Hi Reza, thank you very much for video. I have followed all steps but i have issue - every time run the flow it duplicates data five times from excel to sharepoint. Do you maybe have any idea about it? Thank you in advance

[@RezaDorrani]

I have not come across the mentioned issue and hence not sure what the cause could be. I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com

[@frenamakenson9844]

Hello Reza, Thanks again for Sharing, with the community Would it more Simple that Microsoft Make A "STANDARD" connector to Pass CSV to Json... And Json to CSV This is so Easy todo with an Azure function, i just have it Availlable for my Org as a Custom Connector the Issue, it's Premium... This is one of the most request functionality in the Platform, Third Party company have it Availlable, but Premium for a such Basic Functionality

[@RezaDorrani]

Yes I agree with you that it would be nice to have such an action. Azure function is certainly an option. Most of the video requests I get are to build things showing standard connectors.

[@rachelwu2933]

Thank you for this!! Your video is always so informative and concise. Once the CSV file is imported, is there a way to keep the file updated with any new updates? would it be the same as how you update excel files?

[@RezaDorrani]

It is a one time import. It does not keep info current.

[@arvindbhat8659]

What an amazing video! As always Reza picks up real practical scenarios. This one had so many e.g. within CSV import. Gives such clarity and sense of direction for people like me. Wish to keep learning more from you!! Best wishes!!!!

[@RezaDorrani]

Glad you liked it! Thanks so much

[@iyengar007]

Thanks my Virtual Guru. Iwas able to replicate. However, Let's assume that I have a column "Name" where the data is Lastname, First name. In such case, when we split with "," the name column retains only lastname and text after "," are not captured.. Something to think about? Will wait for your directions. Sire

[@RezaDorrani]

Welcome! Check video again. I do talk about data having comma.

[@elizabethtrent]

I truly appreciate the way you explain this, step by step, in a way that I can understand and troubleshoot my flow. This is incredibly helpful; I learned something today. You are an excellent teacher, Reza!

[@RezaDorrani]

Thanks so much

[@calebstucki]

Really like your videos and appreciate your dedication to helping people. Keep up the good work and don't worry about the haters!

[@RezaDorrani]

Thanks so much. I only worry about maintaining the quality of my content. Haters if any are ignored.

[@anjanchidige]

Very common use case and very well demonstrated with exception handling. Take a bow Reza 🎉

[@RezaDorrani]

Thank you so much. Glad to hear the video covers a common scenario.

[@datadragyn]

Explained extremely well 👏 👌 There are so many gold nuggets of knowledge I'm going to map it out for myself. Remove empty strings , Remove header row, filter array to add only open, split, split, replace, so much goodness 😁

[@RezaDorrani]

So glad to hear this! I was hoping folks realize this video is a lot more than just importing data. Thanks so much 😊

[@datadragyn]

I literally just joined as a silver member to your KZbin channel. I have never in the history of KZbin ever enjoyed learning from a channel so much in my life. You are the only KZbin channel I have ever signed up for a membership to. That's how much I believe in you and your teachings.

[@RezaDorrani]

@@datadragyn Thank You so much 🙏 for the support & welcome to Memberships. I will keep trying my best to produce the best content possible.

[@lindawood1176]

Thanks for your extremely helpful video! I appreciate the step-by-step instructions and all the tips you provided. I have a question for you: If the SharePoint list has calculated columns, will those columns automatically be populated for each row created by the CSV import?

[@RezaDorrani]

Most welcome! I have not tested with calc columns but my guess would be yes.

[@lindawood1176]

@@RezaDorrani Thanks! I'll let you know my results when I test this over the next few weeks.

[@lindawood1176]

Yes, the calculation columns automatically populated for each row created by the CSV import!

[@prabhurajaram]

i am so glad to be a subscriber of you, really it means a lot for me, whenever i struck somewhere on my work, firstly i refer your videos, and for sure i get clarity and complete my work. really love the way you create your videos with easy explanations and live runs. thank you so much for your efforts to share your knowledge to others.😍

[@RezaDorrani]

Thank You so much for your kind words 🙏

[@FlorianMitter]

Thx for this Video, it helped me a lot. I only got one Problem. I got a CSV with this string: ; "Ventil R3/4""; because of 3/4" and the resulting "" at the end of this string, power automate seems to use the wrong encoding or something when i save the data to MS Dataverse Table. When i delete the row that contains the R3/4" out of my CSV, the flow works perfectly fine and all data is saved correct into my Dataverse Table. 2,500;"Car";"Light" gets me 2,5 Car Light which is perfectly fine When the string with the R3/4" is ANYWHERE in my data, ALL my data will look like this in Dataverse: 2500 "Car" "Light" Problem: -> 2,5 (two and a half) gets 2500 -> the " before and after each string is not trimmed out Any solution for this?

[@RezaDorrani]

I'm not sure of a solution for this. I would recommend checking or posting your on forums in case someone has done something similar powerusers.microsoft.com/

[@LakshyaGazaresen]

Hey Reza, Great video again and it is really helping me with one of my solutions. But I got stuck in one place, what to do when the field also has comma in it. As in I have a summary field in my CSV which has commas in it.

[@RezaDorrani]

Thats on the of the limitations of this approach as mentioned in video. Data cannot include commas.

[@skim32]

I had an issue with Lookup Columns. It looks like the create item action looks for the lookup column's item ID, instead of the Item Name. So I manually did a vlookup in Excel and manually changed the source csv file to replace the lookup column name, to the ID. And it worked. I am sure there is a smarter and better way to do it in PA.

[@RezaDorrani]

As long as it worked thats good

[@programsinfo8974]

Hi, Reza. Thanks for this video! It helped me a lot. can you plz Explain code in PowerApps to Run

[@RezaDorrani]

Most welcome. This video has nothing to do with power apps :) I recommend posting your query on the forums at powerusers.microsoft.com

[@learningwithyt]

Hi, Reza. Thanks for this video! It helped me a lot. The only thing is that I'm facing some problems with special characters. Those letters or symbols appear as question marks. Is there anything I can do to solve this encoding problem?

[@RezaDorrani]

Best would be to avoid those special characters. You may want to try and see if you could use replace function to remove them in flow.

[@beeepaiva]

Reza, first of all, thank you for all your videos, we all learn a lot from you! One question, in my case I have a Description column and inside of it, the data has a lot of break lines, how can I handle with this break lines inside a column to not split as a new row? Thanks in advance!

[@RezaDorrani]

Not sure how to handle commas and break lines. As shown in video, I ask to manuallu clean up the file prior to importing so it does not have those special characters.

[@mukhayyarmohammed5874]

Very informative content thanks for uploading ❤ If every month one column is added like 'October' then next month 'November' how to deal with this ? If there are Excel files how to achieve the same things?

[@RezaDorrani]

I have no idea about your specific use case. This is something I have not tried. I recommend checking or posting your query on the forums at powerusers.microsoft.com/ in case someone has done something similar.

[@davidwestall7374]

Great video and thank you for the tutorial. Is there a way to schedule the job against a Network Drive? I want to avoid using my OneDrive in the future.

[@RezaDorrani]

Welcome! Im not sure about network drive as I have not tried that scenario

[@jonaskoniger3337]

HI Reza, this is just great content, Love it! One question on a common scenario: How can I make sure to check if an item (based on an ID) is already present in my sharepoint list and thus skip it ?

[@RezaDorrani]

I have done a video on excel import to SharePoint. There I have shown adding or updating items. Same logic applies here.

[@Joker064460]

Hi Reza, needless to say, this is absolutely remarkable! Thank you very much - I literally watch as many videos from you as I can and I have to say, you honestly do an incredible job of explaining everything! Btw, I have a (stupid) question, if you don't mind :) What is the difference between Compose and Initialize/Set variable? Variables are always my pain points because I am just starting out with these tools... Thank you again for the great work!

[@RezaDorrani]

Many thanks for the appreciation! So happy to hear the feedback. I mean this in a good way - "No question is stupid. Not asking questions is stupid" Compose - Treat it as a static variable. Its value cannot be changed later in flow. Also, a compose action will dynamically set the data type based on the value provided. Variable - Must be initialized and is strongly typed (must define a data type). They can be changed later in the flow. I have done a video on variable as well :)

[@ambarish360]

@Reza, you are great as always, I've developed similar to this, with some more additional features like taking a dump of a parent SP list in CSV and then creating a new list in the same site with different list name. But at one place I got struck, while exporting the data to CSV through power automate, what would be the max Row count? And could that be bypassed like how we have option to increase the threshold value?

[@RezaDorrani]

Great! This video is about importing data into SP and not exporting. I have done videos around exporting as well. You would have to paginate through your records to export. Flow is not an ETL tool though. Performance would be an impact for large data sets.

[@priyankagorkhe2870]

Thank you so much. Your video saved me from a big storm actually. Thanks from big heart❤

[@RezaDorrani]

You're most welcome 😊

[@amiturmipurohit4297]

Very informative video Reza. Appreciate for all your hard work in making the videos which are very informative and explained in wonderful way.

[@RezaDorrani]

Thanks so much

[@ericzheng4838]

Always learn something new from Reza's video even if you have obtained the techniques from his previous videos!

[@RezaDorrani]

Glad to hear that! Thanks for watching.

[@JohnHall]

I usually include a check to verify the string of the first row headers ='s the columns I plan to ingest, then error out if it isn't there or has changed in any way.

[@RezaDorrani]

Thats a good tip

[@paddysheeran]

Hi Reza, I have to move data from a csv file into a table located in an .xlsx file stored on SharePoint. There are more than 5000 rows in the csv file which breaches the apply to each limit. is there a way to split the csv into chunks based on row size and then send these to the apply to each action in groups of 5000?

[@RezaDorrani]

Apply to each loop has an option in settings for pagination. You can go upto 100k I think but may need a premium license.

[@paddysheeran]

Yes trying to avoid the premium license, I was wondering if I could chunk the array and use a working array to loop throug

[@paddysheeran]

Also appear to be having a issue with the array filter. when I use "@and(not(equals(item(),'')),startsWith(split(item(),',')?[17],'JST1'))" I'm receiving 4611 records when there should be 4768. I have tried to use @startsWith(split(item(),',')?[17],'JST1') on its own but get an error message "The execution of template action 'Filter_array' failed: The evaluation of 'query' action 'where' expression '@startsWith(split(item(),',')?[17],'JST1')' failed: 'The template language function 'startsWith' expects its first parameter to be of type string. The provided value is of type 'Null'"

[@RezaDorrani]

@@paddysheeran May be but not something I have tried. Flow is not a good option to ETL large amounts of data. You would run into service limits.

[@RezaDorrani]

@@paddysheeran I have not come across the mentioned issue and hence not sure what the fix for your issue is. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

[@siddeshgawande3924]

Great 🎉

[@RezaDorrani]

Thanks

[@Philippaantell1]

This worked perfectly for me until I got to trying to deal with blank values....I used the expression given if(equals(split(item(),',')?[4],''),null,split(item(),',')?[4]) but still throwing up errors "The runtime value '""' to be converted doesn't have the expected format 'String/date'." and I don't have the knowledge to understand why 😞

[@RezaDorrani]

I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com

[@Sese29yt]

Hey, I asked under another video for a similar solution but this seems to be exactly what I needed!

[@RezaDorrani]

I have done so many videos now that I dont event remember them. I cannot guess or evaluate expressions here on chat without trying them out. Best to post your query on forums powerusers.microsoft.com

[@dean7275]

Thank you Reza. Can you please help. Is there anyway I can import a CSV into a Sharepoint DOCUMENT LIBRARY???

[@RezaDorrani]

Welcome! I do not have a video reference on this and would have to try it out to provide guidance. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com

[@edersongarcia855]

Hello, how are you? Would it be possible to import directly from Power Apps into an attachment field?

[@RezaDorrani]

I have not tried that, hence not sure

[@katielux357]

Hi Reza, thank you for this! I have 2 questions: 1. for blank fields, what if the SP Column type is a hyperlink? I tried the if(equals(xxxx,blank but Im still getting the error 2. When I Compose Array, Im getting the following pattern: "\"Dec 2023\",\"123456\",\"NextColumn \", - so quotes and backslash around each column, not a quote at the beginning and end of each line, like yours. this doesnt seem correct. any thoughts? Thanks!

[@RezaDorrani]

1 - I have not worked with hyperlink column type so not sure. 2 - Does not seem correct. Not something I have experienced

[@JonathanBracher-sn2gz]

Hi Reza - another fantastic reel. I have followed this, but my flow crashes, as the .csv file contains a UK date format. PA error details state "...The runtime value '"16/01/2022"' to be converted doesn't have the expected format 'String/date'." Can you kindly help?

[@RezaDorrani]

More than date format, it seems your date has “ next to it. I have not come across this issue so not sure whats the fix.

[@MohammadAli-ts2ev]

❤ Many of my long standing issues got resolved ❤ Thank you Reza.

[@RezaDorrani]

Most welcome! I will be honest I had no intentions of making this video, but the number of requests I received for this video surprised me. I am glad that its helping many.

[@ScolfieldMahone]

Question One: I have a CSV file with inserted pictures in a column cells. I want to transfer the CSV file with the images to sharepoint list. Could you kindly help. Question two: I have a sharepoint list with signature (pen input). How can i transfer the list with the signatures as image attachment to csv or and PDF

[@RezaDorrani]

I have not done any work with pictures being imported or exported from SharePoint. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com

[@wilfinbenny]

Very Useful video.. as always clear and crystal presentation.. I was working around converting the CSV data to JSON schemas and collecting that to PowerApps.. Just one Query.. is it possible to remove duplicates from SharePoint list once the create item action is done.. or just create new items into the SharePoint list by removing the items already created 🙂

[@RezaDorrani]

You are most welcome. You could clear and add items. Or you could update items as shown in this video kzbin.info/www/bejne/q3a9epKYZqymY80si=dTLoER83Lz5t2Tl6

[@hs4279]

that you so much

[@RezaDorrani]

Most welcome

[@achinoy]

Hi. Many thanks for the video. The new PowerAutomate designer does not allow blank enter key (NewLine Compose) in the 'inputs' field. What is the solution?

[@RezaDorrani]

You can swap back to old designer and add it. I have done a video on new designer and shown how to swap back when needed.

[@KenWarthen]

Reza, Thanks for the very helpful video. I have a csv file with 12,00 - 15,00 records I need to import into a SharePoint list each morning. I've got the workflow working, but it times out after about ten minutes . Any work around for such an issue?

[@RezaDorrani]

I have not experienced time out issues. Probably it has some size limit

[@KenWarthen]

@@RezaDorrani I've since learned when testing Power Automate workflows they will display a time out message after ten minutes even though the workflow is still running in the background.

[@RezaDorrani]

@@KenWarthen I have not come across this.

[@aparnasunil3789]

Hi Reza, Is there a way to remove the comma values inside CSV file directly using automate without manually editing it?

[@RezaDorrani]

Im not aware of an option to do that

[@martuce-pc4ic]

Hi Reza! I have a question hopefully you can answer. I have been working on a flow that gets all employees behind a manager in the organization. Now I have the array with Employee ID, Name and Email for all those employees but I need to get all this information in a sharepoint list... Hopefully you can help me

[@RezaDorrani]

I cannot provide any assistance here on chat other than referring to videos or if I can quickly point or hint at something you could try.

[@alejandrolazo3766]

Hi Reza. Thank you for that video. I have a question. I have a CSV file that is on OneDrive, The file is updated with new every Friday, I would like my SharePoint list to be updated every time the CSV on OneDrive gets updated. will this sample work

[@RezaDorrani]

This sample is to only add data not update. I had done an earlier video on add and update data from excel to SharePoint. You may want to check the logic in that one.

[@alejandrolazo3766]

@@RezaDorrani I Raza I need you help. I have to download a CSV file every Friday then copy an replace the same file in OneDrive, The list in share point needs to be update because the CSV file may have new records or deleted records. Which example of yours will help me to accomplish this?

[@RezaDorrani]

@@alejandrolazo3766 I dont think I have a specific video on this. A combination of videos may help. kzbin.info/www/bejne/q3a9epKYZqymY80 is the best reference I have.

[@achinoy]

Hi. How can i handle columns which have multiple lines, , links, and possibly rich text?

[@RezaDorrani]

You would need to use expressions for those. I do not have a video reference on it.

[@amanraj3244]

Please guide if there are multiple sheets in the same file, these sheets need to be stored separately in SharePoint. Example: 3 sheets namely IN, OUT, INVENTORY. Each day it needs to get updated.

[@RezaDorrani]

I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com

[@anshukumari8982]

Great video Reza. I am doing the same thing but using the trigger when a file is created and get file content. The issue is that get file content returns null when the csv file size is 123 mb . How do I resolve this issue.

[@RezaDorrani]

I have not experienced the mentioned issue and hence not sure what the cause for it could be. I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com

[@larrybellamy6114]

Created Date, if(equals(replace(split(item(),',')?[7],decodeUriComponent('%0D'),''),'',null,split(item(),',')?[7])) show the error. Can someone let correct my mistake?

[@RezaDorrani]

Il suggest posting your expression with screenshots on the forums community.powerplatform.com

[@larrybellamy6114]

@@RezaDorrani Just Posted it, LB-12090037-0 and I do not think that I explained transparently at the first time. So here are the details what I was facing with. Handle empty data scenarios in CSV file Column Index [7] = Creation Date 1. 22:45 - split(item(),',)?[7] - no issue 2. 22:51 - if(equals(split(item(),',')?[7],''),null,split(item(),',')?[7]) - no issue 3. 23:35 - if(equals(replace(split(item(),',')?[7],''),decodeUriComponent('%0D'),''),null,split(item(),',')?[7]) - failed, the issue occurred - related to "/r equivalent" where I saw double apostrophes such as if(equals(replace(split(item(),',')?[7],''),decodeUriComponent('%0D'),''), ''then the rest of expression cut off before you clicked "Update" button. I was unsure if the power expression statement is correct since it failed at multiple times. if(equals(replace(split(item(),',')?[7],decodeUriComponent('%0D'),''),'',null,split(item(),',')?[7])) Little help will make the difference. Thank You!

[@matchanista2762]

This is AWESOME! thank you for sharing

[@RezaDorrani]

You are so welcome!

[@shamindranathdas1550]

It’s really helpful, thank you so much sir❤

[@RezaDorrani]

Most welcome!

[@c.mdsalih]

Awesome video as always, Thank you :)

[@RezaDorrani]

Glad you enjoyed it!

[@khandada2719]

Hello, I just became a member but still can't find the link to download the flow. Please help!

[@RezaDorrani]

All links are in community tab. This link is probably disabled since video is over 90 days old but post a comment on community tab where I posted the message and I will share a new link

[@BrianHodge-j3r]

Reza, again another outstanding video and incredibly easy to follow along with. I do have an additional question. What if your source was not a CSV file but rather 'Run a Query against a Dataset'? What modifications would you need to make at the beginning?

[@RezaDorrani]

Thanks! I would have to try it out to know what modifications we would have to make.

[@BrianHodge-j3r]

@@RezaDorrani If you could that would be outstanding. I know there is a limitation of 500 rows with the Run a query against a dataset; and I have workarounds for that aspect. Just having an issue getting the results from the Dataset query into an array so that Apply to each > Create Item will populate correctly.

[@RezaDorrani]

@@BrianHodge-j3r I make videos when I receive multiple requests on a topic. Every quarter I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post.

[@bitokay147]

What if re download the list send it to Hotel company for example they add hotel confirmation numbers and we need to upload it back to the sharepoint list adding only a new field so each user can view their travel info in the list and their hotel confirmation ( new field) will that work ?

[@RezaDorrani]

Not sure as I have not tried this. It will only create new entries (not modify existing ones)

[@luisjimenez8760]

Great tutorial Reza !!!

[@RezaDorrani]

Thank You

[@loulou5974]

hello thanks for the content :::! is it possible to set a key column and to update of remaining ones? part of my datas are created manually in the list and others are uploaded. I need to keep all lines and update informations coming from the new version of the csv file thanks best regards

[@RezaDorrani]

Possible but not something I have tried

[@shaikhfirdos2723]

Amazing video.. Thanks Reza.🎉❤

[@RezaDorrani]

You're welcome 😊

[@kingmrrah4490]

Can you make video on multiple user uploading Csv file and createing new sharepoint list for user to work on via power app?

[@RezaDorrani]

Thanks for the suggestion. I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post.

[@sreejarathish]

Hi Reza seeking your help l want to capture a current date in a mmm format when a new entry is created in the SharePoint list. Can you help me how to achieve?

[@RezaDorrani]

I do not have a video reference on this scenario . I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com

[@desimortal1584]

Thanks Reza, it will definitely help me in my project. One question: will this also work if I want to update existing data on SharePoint list or the upload will create a fresh entry

[@RezaDorrani]

Video description has link to my video on excel which does add and update. Similar logic can be applied here for update.

[@desimortal1584]

​@@RezaDorraniI see it, thanks man! Working on a project and trying to use these functions on my powerapps project. You won't believe how you are helping people in upskilling them. Thanks once again!

[@RezaDorrani]

@@desimortal1584 Most welcome and so happy to hear these videos are useful

[@adarshmc8158]

Reza, if we have commas in the column values this method won't work. Ryt?

[@RezaDorrani]

Right and it is called out in video.

[@atehaa]

Another great tutorial. Thanks mate :)

[@RezaDorrani]

Most welcome

[@magantileelamanogna2055]

can you please make new video on scenario like through long answer question in microsoft form i want to collect email ids separated by ',' and using power automate want to add the mail ids under particular column as for each response one set of multiple mail ids need to be added under one record

[@RezaDorrani]

I make videos when I receive multiple requests on a topic. Every quarter I ask subscribers for topic suggestions on Community Tab of my channel. Most voted topic ideas get added to my backlog. Make sure to suggest this idea whenever the next topic suggestion post is out.

[@alzaimoor79]

Very informative session, thanks for sharing

[@RezaDorrani]

Most welcome! Thanks for watching 👍

[@mohemmadriyazkalva3197]

Great content sir. Real time scenarios covered in very less time. Thanks for sharing. Keep giving us incredible content.

[@gregoirepesenti]

hi reza, you replace manually the unwanted caracter, but can we do it through power automate, with a compose action for example ? something like replace(outputs('CSVData'), ' , ' , ' ; ' ) ? If yes, At what step of your flow would you do this? thanks

[@RezaDorrani]

I have not tried automating it, hence not sure

[@gregoirepesenti]

@@RezaDorrani I can confirm today it works, just after "CVSData", compose with replace(outputs('CSVData'), ',' , ';' ), very nice :)

[@gracesantos9868]

how to deal with escape codes?? mine has it and it seems affecting the splitting of the items...

[@RezaDorrani]

Probably with expressions. I would have to try it out to know how it can be done. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com

[@oluwatobipaul6171]

Thank you Reza. I had a similar project use case but users used Power Apps to upload their documents

[@RezaDorrani]

Great 👍

[@programsinfo8974]

can you plz share how can i used in Powe Apps

[@RezaDorrani]

@@programsinfo8974 This video is specific to flows. I would recommend posting your query on forums at powerusers.microsoft.com

[@StephenRaikes-mm8uz]

would you please show me the full code for the date column where you used replace to remove the return character?

[@RezaDorrani]

The whole sample is shared with members. Check video description for details.

[@Rocks5033]

Great video , demo was very Awesome, please make same video on Excel also

[@RezaDorrani]

I have already done videos with excel. Check out the videos on my channel.

[@Rocks5033]

@@RezaDorrani thank you

[@rajasekare3817]

Thank you for sharing Reza 🙂

[@RezaDorrani]

Thanks for watching!

[@kwajtube]

How would one perform error catching when the email address doesn't;t resolve to a Person? I.e., valid email address, but no SPO account exists for them.

[@RezaDorrani]

Not sure about that

[@kwajtube]

@@RezaDorrani First - I'm new to doing SPO at work, and literally every single thing I've needed to do you have a video doing almost exactly what I need to do - thanks for that! And yes, I'm subscribed. Second, I figured out an answer for me - create a Scope, and inside it put an send an HTTP request to SP that uses ensureUser; makes for a useful Try/Catch

[@mertfatihh]

Hey Reza, Thanks a lot!

[@RezaDorrani]

Welcome!

[@csmtiltm5910]

You are my savior!

[@lxz86]

fantastic array! i like array. 😁

[@RezaDorrani]

Arrays for the win 🥇

[@sayahunzai]

HI @rezadorrani, thanks This is a good approach, I only see one issue: if the text field value itself contains a a comma ',' then how can we handle those cases?

[@sayahunzai]

One option is to replace bit; imagine if ',' needs to be there and the data is coming from a system where no manual intervention is possible, as in my case, how to overcome that, please suggest.

[@RezaDorrani]

As shared in video, you would need to replace it prior to using it. You could use PAD to first replace , in data with some delimiter if automation is needed.

[@xiaoen4262]

Hi Reza, want to ask that i had construct a power automate flow to export sharepoint list data to HTML table and CSV table, and able to send the HTML table and send CSV table as excel file to user via email, do you have any ideas that how we can convert HTML / CSV table to piechart/ bar chart and make it as PNG file and send to user via email?

[@RezaDorrani]

I have not done any work with converting to pie charts or images

[@xiaoen4262]

@@RezaDorrani Hi Reza, Thank you for your replies! Your videos really assisted me. Looking forward to more sharing from you in the future.

[@theintjengineer]

Does it work with Dataverse Tables or only SP Lists?

[@RezaDorrani]

Video is specific to SharePoint but can be customized for any data source

[@pradeepv492]

Great tutorial as usual. We recently had to deal with similar use case. But the problem we faced is there were line breakers and comma's in the data itself and Power Automate considered the data/text after the line breaker as a new row and comma in single column was considered as multiple columns which completely changed the structure and we had to follow a different approach.

[@RezaDorrani]

Most welcome! I did call out in video about scenarios where data row contains comma in video and how one must replace comma character with a different delimiter prior to importing.

[@hobbymanlp]

​@@RezaDorrani It is not always straight forward that you can just use a different delimiter; especially dealing with customer data. Let's say you have a process which the customer is uploading the file, via a Power App, then they would have to be instructed to use a different delimiter and then given the knowledge on how to do that. Believe me, this has been a pain, we've been down this road. It really surprises me that Microsoft has not provided a CSV Parser "step" for Power Automate. Great content in this video, thanks!

[@RezaDorrani]

@@hobbymanlp One can always get the file from customer. Run some form of office scripts ot PAD over it and replace your delimiter and then work with data. The first technique shown in video works with comma in data as well I believe. The direct import to SP list.

[@MassimoFerro-e8p]

indian slang, ....... not easy to decrypht

[@RezaDorrani]

You’re spot on - “Chal ab nikal yahaan se”

[@achinoy]

Hi Reza, how can PowerAutomate handle a CSV that has 18000+ rows? It gives this error if i use your flow: "Unable to process template language expressions for action 'Apply_to_each' at line '0' and column '0': 'The number of foreach items limit exceeded for action 'Apply_to_each': maximum '5000' and actual '18828'.'.

[@RezaDorrani]

Check documentation on pagination of flow actions.

[@mutantlabor]

Question, instead of getting empty rows as "", I am getting them as ",,,,,,,,,,/r" - and the Filter Array action isn't filtering those out. Any idea how to resolve this?

[@RezaDorrani]

I have not experienced the mentioned issue and hence not sure what the cause for it could be.

[@mutantlabor]

@@RezaDorrani I was able to fix this, however each line of the array has /r at the end of it and it gives me an error message, even though the data input into SharePoint still succeeds. It seems you removed the /r in yours but for some reason following the same steps I cannot remove it from mine.

[@RezaDorrani]

@@mutantlabor Im not sure what the fix for it can be.

[@mehbub110]

Hi Raza, Thank you so much for the tutorial, it's really clear the FOG i have. what I understand from this tutorial that we have to create a List in sharepoint from csv files and use that list in ETL (I am using OData in SSIS) Q: can we not use csv file directly using hyperlink of the folder at sharepoint in ETL? Thanks

[@RezaDorrani]

I have not done any ETL using SSIS so not sure what options are available

[@mshort42]

Hi Rezza, thanks for the video. Excellent as usual. What can we do if we use the dd/mm/yyyy date format? I could edit them directly in excel but as I have multiple date columns and multiple tables to update this would be time consuming. My flow is failing with the message “…The runtime value '"20/09/2023"' to be converted doesn't have the expected format 'String/date'.” I’m sure there must be a way to change this programmatically but as, a relative newcomer to flows, I don’t have the skills for this.

[@RezaDorrani]

Most welcome! Fixing it in excel/csv would be ideal. There are ways in flows using expressions. I do not have a video reference on it though. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

[@palendrenpillay2850]

Hi @Reza Dorrani, how would i achieve this using an automated trigger. When i used your manual upload approach it works perfectly. When i use: 1) When a file is created(properties only), then 2) Get file content using path, then 3) Compose on the body['$Content'], it just returns another binary looking string instead of what it previously returned when i used your manual approach.

[@RezaDorrani]

I do show automated trigger in video. Video description has link to download all the flows (members only - check description for details) I have not come across the issue you have mentioned.

[@mallelajyothi9819]

Hello Reja.. How to find out who turn off the power automate flow

[@RezaDorrani]

No idea

[@daeracosta2484]

Hi Reza, I like your video, it helped me a lot. I have a question, what license or add-on do your users use to download Excel files from that app? In my work i have an Office 365 license but not all my users have it, so can I request only the pugin to download the Excel report?

[@RezaDorrani]

This is not an app but a flow. Users will need "Power Automate for office license" in order to run this.

[@audleymath]

Fantastic!! You're a star 🌟

[@RezaDorrani]

Wow! Thank You 🤩

[@Saturn9177]

Thank you for the video. Very understandable and clearly articulated. My concern is how to move an email with an attachment to various folders in a SharePoint library using Power Automate. We are dealing with 300 different segments (I have accordingly created folders in the library). When we receive emails for these segment-specific cases, we need to convert the emails into PDFs and save them in the respective folders with attachments. Since our subject is always segment-specific, I have been thinking about how to automate this process. Can you provide me with tips on how to achieve this?

[@RezaDorrani]

Thanks for watching and liking the videos. I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com

[@poojasurexsh]

Hi reza, can you help me on how can i run this code in powerapp directly. I'm confused on the on-select property. please assist on this.

[@RezaDorrani]

There is no power app shown in video. I have done many videos on flows triggered from apps. You can check those and see if it helps. Alternatively, I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

[@poojasurexsh]

I changed the trigger condition manually to using PowerApps V2 trigger , now i cant able to run the flow in powerapps submit button below is the code i used but i'm getting error 'PowerAppBulkupload-IMS'.Run( {file: { contentBytes: First(AttachmentBulk.Attachments).Value }} ); @@RezaDorrani

[@schlachtaf]

Hey Reza, First of all, great video as always! It gave me a good idea to build CSV parsing flow. Do you think it would be possible to use the Select function with a dynamic amount of keys/columns? So instead of manually building the below Map for the Select function: { "key 1": @{item()[0]}, "key 2": @{item()[1]}, "key 3": @{item()[2]}, "": "" } Instead it could just dynamically expand to key 4 or down to key 2 while maintaining the item() function with also a dynamic index. I did manage to get to a point where I can actually generate the above text into the Map, but then it is considered string, so the function won't get evaluated (and any attempt of making it not string, will just evaluate it prematurely while I am building the Map in Compose actions).

[@RezaDorrani]

Not sure if that is an option. Have not tried that scenario.

[@schlachtaf]

@@RezaDorrani Yeah, pretty niche issue. Still I hope I find a solution as it can save us some money on CSV to JSON conversion subscriptions

[@gregoirepesenti]

base64ToString(body('Get_file_content_using_path')?['body']?['$content']) is not working anymore, because "body" component is automatically added now, I had to simplified it to base64ToString(body('Get_file_content_using_path')?['$content']) ✅

[@RezaDorrani]

Thanks for sharing

[@mutantlabor]

This basic tutorial is one of the best learnings on Power Automate fundamentals I have watched. No better way to spend a hot Saturday night in July on the porch than watching Reza open my mind to new flow possibilities.

[@RezaDorrani]

Wow! That’s some way to spend a Saturday night 😎

[@thinhphan2629]

hi Reza the video is meaningful ! I have 1 question, how to import CSV data to body mail outlook ? I Hope you respond , thanks best regards

[@RezaDorrani]

Import csv into email body? That’s not something I have tried.

[@thinhphan2629]

@@RezaDorrani ohhhh thank Reza or get data CSV send body mail , That's possible, right?

[@RezaDorrani]

@@thinhphan2629 i don’t understand what get csv data send email body means

[@Frederik-r8r]

Hi Reza, great video as always! I currently have a problem with an app, which is when I use it on a computer screen, the scrollbar size is fine, but when I use it on my laptop, the scrollbar increases in width and "blocks" out the components on the left side in my gallery... Do you know how to solve this issue?

[@RezaDorrani]

I have not come across the mentioned issue and hence not sure what the fix for your issue is. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com