Power Apps import Excel to SharePoint list or any data source with Power Automate

In this video, you will learn how to use Power Apps to import an Excel file to your SharePoint List or other data source. This allows users to update SharePoint with their excel table data. This is done with the use of Power Automate flow actions that Create a file in SharePoint, then get tables, list rows present in table, and finally in an apply to each use Create item in SharePoint. Not terrible hard but has a few gotchas because of dates and because you want the files from XLSX to be dynamic.

0:00 power apps import Excel to SharePoint list or any data source
0:59 Demo of the Excel xlsx file import to SharePoint list with a Power Automate flow
2:18 A demo and explanation of the Power Automate flow
8:25 Create the flow, connect it to Power Apps, and Create file in SharePoint
9:48 Excel Online Business Get Tables
11:17 List Rows Present in a Table and the ISO 8601 date format
12:00 Create Item in SharePoint using the dynamic content we imported
14:03 Updating the flow to make the IDs dynamic
14:46 Using the First expression in Power Automate

#Powerapps #excel #powerautomate

[CloudhoundCoUk]

Shane, you appear to have a comedian in the background. Fabulous entertaining and educational video. The best way to learn.

[Dexcelo]

Absolutely a clear and concise explanation of power apps. Your delivery, articulation and presentation was exceptional. Great teacher. Thank you so very much!!! 🙏🙏🙏

[juliovilaca]

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

[AMindGame]

You have the most straighforward and clear videos.

[antoniobranderas]

I’ll definitely give this a try in the very near future. Thank you.

[jackpost]

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

[cesaritriago]

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

[oluwatobiyusuf]

Awesome video Shane. This should assist in one of my projects

[nicolontaneda]

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!!!

[carolerlston]

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

[johnvincentpalisoc]

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?

[felixverduin]

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!

[dankirchner]

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?

[jwkdymm]

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.

[sandroguzman]

Hello Shane. How I can build the table to show the data?? it's not a simple Gallery...

[karthikeyan-eveg]

@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?

[hegui]

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!!

[farolconservador]

There is a possibility to fill a drop down list from an Excel file in Powerapps and send the selection to Sharepoint list?

[savithasworld]

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

[dimabilan]

Hey, what is the trick with ? 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?