I have an Excel sheet that has 3 tabs, each with a table. Two of these tables are created by queries that draw data from a web API. The third is a test table with three unique rows (A,B,C). When I try to use one of the two web API tables to create an PowerApp, If I select the 'Auto-generate values in new column' radio button and press 'Create App', nothing happens at all. If I select an existing column and choose the unique column from that dataset, 'Create App' does create the app, but there is an error that says a primary key is not availalable.
The 'Test' table does not draw from a Web API, it's a dead simple table and does not have these issues, so I assume the problem lies with the Web API connection. Could anyone explain what might be leading to this issue please?