Request failed with status code 400 in "Get Started with Power Apps" exercise

Question

Request failed with status code 400 in Power Apps with CoffeMachines table exercise in "Get Started with Power Apps". The error happens upon clicking on the Create App action. The issue has to do with the xlsx file from Microsoft

https://make.powerapps.com/environments/Default-0c7288c4-2e8c-4051-82ba-bbd2f7f09ced/home

https://learn.microsoft.com/en-us/training/modules/get-started-with-powerapps/?WT.mc_id=powerapps_inproduct_makerportal

Answer 1

Hello Domond, Patrick,

Thank you for reaching out on the Microsoft Q&A forum.

Please go to the Create tab and select Blank canvas app, then choose the Tablet format. Once the app opens in Power Apps Studio, navigate to the Data section and click on Connect to data. From there, select OneDrive for Business as your data source. Locate and select the CoffeeMachineData.xlsx file that you've saved to your OneDrive.

After selecting the file, choose the CoffeeMachines table and connect it to your gallery. This will allow your gallery to display the data from the Excel file. Make sure that the Excel file is stored in your OneDrive for Business and that the data is formatted as a proper Excel table.

Kindly refer to the below screenshots for guidance. If you are still facing any issue, please let us know in the comments and where you are encountering this error along with the screenshot for reference. We are glad to help you.

Please don’t forget to Accept Answer and Yes for "was this answer helpful" wherever the information provided helps you, this can be beneficial to other community members.

Thank you.