Skip to main content

Notifications

Power Automate - Using Flows
Answered

Track Outlook Emails in Excel - Received Time will not pull

(0) ShareShare
ReportReport
Posted on by 8

Hi there

 

Looking for some help, I'm trying to use the template for pulling email activity into excel. I've set the spreadsheet up as directed in the template and connected successfuly. 

 

The trouble is, Received Time is not auto populated as below:

 

Capture1.PNG

 

If I leave as is, the flow runs and pulls in the other info (Subject, From, CC). If I add in Received Time dynamic content, the flow does not run as below:

 

Capture2.PNG

 

My Table is set up in Excel Online as below:

Capture3.PNG

 

Any help would be appreciated, as this is an official (and seemingly simple) Flow template, I'm not sure what's causing the issue.

 

Thanks in advance. 

 

Gary

  • Gary4279 Profile Picture
    Gary4279 8 on at
    Re: Track Outlook Emails in Excel - Received Time will not pull

    Hi both

     

    Thank you very much for your help. The issue is now resolved. 

     

    Really appreciate the support.

     

    Gary

  • Verified answer
    v-yamao-msft Profile Picture
    v-yamao-msft on at
    Re: Track Outlook Emails in Excel - Received Time will not pull

    Hi Gary4279,

     

    When using the template Track Outlook Emails in Excel, the dynamic content for Received time won’t be auto populated to this filed, you need to select it from the dynamic contents.

    3.PNG

     

    As @efialttes suggested, please close the Excel table when flow is trying to save data to it, otherwise the error “File is being blocked” would be thrown.

     

    Best regards,
    Mabel Mao

     

  • Verified answer
    efialttes Profile Picture
    efialttes 14,756 on at
    Re: Track Outlook Emails in Excel - Received Time will not pull

    Acording to the error shown in Run History->Insert Row->Outputs->Body, "File is locked" (not 100% sure of this text, I had to zoom on the image)

    This typically means Excel file is open

    I got crazy some months ago with the same issue

    Hope this helps

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,304

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard

Featured topics

Restore a deleted flow