Hands-On Tutorial Building Your First Power App to Update Excel Workbooks 💪

Learn how to build a simple Power App that uses Excel as a source for updating, inserting and deleting data. Also see how to auto increment a key or a number in Power Apps.

-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -

Next step on your journey:



Let's connect:

Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: [phone]

[Thor_Underdunk_Caballerial]

I'm impressed, this looks comprehensive and functional. You presented the information very well, Thank You.

[oscamontesyttf]

Gracias, eres lo maximo. Thanks u are the best.

[adewangan]

how to handle the case when multiple users are entering the data at the same time?

[CharlesGramazzo]

Hello!! I hope you're fine!
I'm creating an app (Canvas), but i do not know how to show only a week, for example, i have a lot information in the same week (5 rows), but what a need is, show only, for example, Week 25 and then, after click in the option, will show all inserts of this week. What a have now is, ex. Week 25, 25, 25, 25, 25, 26, 25 etc... not, 25, 26, 27 etc... i was unable to find any info about this. Many thanks for you help :)

[prateeksrivas]

What to do if I don't want to share the excel file where data is stored? I mean like users enter in a form type of thing and data is stored like you showed. But raw data file remains unshared to avoid data Manipulation later

[emilpinter]

Hello, good job. But one question : is it possible to connect from Power App to personal OneDrive of user who is starting the App ? I mean every user has the same Excel with the same name.

[nazarinnordin]

Hi. Is it possible to let a new user add himself through the mobile app? Thus, automatically updating his data in Excel? Thank you.

[komalpagare]

Hi I want to develop a form using power app particular person worked how many hours on particular task and calculate total number of hours per month and I want data to maintain in excel sheet but employee couldn't modify that data after filling once any suggestions plz

[VerticalVlogger]

I have shifted my excel file from OneDrive to Sharepoint communication site in documents folder.
Now I need to update the Data sources for my PowerApps, to point to the excel file table in sharepoint.
How do I do it ?

[vinodkukanur]

Hi can you please guide me how to create powerapp with 20-30 columns?

[fapfapfap]

mac users needs control click in order to be able to interact with the app buttons

[Thor_Underdunk_Caballerial]

How the hell do you show the date field on the default gallery so you can sort by it etc?!

[MohammadAli-tsev]

Great video...it's, indeed, very informative..

@Pragmatic Work -. Can you plz make a video on the issue we experience while picking up DATE to edit form from Excel online (for business). The date picker simply goes blank and it doesn't pick up date from Excel table (date column) while other details from the table appear correctly.
Any get around will help many of the people. I got the same issue posted by someone on powerplatform community but none of the answers fixed the issue..

[yamasthegeek]

Really good video, very well explained. Thank you.

[kanwalsaini]

Hi,

Is it possible to read and update the information stored in excel file present in Sharepoint using Powerapps? instead of onedrive as the data source.

[joanmendoza]

Is it possible two get and write data from excel spreadsheet located in SharePoint?

[alancealance]

Really cool. Can I get it to search more than 500 excel rows?

[genipheregnangue]

hello sir, i have followed your step, however i have an array of 18, 000 values ​​so power apps only takes the first 500 values. could you help me please.

[muhammadsamikhan]

How to get record from other users? E. G i want my team to write how tall are you using app and then same data automatically reflect in excel sheet ?

[subhadeepsarkar]

Hi, can we compare two tables from different excel sheets and see if the records are same or not using the Power apps? Please help.