You’re offline. This is a read only version of the page.
44
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?
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:
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!
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
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)
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
Share
Report
All responses (
Answers (
