cancel
Showing results for 
Search instead for 
Did you mean: 

Formula support in "Excel - Get row" action

I want to use Excel file on OneDrive for Business which include Formula in cells.

 

Now, "Excel - Get row" action does not support any formula in cell.

 

Body
{
  "status": 400,
  "message": "Excel files containing formula are currently not supported. Please use a file that has no formula.",
  "source": "127.0.0.1"
}

Regards,

Yoshihiro Kawabata

 

Status: Completed

The new Excel (business) or Excel (onedrive) connectors support this: https://flow.microsoft.com/blog/approval-history-accessibility/

Comments
Level: Powered On

Same issue for me. Flow will not open excel if tagle contains formulas. Even if i will not use them and take only text values from different cells

Level: Powered On

Well, I have found a workaround.

I just put the formulas out of the table. I.e., skip one column from your table and create new functions here. 

Sure you have to use A1 or B2 links instead of table column name, but it works.

Level: Powered On

We get some data from Jet Professional that we'd love to have flow use, but all of the tables appear to contain formulas. It seems like Flow should be able to get the read-only values from them. Maybe the problem is that it would have to execute the sheet or something.

Level 8

This is very much required. How can MS expect to work in excel without formulas? This is basic requirement for every user working in excel to use formulas as much as possible. I support the IDEA.

Level: Powered On

I have received a private message to provide more details about the workaround.

I think it would be nice to publish the answer in public.

 

So, Create a simple Excel file.

Create a Table area. In my case, it's A1:E8.

Add formulas near the table area. In my case, it's F and G columns and K1 and K2.

Do not extend table area. Table area should be the same as in step 2. Do not mix table area and formula area - they should be separated.

 

ExcelFlow_2017-12-20_16-25-25.png

 

I think this workaround is not Cento per cento workaround that works every time. But in my case, it works. And looks like will works in other scenarios.

 

I hope it helps.

 

Please find Excel sample here