cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
arigl
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.

Thanks,

Ari

24 REPLIES 24

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

Sienna
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

Sienna
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

Arigl

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (1,352)