Great video. To prevent errors with null cells, you can add an expresio. Use coalecence(columnToBring,null) or a conditional if(empty(columnToBring), null, columnToBring). This second fórmula I use It for date in case that in false u need to add another formula as formatdatetime
Absolutely a clear and concise explanation of power apps. Your delivery, articulation and presentation was exceptional. Great teacher. Thank you so very much!!! 🙏🙏🙏
Hi Shane. I did the steps listed and my flow failed. It fails on the create file saying it is unable to process template language expressions in action ‘Create_file’ inputs at line ‘0’ and column ‘0’. The template language function “base64toBinary” was invoked with a parameter that is not valid. The value cannot be decoded from base64 representation” if you could help me out here tht would be great!!
Sorry, I don't know why. I would recommend breaking the problem down into smaller problems. Try with a really small, generic Excel file and see if you can get that work. Then go from there. Remember to avoid formulas/calculations/references in the Excel. Has to be flat data in a table.
Shane thank you very much for your video and explanation, I was searching and miraculously found yours! Congratulations. One question, I would like to build a table like the one you show in the video, in which video did you do that? I would really appreciate it a lot. :) Again, awesome job!!!
Hi, Shane thank you for all your videos, your are making a wonderful job for your community. I have a little question, How could I collect and display all items I upload in the attachment control to a gallery as you have it in minute 1:22? or if you have another video with the explanation?...Thanks a lot... Greetings from Dominican Republic.
Hi. Thanks for the video. I've hit a problem, though. I copied the code from the 'PowerApps upload file to SharePoint document library' video, but when I use it in my test app, EasyUpload.Run asks for a third parameter that you're not asked for - Createfile_FileName. What do I put for that?
@ShanesCows Hi i m getting the error in Get Tables action as ""This workbook couldn't be opened because the file format may not be matching with the file extension.". What to do?
I understood the requirement to have predefined columns so things import well. Is it possible to have say a 20 column sheet but only import 5 out of the 20 columns?
Shane This is exactly what I was looking for. I went through this video and the PowerApps upload file to SharePoint document library video and was able to get this to work. I do have a question about the Excel Online (Business) actions Get table and List rows present in a table. when selecting the SharePoint site in the Create file action before the Get table action I was able to select my communications type SharePoint and or my Team type SharePoint site but it looks like I can only select from the team SharePoint sites with the Excel actions. Is there a limit on the type of SharePoint sites we can use with the Excel actions?
I don't exactly understand your question but I think the answer is yes. You could update the flow to have other actions that run before you save the data.
Hi Shane, thanks for this. I've mapped out everything 1:1 except I get an error when the user that runs the PowerApp isn't an owner of the flow. Is there any way around this?
Is there a way to make this dynamic? My flow only works for one specific list and one specific excel sheet. My app needs to have a user create a sharepoint list with the table columns as their columns in the list and be able to insert an excel table right into that list.
Hi Shane, amazing video! Thank you so much. I need to create a button in my app to upload excel or csv data to my tblData sharepoint list inside the app. Like an Import button then it will open dialog box to choose the csv file then when the user hit Open it will save to the SharePoint list. Is that possible?
Yes you can. Look at this video Power Apps import Excel to SharePoint list or any data source with Power Automate th-cam.com/video/MhFNwjaR10A/w-d-xo.html and then adapt the trigger to be Power Apps
Hi Shane! Absolute gem of a video. I have a question though. I'm under 'Create File' and I don't have the 'Ask in PowerApps' option in File Name? Thank you!
Your videos are very very helpful. I need help with something..I have to display datatable(from sharepoint list) in canvas app ..it's source should be dynamic bcz any number of lists could be created in that sharepoint site.so I have to display only the one that is searched for ..please suggest a way
Galleries or data tables aren’t meant to be dynamic. If the list have the exact same columns you can make the items property an If but I don’t think you will like where this adventure ends. 🤨
I want to display my excel data which is stored in sharepoint documents. Can I display the data on Powerapps without using PowerAutomate? I connected the site documents but I couldnt reach my xlsx files inside. Help pls :)
Hey, what is the trick with _api/web/Lists/GetByTitle('Documents')/GetItemById(ID)/recycle ? Does this fragment with HTTP request should remove excel file from 'Document' library? for some reason I receive code 400. Maybe i provided wrong link?
Hi Shane, i am having an excel file which is having 84k+ records, while using the 'List row present in table' it is failing. and getting an error 'BadRequest. The action 'List_rows_present_in_a_table' has an aggregated page results size of more than '210429765' bytes. This exceeded the maximum size '209715200' bytes allowed.' any idea of any alternate soln to avoid this? i am just using 2 column from this step to filter in next step ie, list rows.Since the column header is having space, eg Transaction Number, this is not accepting in select query of list row present in table but when i change the column header to TransactionNumber and the same in List row present in table, it is accepting. can you help out?
@@ShanesCows I did it and put 1000 items but it is only uploading 256 items out of the table that has around 700. Any ideas on why this may be happening? Thanks for all your videos!!
Hi Shane, learned a lot again! There is one question i have, is there any possibility to add one ID to all excel rows that are imported? The content is part of a single "item".
Thanks, great video :) I got the upload and insert to sharepoint list to work fine, but I am having some "speed" issues i would call them. Seems it takes a very long time to get the items from the excel file into the sharepoint list. Is there any way to speed the process up? I tried 2000+ 5 minutes it only at around 1000 items. It is still running though, and adding more items, so i think eventually everything will be there, just takes a very long time.
Hi Shane. Really loving the videos. Is it possible if you could make one for a simple use case? I have a SharePoint list and I'd like to update records that are already in the list and create new items for ones which are not. Your videos show how to add new, but I can't find anything on updating pre-existing items.
Ryan that is possible but you would have to load the Excel data then as you looping through it try to get the item, if it exists then update it, if not found then create new. I haven't had to build it before but it would be trickier than it seems. If you have a primary key that will make it a lot easier.
@@ShanesCows Thanks for the reply, my list does use a primary key. However, I have gone the novel route of connecting the SharePoint list to excel with a refreshale query, using power query within excel to compare it to the new data, then creating 3 tables (also with Power Query) for create, update and delete. I have then created 3 Power Automate routines that simply get the required table. Now the user just needs to overwrite the excel data, refresh the tables and run the automation. It's been a fun evening!
Great video. I have one requirement. I need to send Excel data to azure SQL through power apps i e. Have to create a button in power app such that it imports the data from Excel and exports it to azure SQL. Please reply. Thanks
Hi thanks for this however I can't find a link to the video for the first step in all of this. Please could you kindly share it again? Thanks. p.s. great videos, absolute life savers.
Hi Shane, thank you for this video, it is exactly what I need however my problem is that the SharePoint list I need to writ to consists mainly of lookup columns. Is it possible to send the information to a collection that can then be saved to the SharePoint list? Sorry if my question seems silly, I am very inexperienced. Thanks and regards Carol
You would need to have some logic that showed a second pop-up when you got to the end of the first one. So show the loading. When you set its variable to false, to make it quit spinning, set another variable to true to show your Success message. :)
Hi Shane Thanks for the video. File gets created, however flow is stuck with get tables section for long time. I’m using ID (not item id)from the file created as you suggested. Any idea?
Hey Shane.. Not sure if you are tracking this, but the US Government has done a bit of investing in M365. Government employees need to start learning SPO and M365. Your videos have been a lifesaver for me and my office as solutions "guys." I push all your videos when people ask me how they can use PowerApps and Automate to improve their fighting positions. We are struggling to find M365 trainers in our area to help us do some more in-depth training. Can you help us find some "in-person" training in NC? We are specifically focusing on PL900+ material.
Hi Chris - We teach classes live both online and inperson. So depending on what you are looking to learn we could potential help. Feel free to email me shane at powerapps911.com and I can help you get more info. Thanks
Another question, i tried replacing the Sharepoint list with Dataverse, and use "Add a new row" instead of "create item". It seems like the logical way to do it, but unfortunately the flow fails. Do you know how to make this work?
Actually after redoing it all, it works just fine. But seems it fails if i am too quick to upload a second file, so have to test that a bit more :) So following your tutorial, and just doing "add a new row" in Dataverse works just fine, just needs to be tuned a bit more.
@@xBiiaBianca Hi, i actually moved away from Dataverse, i found out that most people in the company where i work, do not have a license that allows them to do all that is needed in dataverse, so unfortunately i didnt find the solution, as there was no reason to.
Great video! I've learned so much from this and its associated videos! I have an issue where the column names in the workbooks to be imported contain special characters (namely "¿ ") so any data for those columns appears blank in my SharePoint list. My flow does not produce any errors, it simply ignores those columns. Data from columns whose names contain no special characters work just fine!! Thanks!!
The problem turned out to be slashes "/" in the header names and I was inspired to solve it by watching this video th-cam.com/video/S5eqq3KjaBI/w-d-xo.html I basically had to manually edit the expressions for each of the items('Apply_to_each')? for the Create Item step where the header in the .xlsx file contained a "/". For some reason, Power Automate read in "/" as "~1".
Hi Shane, amazing video! Thank you so much. Is there a way to use Dataverse as primary database to save the Excel files? I noticed there is no (easy) way to choose Dataverse as a location in the Get tables action. Thanks again!
Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The action(s) 'Get tables' referenced by 'inputs' in action 'List_rows_present_in_a_table' are not defined in the template.'.'. I get this error
Hi Shane! Thanks for the video, simple, straight to the point! Like always. I am however having trouble with my data. I can only upload 256 items from my Excel file. Do you know if this is the limit, or if I can enhance that? Thank you so much!!
I've built this, and it runs, but not when I use the dynamic data (Sharepoint Id in 'Get Tables' and 'List Rows Present in Table' steps). It stalls (and retries) at the 'Get Tables' step of the flow, and throws a 'BadGateway' error. I thought it might be because the Sharepoint List is in a different SP Site from the SP Documents Library where I'm uploading my Excel table, but I've tried it both ways. I'm sure I'm missing something obvious. Lil' help? [BTW, Shane continues to produce excellent content that has helped me create nearly 10 apps, several of which are in daily use by hundreds of staff at my W-2 gig. Thank you.]
After two weeks of fruitless trying, I changed direction. I have created a Power Automate flow that listens for an email with a keyword in the subject line, grabs the Excel attachment, gets the table from the spreadsheet, lists the table rows, matches them with my SharePoint list columns, then imports them into the list. Then they're displayed in a PowerApps gallery. It works beautifully, and should actually be easier for the end users who are already accustomed to emailing spreadsheets for this purpose. If like to see how I did that, just reach out to me here.
Hi Shane, Thank you for sharing this tutorial I hope you are doing well need one help in one of my power App Project. where I want to provide a user to 1- Download a Excel template 2 Fill the template 3 User should be able upload the template using power App. 4 and patch the records to database MS lists I found 2 Tutorial on TH-cam but it confusing to me please check if you can help me with this requirement it will be great help. I am new to PowerApp world please if you can create a tutorial that will be great help for new learners.
Great Walkthrough. I tried everything you've said and as shown on your screen. I get an error on the 5th line " ImportandUpload.Run(Last(AttachmentControl.Attachments).Name, varBase640nly); "Comment saying : Invalid number of arguments: Received 2, Expected 1. kindly assist, please.
i have been banging my head on the desk all day. In 18:48 you have solved my issues! Once again Shane thank you.
Shane, you appear to have a comedian in the background. Fabulous entertaining and educational video. The best way to learn.
Yeah, Jennifer was running around this place when I was recording, and she couldn't control herself. 🤣
The tip you provided about Date Format - ISO 8601 was so usefull, you have no Idea how much this helped me! Thank you. Great job
Awesomeness 😎 Glad to help. 😀
Great video. To prevent errors with null cells, you can add an expresio. Use coalecence(columnToBring,null) or a conditional if(empty(columnToBring), null, columnToBring). This second fórmula I use It for date in case that in false u need to add another formula as formatdatetime
Nice tip Cesar! Thanks
Basically I'm trying to go "for each row, for each cell, if it's empty make it null" but am struggling!
You have the most straighforward and clear videos.
Appreciate that. 🐶
Absolutely a clear and concise explanation of power apps. Your delivery, articulation and presentation was exceptional. Great teacher. Thank you so very much!!! 🙏🙏🙏
Much appreciated!
Shane. Again thank you. I have about 3 ways I’ve done this before and now you’ve shown me a 4th. Love the content
Glad to help Jack. :)
Hi Shane. I did the steps listed and my flow failed. It fails on the create file saying it is unable to process template language expressions in action ‘Create_file’ inputs at line ‘0’ and column ‘0’. The template language function “base64toBinary” was invoked with a parameter that is not valid. The value cannot be decoded from base64 representation” if you could help me out here tht would be great!!
hye, i already have do all like u show in the video but still my data from excel does not import into the spo list. may i know why ?
Sorry, I don't know why. I would recommend breaking the problem down into smaller problems. Try with a really small, generic Excel file and see if you can get that work. Then go from there. Remember to avoid formulas/calculations/references in the Excel. Has to be flat data in a table.
Hello Shane. How I can build the table to show the data?? it's not a simple Gallery...
Awesome video Shane. This should assist in one of my projects
😎
Hi Shane, I no longer see the "Ask in Power Apps" dynamic content in the current power automate version. Any suggested work around?
They change the trigger. This video explains it.
Use the Power Automate v2 Trigger for Power Apps
th-cam.com/video/vpjf5mD-COs/w-d-xo.html
I’ll definitely give this a try in the very near future. Thank you.
Awesome :)
Shane thank you very much for your video and explanation, I was searching and miraculously found yours! Congratulations.
One question, I would like to build a table like the one you show in the video, in which video did you do that? I would really appreciate it a lot. :) Again, awesome job!!!
Hi, Shane thank you for all your videos, your are making a wonderful job for your community. I have a little question, How could I collect and display all items I upload in the attachment control to a gallery as you have it in minute 1:22? or if you have another video with the explanation?...Thanks a lot... Greetings from Dominican Republic.
Start with this video. :) th-cam.com/video/3QaiM8SeWfM/w-d-xo.html
Hi. Thanks for the video. I've hit a problem, though. I copied the code from the 'PowerApps upload file to SharePoint document library' video, but when I use it in my test app, EasyUpload.Run asks for a third parameter that you're not asked for - Createfile_FileName. What do I put for that?
Paul if the flow wants 3 things then you asked on Power Apps 3 times. Easiest thing to do is build the flow again and only ask on Power Apps twice.
Thanks for your time on this work, please can you specify what syntaxis write in the List rows present in table / Table ... first(....)?
first(outputs('Get_tables')?['body/value'])?['Name']
As shown at 15:49
hi Shane, did you also create a video for the creation of the power apps upload and the preview?
I think you are looking for this video? th-cam.com/video/QcWjAt7QVn4/w-d-xo.html
@@ShanesCows thank you so much Shane.. all your videos are really helpful
Good video 👍😎🔥
Thanks! Happy Holidays.
@ShanesCows Hi i m getting the error in Get Tables action as ""This workbook couldn't be opened because the file format may not be matching with the file extension.". What to do?
I understood the requirement to have predefined columns so things import well. Is it possible to have say a 20 column sheet but only import 5 out of the 20 columns?
Shane This is exactly what I was looking for. I went through this video and the PowerApps upload file to SharePoint document library video and was able to get this to work. I do have a question about the Excel Online (Business) actions Get table and List rows present in a table. when selecting the SharePoint site in the Create file action before the Get table action I was able to select my communications type SharePoint and or my Team type SharePoint site but it looks like I can only select from the team SharePoint sites with the Excel actions. Is there a limit on the type of SharePoint sites we can use with the Excel actions?
Rob trying adding the site with its URL as a custom value and see if works. I haven't tried but quick test should tell you.
Hello. A question here. Can we do it like instead of saving directly to list, can we insert a submit command before saving it to list? thank you.
I don't exactly understand your question but I think the answer is yes. You could update the flow to have other actions that run before you save the data.
Hi Shane, thanks for this. I've mapped out everything 1:1 except I get an error when the user that runs the PowerApp isn't an owner of the flow. Is there any way around this?
Is there a way to make this dynamic? My flow only works for one specific list and one specific excel sheet. My app needs to have a user create a sharepoint list with the table columns as their columns in the list and be able to insert an excel table right into that list.
Hello, how can I dynamically add combo boxes with powerapps filter, using sharepoint tables and save the data set in another table?
Joel, sorry I don't follow what you are looking for. I have a lot of videos on dropdowns and comboboxes. What part are you have challenges with?
Hi Shane, amazing video! Thank you so much. I need to create a button in my app to upload excel or csv data to my tblData sharepoint list inside the app. Like an Import button then it will open dialog box to choose the csv file then when the user hit Open it will save to the SharePoint list. Is that possible?
Yes you can. Look at this video Power Apps import Excel to SharePoint list or any data source with Power Automate
th-cam.com/video/MhFNwjaR10A/w-d-xo.html and then adapt the trigger to be Power Apps
hello Where can I find the template for this example?
training.powerapps911.com/courses/video-library it is available to download via our TH-cam library.
Hi Shane! Absolute gem of a video. I have a question though. I'm under 'Create File' and I don't have the 'Ask in PowerApps' option in File Name? Thank you!
They changed the trigger, I put out a new video yesterday to explain it th-cam.com/video/vpjf5mD-COs/w-d-xo.html
Is there a way to skip blank rows in the excel table?
Your videos are very very helpful. I need help with something..I have to display datatable(from sharepoint list) in canvas app ..it's source should be dynamic bcz any number of lists could be created in that sharepoint site.so I have to display only the one that is searched for ..please suggest a way
Galleries or data tables aren’t meant to be dynamic. If the list have the exact same columns you can make the items property an If but I don’t think you will like where this adventure ends. 🤨
I want to display my excel data which is stored in sharepoint documents. Can I display the data on Powerapps without using PowerAutomate? I connected the site documents but I couldnt reach my xlsx files inside. Help pls :)
I don't think it is possible directly. Sorry. You will have to use flow.
Hey, what is the trick with _api/web/Lists/GetByTitle('Documents')/GetItemById(ID)/recycle ? Does this fragment with HTTP request should remove excel file from 'Document' library? for some reason I receive code 400. Maybe i provided wrong link?
Hi Shane, i am having an excel file which is having 84k+ records, while using the 'List row present in table' it is failing. and getting an error 'BadRequest. The action 'List_rows_present_in_a_table' has an aggregated page results size of more than '210429765' bytes. This exceeded the maximum size '209715200' bytes allowed.' any idea of any alternate soln to avoid this? i am just using 2 column from this step to filter in next step ie, list rows.Since the column header is having space, eg Transaction Number, this is not accepting in select query of list row present in table but when i change the column header to TransactionNumber and the same in List row present in table, it is accepting. can you help out?
I haven’t ran into that issue before so I am not sure. Sorry.
Hi Shane! Can we add the excel file of any name? I'm trying Its showing error to it.
Yes, adapt what I taught in this video and you have what you want. :) th-cam.com/video/QcWjAt7QVn4/w-d-xo.html
is there a limit to the number of items this is able to upload?
Hmmm. Fair question. I think you can change the limit on the Get List Items to a pretty high max.
@@ShanesCows I did it and put 1000 items but it is only uploading 256 items out of the table that has around 700. Any ideas on why this may be happening? Thanks for all your videos!!
@@axessbv If you click on the Excel Get Items connection under settings there is Pagination you need to enable. :)
@@ShanesCows Thanks! That solved it.
Hi Shane, learned a lot again! There is one question i have, is there any possibility to add one ID to all excel rows that are imported? The content is part of a single "item".
I don't think so. But maybe this video that talks about adding row numbers will help :) th-cam.com/video/Uuolue31t5o/w-d-xo.html
Thanks, great video :) I got the upload and insert to sharepoint list to work fine, but I am having some "speed" issues i would call them.
Seems it takes a very long time to get the items from the excel file into the sharepoint list. Is there any way to speed the process up? I tried 2000+ 5 minutes it only at around 1000 items.
It is still running though, and adding more items, so i think eventually everything will be there, just takes a very long time.
Look at the settings for the Apply to each action. You can enable Concurrency and then get it to process more than 1 at a time. 😎
@@ShanesCows Thanks :)
Hi Shane. Really loving the videos. Is it possible if you could make one for a simple use case? I have a SharePoint list and I'd like to update records that are already in the list and create new items for ones which are not. Your videos show how to add new, but I can't find anything on updating pre-existing items.
Ryan that is possible but you would have to load the Excel data then as you looping through it try to get the item, if it exists then update it, if not found then create new. I haven't had to build it before but it would be trickier than it seems. If you have a primary key that will make it a lot easier.
@@ShanesCows Thanks for the reply, my list does use a primary key. However, I have gone the novel route of connecting the SharePoint list to excel with a refreshale query, using power query within excel to compare it to the new data, then creating 3 tables (also with Power Query) for create, update and delete. I have then created 3 Power Automate routines that simply get the required table. Now the user just needs to overwrite the excel data, refresh the tables and run the automation. It's been a fun evening!
can you please give more details on how to Import excel to power apps and display the data on a gallery to perform CRUD functionality
Nice video but I still confuse in PowerApps. How to add AttachmentControl? How you add the button to import file? Thank you!
Hi Leo - This video will walk you through that part. th-cam.com/video/3QaiM8SeWfM/w-d-xo.html
Great video. I have one requirement.
I need to send Excel data to azure SQL through power apps i e. Have to create a button in power app such that it imports the data from Excel and exports it to azure SQL. Please reply. Thanks
Thank you sooooo MUCH
You're welcome!
I have the error "Acess denied" on step Create File. Can you help me?
Do you have a video on how you created that power app ?
I don't but you can download the app if you subscribe to our TH-cam Library. training.powerapps911.com/courses/video-library
Hi thanks for this however I can't find a link to the video for the first step in all of this. Please could you kindly share it again? Thanks. p.s. great videos, absolute life savers.
th-cam.com/video/3QaiM8SeWfM/w-d-xo.html There you go. :)
@@ShanesCows legend, thank you.
p.s would this be possible with SQL as a datasource? Or only Sharepoint List?
YOu could change the flow to write to SQL
Hi Shane, thank you for this video, it is exactly what I need however my problem is that the SharePoint list I need to writ to consists mainly of lookup columns. Is it possible to send the information to a collection that can then be saved to the SharePoint list? Sorry if my question seems silly, I am very inexperienced. Thanks and regards Carol
Dear Shane, that was an amazing video! thanks
on the line Json(Image1_4.image) what's the image 1_4?
Image1_4 is the name of my image control. th-cam.com/video/3QaiM8SeWfM/w-d-xo.html That video gets into the details if you need them for uploads.
Thanks again for this Shane! Just one more question, how do you change the loading or at least add a "OnSuccess" image there?
You would need to have some logic that showed a second pop-up when you got to the end of the first one. So show the loading. When you set its variable to false, to make it quit spinning, set another variable to true to show your Success message. :)
if the data is not in a table?
How to proceed?
Has to be in a table or you cannot use the Excel data. Sorry
Initials of mystery women eq AB?
Nope. But good guess.
eq J.H.
Awesome Video Shane! is the download locked behind a paid subscription?
Yes, sorry. Https://training.powerapps911.com
Hi Shane
Thanks for the video.
File gets created, however flow is stuck with get tables section for long time. I’m using ID (not item id)from the file created as you suggested. Any idea?
Did you try it by manually upload the file and specifying it. Maybe something is wrong with the file? NOt sure.
Hey Shane.. Not sure if you are tracking this, but the US Government has done a bit of investing in M365. Government employees need to start learning SPO and M365. Your videos have been a lifesaver for me and my office as solutions "guys." I push all your videos when people ask me how they can use PowerApps and Automate to improve their fighting positions. We are struggling to find M365 trainers in our area to help us do some more in-depth training. Can you help us find some "in-person" training in NC? We are specifically focusing on PL900+ material.
Hi Chris - We teach classes live both online and inperson. So depending on what you are looking to learn we could potential help. Feel free to email me shane at powerapps911.com and I can help you get more info. Thanks
Another question, i tried replacing the Sharepoint list with Dataverse, and use "Add a new row" instead of "create item". It seems like the logical way to do it, but unfortunately the flow fails. Do you know how to make this work?
Actually after redoing it all, it works just fine. But seems it fails if i am too quick to upload a second file, so have to test that a bit more :)
So following your tutorial, and just doing "add a new row" in Dataverse works just fine, just needs to be tuned a bit more.
@@GSMonkey Hi, can you please tell me if you just replaced "create file" or did you add other steps as well? thanks
@@xBiiaBianca Hi, i actually moved away from Dataverse, i found out that most people in the company where i work, do not have a license that allows them to do all that is needed in dataverse, so unfortunately i didnt find the solution, as there was no reason to.
Great video! I've learned so much from this and its associated videos!
I have an issue where the column names in the workbooks to be imported contain special characters (namely "¿ ") so any data for those columns appears blank in my SharePoint list. My flow does not produce any errors, it simply ignores those columns. Data from columns whose names contain no special characters work just fine!!
Thanks!!
Interesting. Sorry I haven't ran into that before so not sure.
@@ShanesCows I seem to always find all of the edge cases :D Thanks for checking in!
The problem turned out to be slashes "/" in the header names and I was inspired to solve it by watching this video th-cam.com/video/S5eqq3KjaBI/w-d-xo.html
I basically had to manually edit the expressions for each of the items('Apply_to_each')? for the Create Item step where the header in the .xlsx file contained a "/". For some reason, Power Automate read in "/" as "~1".
Could you please put the tutorial for the power apps import excel?
Hi RJ. Sorry, not sure what you mean.
@@ShanesCows I'm just referring to the front-end design of the power apps itself. Lowkey curious how you were able to add a file
@@ShanesCows yeah, can you show us how to set up the app in order to connect the uploaded file to the flow
Hi Shane, amazing video! Thank you so much. Is there a way to use Dataverse as primary database to save the Excel files? I noticed there is no (easy) way to choose Dataverse as a location in the Get tables action. Thanks again!
Thank You, Shane.
Happy to help 😀
Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The action(s) 'Get tables' referenced by 'inputs' in action 'List_rows_present_in_a_table' are not defined in the template.'.'. I get this error
Hi Shane! Thanks for the video, simple, straight to the point! Like always. I am however having trouble with my data. I can only upload 256 items from my Excel file. Do you know if this is the limit, or if I can enhance that? Thank you so much!!
Found an alternative way, using the "import to a sharepoint list" option in Excel ;) Thanks anyway!
@@jeffrosse3910 I came to the comments with that same problem, thanks for posting your solution!
With the help of this flow can i upload 2000+ records to SharePoint
I don’t see why not.
I've built this, and it runs, but not when I use the dynamic data (Sharepoint Id in 'Get Tables' and 'List Rows Present in Table' steps). It stalls (and retries) at the 'Get Tables' step of the flow, and throws a 'BadGateway' error. I thought it might be because the Sharepoint List is in a different SP Site from the SP Documents Library where I'm uploading my Excel table, but I've tried it both ways. I'm sure I'm missing something obvious. Lil' help?
[BTW, Shane continues to produce excellent content that has helped me create nearly 10 apps, several of which are in daily use by hundreds of staff at my W-2 gig. Thank you.]
After two weeks of fruitless trying, I changed direction. I have created a Power Automate flow that listens for an email with a keyword in the subject line, grabs the Excel attachment, gets the table from the spreadsheet, lists the table rows, matches them with my SharePoint list columns, then imports them into the list. Then they're displayed in a PowerApps gallery. It works beautifully, and should actually be easier for the end users who are already accustomed to emailing spreadsheets for this purpose. If like to see how I did that, just reach out to me here.
ha ha, Just did this exact thing last week!
Nice Gino. 😎
Hi Shane,
Thank you for sharing this tutorial
I hope you are doing well
need one help in one of my power App Project. where I want to provide a user to
1- Download a Excel template
2 Fill the template
3 User should be able upload the template using power App.
4 and patch the records to database MS lists
I found 2 Tutorial on TH-cam but it confusing to me please check if you can help me with this requirement it will be great help.
I am new to PowerApp world please if you can create a tutorial that will be great help for new learners.
Thank!!!
You're welcome!
8:25
wutwuut!
🤘
Great Walkthrough. I tried everything you've said and as shown on your screen. I get an error on the 5th line " ImportandUpload.Run(Last(AttachmentControl.Attachments).Name, varBase640nly); "Comment saying : Invalid number of arguments: Received 2, Expected 1.
kindly assist, please.
That means you only did Ask In PowerApps 1 time inside of your flow.