Answered

Sending email from new excel rows and marking as sent

(0) Share

Report

Posted on by AdamPorter

Hi, Relatively new to flows so apologies if this is a simple request.

Each time there is a form submission I want to send an email containing row data. I cannot do this direct from the form since there is are look-ups on the excel file for additional data.

My solution was to look in column for blanks and send an email for each matching row and updating the blank cell with the time & date (so it will not be picked-up subsequently.

This isn't working however.... Any ideas?

I have the same question (0)

All responses (5)

Answers (1)

Michael E. Gernaey 52,897 Super User 2025 Season 2 on at

Like (1)

Report

Re: Sending email from new excel rows and marking as sent

Hi,

Welcome and sorry for your troubles. Can you give details on what is not working?

Please give a detailed step by step of what you want it to do so we can compare that to what it does and also any errors etc and would be happy to look 🙂

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
AdamPorter 44 on at

Like (0)

Report

Re: Sending email from new excel rows and marking as sent

Thank you! I am looking for:
- run a regular scheduled flow
- Identifies all rows which have a blank cell in column 'Feedback Email Sent?'
- For each match, sends an email
- And then fills the identified blank cell with the time and date (so as not to be picked up in subsequent runs)

Was this reply helpful? Yes No
Michael E. Gernaey 52,897 Super User 2025 Season 2 on at

Like (1)

Report

Re: Sending email from new excel rows and marking as sent

Hi

so sorry was on my phone. In your filter you need to put [] around the column name since it has spaces

and you might want to try [field name] eq null

exactly like that

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
AdamPorter 44 on at

Like (0)

Report

Re: Sending email from new excel rows and marking as sent

I have renamed the original excel column to 'FeedbackEmailSent' to remove spaces and question mark for simplicity. I have also edited the filter query to contains(FeedbackEmailSent,'')

It looks like it may work, just have some bits to iron out. Thanks for the help!

Was this reply helpful? Yes No
Verified answer

AdamPorter 44 on at

Like (0)

Report

Re: Sending email from new excel rows and marking as sent

After some support from FLMike and further work I have found a solution:

I removed the filter query entirely and instead added a condition later to check for blank cells:

Was this reply helpful? Yes No