Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

Send email based on whether an excel row and column has been updated based on date

(0) ShareShare
ReportReport
Posted on by

Hi, 

 

I have a resource excel file that is updated every month for 3 months in advance which is send using a flow for people to update. 

 

I want to send an email based on columns that have not been updated to the various people or people that have not accessed the file, and I am not sure if this can be done or not so asking here. 

 

 

thanks in advance

  • Re: Send email based on whether an excel row and column has been updated based on date

    Yes, so there is a column of accountable person emails then several rows from that column for the various roles they are carrying out, and then several columns for dates so they can input their resource capacity against the roles for that month.

  • Nived_Nambiar Profile Picture
    Nived_Nambiar 17,076 on at
    Re: Send email based on whether an excel row and column has been updated based on date

    Hi @PowerAutoNewb 

     

    One more question - does the user who updated the excel row would be present as column in excel sheet ?

    Also is there any unique identifier in the excel sheet , also do we need to send email to user along with which columns need to be updated within the row ?

     

    Kindly let me know 🙂

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel

    🔍 Found my answer helpful? Please consider marking it as the solution!
    Your appreciation keeps me motivated. Thank you! 🙌

  • Re: Send email based on whether an excel row and column has been updated based on date

    The columns and rows will either be blank or have a 0 there. The resource planner requires to have a value greater than this. Can this be done via flow instead of manually looking if a value has been input. 

  • Nived_Nambiar Profile Picture
    Nived_Nambiar 17,076 on at
    Re: Send email based on whether an excel row and column has been updated based on date

    Hi @PowerAutoNewb 

     

    does the fields which is not meant that it is empty before ?

     

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel

    🔍 Found my answer helpful? Please consider marking it as the solution!
    Your appreciation keeps me motivated. Thank you! 🙌

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