Power Automate Flow attaches Sharepoint Excel in emails, but they are not up to date

Reilly, Patrick - Windsor, CT 0 Reputation points
2024-03-18T20:51:31.1966667+00:00

I am using a power automate workflow as follows.

When a new response is submitted > Get response details > Add a row into a table > Get files (Properties Only) > Get file using content path > then I have a condition that if yes sends an email > in the attachments name I have file name with extension and in attachment content I have file content.

The flow works fine, it goes through the entire process, it sends me an email with the excel file attached, but it doesn't send the most recent excel file. If I send another flow through, the next excel attachment will have the previous flows response.

If I look on the sharepoint version of the excel spreadsheet though, it updates almost right away.

Any help?

Outlook
Outlook
A family of Microsoft email and calendar products.
3,329 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,653 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,151 questions
SharePoint Workflow
SharePoint Workflow
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Workflow: An orchestrated and repeatable pattern of business activity, enabling data transformation, service provision, and information retrieval.
545 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Yanli Jiang - MSFT 23,266 Reputation points Microsoft Vendor
    2024-03-22T07:34:05.0966667+00:00

    Hi @Reilly, Patrick - Windsor, CT ,

    Sorry to bother you, as I haven't heard from you yet, I just wanted to know the progress on this issue. Has it been resolved? If it is solved, could you please share the solution here? If the problem still bothers you, as the information you provided is insufficient and the Q&A forum does not currently support Power Automate. In order to solve the issue better, I suggest you go to Power Automate community to post a discussion.

    Have a nice day!

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments