Unanswered

Error: "Fail to read Excel workbook content" after editing data source using Python script

(1) Share

Report

Posted on by ashman123

Hi,

I have an Excel database (table) connected as a data source in Power Apps, and I'm searching / editing the database from the app. Normally, the edit form and submit form operations work when I am just accessing the data source via Power Apps.

However, when I tried editing the Excel database outside of Power Apps using a Python script (openpyxl package), and then tried to edit the database from Power Apps again, I got the following error:

powerapps error.PNG

I have repeated this workflow with a brand new Excel file and confirmed that the error happens after I run the python script to edit the Excel sheet. Is it possible that there is an edit conflict? I am building this for RFID applications and I need to be able to write to the database continuously from Python while also accessing it via Power Apps. Any help is appreciated. Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@ashman123

I have no idea what Python does to an Excel file but you could try using Power Query to recreate the table afterwards and see if it can be read by PowerApps. Otherwise, I would suggest you try to find out more about Python and Excel.

Was this reply helpful? Yes No
Ozzbuzz 3 on at

Like (0)

Report

Hello! I am currently facing the same issue. I'm not sure if the error is related to openpyxl having all empty cells as "None" type values. I tried writing an empty string value in the None type cells with no positive result. Is there any other turnaround for this issue?

Was this reply helpful? Yes No