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

Highlighted
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

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

Highlighted
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

Highlighted
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
Check this Out

Announcing

Class of 2020- Season 2

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (7,676)