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.
Thank you very much to you ans Siena. It must be somthing very stupid thing I'm doing wrong.
I'm doing something wrong can't figure what.
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 excel
Read the announcement for more information!
Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.
Features releasing from October 2019 through March 2020
Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications