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 - Building Flows / creating email flow us...
Power Automate - Building Flows
Unanswered

creating email flow using excel data

(0) ShareShare
ReportReport
Posted on by jashneelmani

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

 

 

I have the same question (0)
  • abm abm Profile Picture
    abm abm 32,605 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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 560 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 347 Moderator

#3
Expiscornovus Profile Picture

Expiscornovus 262 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!
Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans