cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PK_Hong Resolver II
Resolver II

Re: Patching problem

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.

arigl Helper I
Helper I

Re: Patching problem

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

Re: Patching problem

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

Re: Patching problem

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

arigl Helper I
Helper I

Re: Patching problem

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
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

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