News and Announcements icon

Power Platform CommunityForums Power Automate - Using Flows Excel to email flow no...

Power Automate - Using Flows

Unanswered

Excel to email flow not working- due to formulas in cells?

(0) Share

Report

Report

Posted on by Community Power Pla...

Hello,

I am very new to flows and have created a flow thatsays it is running successfully, however it is not sending

the email that should be being sent.

This flow is supposed to be sending a reminder email based on a date in a column in excel, to an email that is

also contained in a column. However, this email is a Vlookup so the actual cell contains the formula and not

the email. The date is also a formula.

Could this be why the flow is not working?

All responses Img

All responses (3)

Answers Img

Answers (0)

Community Power Pla... on at

Like (0)

Report

Re: Excel to email flow not working- due to formulas in cells?

@Sundeep_Malik
Community Power Pla... on at

Like (0)

Report

Re: Excel to email flow not working- due to formulas in cells?

Hello,

Yes I get the date in the 48038 format (I have the ISO field added too!) BUT the email only sends when I manually enter the data, not when I allow the vlookup to fill in the cells.

This excel is being fed by a form, so essentially it does not work when the form is filled out. Only when I manually enter the data and even still, the date (which is referenced in the sent email) is wrong
Sundeep_Malik 6,480 on at

Like (0)

Report

Re: Excel to email flow not working- due to formulas in cells?

Hey @Anonymous . I don't think that should be a problem. Are you getting the date in 40000 something format.
If this is the cause, you can try the following:
Handling Excel Dates in Microsoft Power Automate (shanebart.com)

I tried it myself and it worked. Hopefully it works for you as well and if it does not, please upload screenshots of the flow in edit mode if possible.

Helpful resources

News and Announcements

🌸 Community Spring Festival 2025 Challenge & Updates🌸

Replay: Power Platform Community AMA - Copilot Studio | April

Welcome to the Power Platform Communities

Quick Links

Leaderboard

#1

WarrenBelz 146,631 Most Valuable Professional

#2

RandyHayes 76,287 Super User 2024 Season 1

#3

Pstork1 65,991 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow

Product updates

Microsoft Power Platform Community release plans