cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PK_Hong
Level 8

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
Level: Powered On

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

Highlighted
Sienna
Level 10

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
Level 10

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
Level: Powered On

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
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 418 members 5,847 guests
Please welcome our newest community members: