Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am more familiar with Power Automate than Power Bi. I have done a couple of project using Power Bi. I am sure I have no concept of its full capabilities. Here is my situation...
I utitilize a large Excel doc which i have to create relationships to get the data to talk to each sheet. What I have been asked to do is create an email to the client when their case goes from Open to Closed. It is a questionnaire to ask about their service. It already has rows into the thousands. I used this forum entry: How do I send a custom email to each email in a column. It has me on the right track. What I do not want to happen is an individual gets a duplicate email each time the flow is ran. I am unable to delete the data. What I was thinking about is if once the case is closed, an email is sent and the row with the information is moved to another sheet or something of which could be distingiushed after the initial run.
Any suggestions?
Hi @aboynamedsue ,
In order to make it work there are certain points:
So just to recreate your scenario i have used the following dataset:
Table containing the case information.
Table containing member information
These two tables are joined basis member id.
Now create a flow like this:
When you will trigger this flow you will get an email like this:
Hope this helps !!
Please accept this as a solution if your question has been answered !!
Appreciate a Kudos 😀
Connect with me on LinkedIn: https://www.linkedin.com/in/jaideepnema/
I can't seem to get the flow to run.
I have the Power Bi Pro version and have been using Power Bi Desktop.
How about adding a 0/1 column that you check before sending an email?
Initialize the column to all 0 but whenever you send an email, update it to 1. Set a rule in your automation that only rows with 0 get sent.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.