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 these cool Power Apps & vote on your favorite!
Check out whats happening in Power Apps
FIll out a quick form to claim your community user group member badge today!
Features releasing from October 2020 through March 2021