Skip to main content

Notifications

Power Automate - Using Connectors
Answered

Get rows but with formula

(1) ShareShare
ReportReport
Posted on by

Hey guys,

 

I want to send auto daily email at 9:00 am, the buddy of this email is including dinamic (number), this (number) is cell in excel, this cell is formula, the excel file is on the company sharepoint.

 

 

How I can make this flow ?

  • aerofabs Profile Picture
    aerofabs 10 on at
    Re: Get rows but with formula

    I'm using the Excel Business connector and it still isn't creating the formula when a new row is inserted. Does this functionality exist?

  • Verified answer
    Re: Get rows but with formula

    The Excel (Business) connector now provides support for both issues; Excel files that contain formulas and Excel files that are stored in SharePoint.Cat Very Happy

  • v-yamao-msft Profile Picture
    v-yamao-msft on at
    Re: Get rows but with formula

    Hi aalalim,

     

    First, Microsoft Flow doesn’t support formula in Excel table. There is similar idea on Flow Ideas Forum, please consider voting the idea at here:
    https://powerusers.microsoft.com/t5/Flow-Ideas/Formula-support-in-quot-Excel-Get-row-quot-action/idi-p/6021

     

    Second, Excel from SharePoint connector has not been supported currently, we could use Excel table that is saved on OneDrive, OneDrive for Business, Dropbox. Please vote and comment the idea at here:
    https://powerusers.microsoft.com/t5/Flow-Ideas/Excel-from-SharePoint-connector/idi-p/8688

     

    For your scenario, I would suggest you remove all the formulas on the Excel table and locate the file on other could storage account. Then trigger the flow with “Recurrence”, then use the action “Excel - Get rows” to get all the items in the table.


    In addition, you can also add an action “Create HTML table” to format the data into a table then send email with table.


    Reference materails:
    https://docs.microsoft.com/en-us/flow/run-scheduled-tasks
    https://thewincentral.com/microsoft-flow-create-html-csv-tables/

     

    Please feel free reply if you need more help.

     

    Best regards,
    Mabel Mao

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,508

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard

Featured topics