Excel files containing formulas are not supported. I do not have any formulas

(0) Share

Report

Posted on by Donniem70

I am new to powerapps. I made my first app and finally got it to work in the test environment with no issues.
As soon as I launched the app I was face to face with an error stating "Excel files containing formula are currently not supported. Please us a file that has no formula.
The workbook that contains the tables I am using has formulas, but none of the tables I am using for data reference or patching to, use formulas.
Other tables pull data from the Patch table via and xlookup function, then any calculations are made in those tables on separate sheets.
I can close out the error message and use the app. When I select "Submit" to Patch the information to the table (that does not have any formulas), it does it, but then all the tables (in the entire workbook) go white and there is missing information and all kinds of crazy stuff.

Can we not Patch a simple app to a table in a workbook that contains formulas?

I am missing something simple, or is just the fact that you entire workbook cannot contain any formulas for a powerapp to function with it?

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Michael E. Gernaey 53,493 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

is this from a Canvas App, model driven or power automate?

From the apps... its more of an issue.

can you please share your Patch statement?

Are you attempting to Patch the Formula column?

Was this reply helpful? Yes No
Donniem70 4 on at

Like (0)

Report

It is a canvas app.

I am not attempting to patch any tables/columns that contain formulas.

What confuses me it that when I test the app in the edit environment, everything works as it should. It updates the tables in the workbook and the other wookbook pages update with the new information as they were designed to. The issue only occurs when trying to use the app after it has been launched.

I can still go to powerapp and in edit mode, everything works as it should. When I attempt to use the link powerapps provides after the app is launched is where the issue starts.

The patch is:

Patch(

InventoryRemoved,

Defaults(InventoryRemoved),

{

Date: DatePicker2.SelectedDate,

'QTY Removed': Value(inpQTYRemoved.Text),

Comments: inpComments.Text,

Description: ddItems.Selected.Descripiton,

Employee: ddEmployee.Selected.'LTS Employees'

}

);

Reset(DatePicker2);

Reset(ddItems);

Reset(ddEmployee);

Reset(inpQTYRemoved);

Reset(inpComments);

Notify(

"Inventory logged successfully!",

NotificationType.Success

);

Was this reply helpful? Yes No
Donniem70 4 on at

Like (0)

Report

I took this one step further. I removed any tables/sheets that had any type of formulas, saved the Excel file (with no formulas), and refreshed the data connections in PowerApps. When I run the app outside of the editing environment, I still get the same error. There are no formulas in the workbook that contain the data—just three tables.

Was this reply helpful? Yes No