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
Check out the on demand sessions that are available now!
See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.
ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.
Features releasing from October 2020 through March 2021