Welcome to deBUG.to Community where you can ask questions and receive answers from Microsoft MVPs and other experts in our community.
0 like 0 dislike
3k views
in Power Apps by 2 2 3
edited by

I am using Onedrive for business to store excel files containing formulas, I am looking forward to using PowerApps to add content to excel file but before I do that I want to know: 

  • Is PowerApps support Excel file containing formula?
  • If no Is there any workaround to use excel file containing formula in PowerApps?

1 Answer

1 like 0 dislike
by 161 202 396
selected by
 
Best answer

Can I use PowerApps with Excel files containing formula?

As a short answer, No you can't use Excel files containing formula in PowerApps right now.

If you have tried to use Excel files containing formula in PowerApps, you will get this error:

The requested operation is invalid in power apps: Excel files containing formula are currently not supported in PowerApps

Excel files containing formula are currently not supported in PowerApps. Therefore, you must use an excel file that has no formula.


Workaround to use excel file containing formula in PowerApps

Actually, there is no workaround to use excel file containing formula in PowerApps right now.
However, there is already an idea that has submitted to PowerApss User Voice.
The idea status is "Under Review", so we do hope it will be accepted and implemented by Microsoft Team soon.

As a workaround, you could convert all required excel formula as a PowerApps formula when you add a new item in PowerApps.

by 2 2 3
1 0
Thanks for making it clear for me!
If you don’t ask, the answer is always NO!
...