Unanswered

Read calculated value from Excel and display in textbox

(0) Share

Report

Posted on by Community Power Pla...

Hi,

Does anyone knows how to read calculated value from excel table ( excel is located in Onedrive ) in powerapps?

Calculation has to be done in excel as based on probabilities scenario, so please dont suggest to do calculations in powerapps. I have been able to read static value fine from the same table and the cell by using filter and lookup function but as soon as the formula is placed on the cell, it reads blank.

I believe this feature has been on backlog for quite some time now. Is there any workaround? Possible to create flow that reads calculated cell value instead of using powerapp functions.

Please advise.

Thanks

Harry

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (2)

Community Power Pla... on at

Like (0)

Report

Any sugggestions?

Was this reply helpful? Yes No
MJKjoachim 104 on at

Like (0)

Report

Hi Harry,

From what I know, you cannot use calculated cells in Powerapps, maybe a future improvment !?

You can have a look here : https://aka.ms/powerapps-ideas

Joachim

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thanks for your response Joachim.

It has been in the backlog since beginning of this year. There has to be a workaround - flow??

Its just not acceptable response or timeframe from Microsoft.

Harry

Was this reply helpful? Yes No
Verified answer

Community Power Pla... on at

Like (0)

Report

I managed to achieve this by creating a flow which copies the columns from excel table to sharepoint list and reading value from list column using Last(listname).columnname.

It solves the purpose. However, I get the error message when the app loads that its connected to excel with formulas and is not supported. How do I get rid of these error messages?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@rorybi @PaulD1 @Drrickryp @timl Any ideas on this one? @topshelf-msft

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (1)

Report

Hi @Anonymous,

The only way I found that would read a calculated column into PowerApps from Excel was to import it as a static data source. This is probably not what you want as you can only use it as a lookup table and cannot modify it.

Was this reply helpful? Yes No
Verified answer

Community Power Pla... on at

Like (1)

Report

Thanks Drrickryp. That's correct, because its a calculated value - only allowing to read static values didnt help me but I found a workaround as mentioned earlier to have a flow read that value and put in sharepoint list and read from list. Errors I mentioned in the latter part of my previous comment is resolved as well. It was refreshing the table so I can read the new value but again after implementing above solution, removed those commands and worked ok.

Thanks Again,

Was this reply helpful? Yes No