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
Regular Visitor

Hi @Anonymous

Typically it would require the user to hit a refresh button under "Data" Tab. To automtate that, one would need to write a macro and save it as .xlsm file. This file extension is probably not detected by Flow at present. So, this is probably the one solution that contains no macros in the file and formulas within the table.

 

Alternatively,i think we could use a PowerBI service report to read this table and export to another file as table. The flow would then read from this new table. We can only schedule the Power BI file to refresh at a predetermined frequency, but not a trigger like when new data is added, as far as I remember.

I have not tested this solution. I also believe that we will have to redefine data-types in the new table using this process, if that is something important.

 

Also, 

1.Is your source data for the pivot auto populated?

2. What is the trigger for the flow?

 

.

 

Thanks,

Power Automate
Status changed to: Completed

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

Memorable Member

Excellent, Thank you for complete 'Excel - Get Row' feature 

New Member
@Stephen, I don't see any were on the announcement blog post or the documentation pages of Excel (Business) or Excel (OneDrive) that discuss how getrow can be filtered to only fetch "new"/ newly created rows. Something that could be used as a trigger for or timed action that is taken on newly added records... Is this possible with the new connectors?
Power Automate

Correct - we don't have any triggers for Excel today. If you add your own timestamps into the rows you can add filters on the queries to only get the data after a certain timestamp (which is basically what triggers do). However, you do have to put the timestamp into the rows to do this.

Memorable Member

Great, for COMPLETE status, Fomula support in Excel (business), Excel (OneDrive) connectors

Thank you