web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / creating email flow us...
Power Automate
Unanswered

creating email flow using excel data

(0) ShareShare
ReportReport
Posted on by

Hi,

i am trying to create a flow.

which should send out email to users one every 6 months (interval) until a specific date.

the flow should get the data from a excel sheet.excel table

 any one has ever made something similar to this 

 

thanks

 

 

Categories:
I have the same question (0)
  • abm abm Profile Picture
    32,858 Most Valuable Professional on at
    Re: creating email flow using excel data

    Hi @jashneelmani 

     

    First you need a scheduled trigger for every six months.

     

    image.png

     

    To check a specific date you need the below

     

    image.png

     

    Above the expression I used is  formatDateTime(utcNow(),'yyyy-MM-dd')

     

    Next we need to add Yes and No condition. If the date is reached the specified date we can terminate the flow. If not add the excel connector and access the rows. See below

     

    image.png

     

     

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 462 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 456 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard