Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Patching problem

Hi all,

I'm new to powerapps and I have a problem which looks simple:

H9 is a 4 column table located in my onedrive (Excel),  I'm trying to write records to, ussing the function:


                                 Patch(H9, Defaults(H9) ,  {Date="1-Jan-2018", Name:"Ariel", Ar:"1", Dep:"1"})


The error: powerapps does not recognizes H9 as source and sometimes 'invalid arguments' is announced.

Please advice.




Hi @arigl


In your screenshot, you are connected to a "Statis Database".

What @Sienna means connection is that you have to connect (thru Web PowerApps, NOT Studio) to OneDrive, DropBox, etc..

Make sure to upload your Excel file into one of the connection, say OneDrive.

In your Datasource, Choose OneDrive (it definitely show-up if you have successfully connected), and then choose the desired formatted table. 


Then it will works as Patch needs to communicate PowerApps with Excel in OneDrive.


Hope my additional clarification on top of @Sienna helps.

Have a nice day.


Hi PK_Hong,

Thank you very much to you ans Siena. It must be somthing very stupid thing I'm doing wrong.

  • First I insert a table - 
  • Add data source
  • New connection (Web)
  • Choose OneDrive Busines
  • Ceate
  • Choose Excel file
  • Chose a table
  • Select fields for Date Name Ar and Dep
  • Rename the table to "H"

I'm doing something wrong can't figure what.Er6.pngEr5.png

Memorable Member
Memorable Member

From your second picture it looks like your database is really wierd and long name. you have to rename your table in the excel. I don't how how did you renamed your table. I guess you just renamed the file name and not table. See image how to do it in excelexcel.png

View solution in original post

Memorable Member
Memorable Member

I forgot to mentioned... Then delete your current datasource and replace it with new one exactly the way you were doing it last time

View solution in original post


Dear Sienna,

Thank you very much. I did not realized the difference between file and table names.

Problem solved.

Smiley Happy


Helpful resources

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.


Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (8,549)