So a have a live database which in turn has a Live dashboard in excel which is comprised of tables. I need to send a wf when a fail column hits a certain number. Can someone help?
you should be able to use a condiition for this using the Is Equal To condition.
under the No condition, meaning its not equal to the value in question, you can use a terminate action.
So I know I have to use recurrance as it needs to keep looking at it. I have tried with the Excel business get row, then condition, my info and I have my send email but it returns a bad gateway on the excelis there something else I should be using? Used to Sharepoint designer. sorry
Hi @cynde001,
Could you please share a screenshot of your flow's configuration?
Where does your Excel file store? OneDrive folder or SharePoint library?
Further, could you please show more details about your Excel table?
I have created a Excel file on my side and the data structure of it as below:
I assume that your Excel file is stored in your SharePoint library and you want to send an email notification when the Retweet count column hits 100.
I have made a test on my side and please take a try with the following workaround:
@equals(int(items('Apply_to_each')?['Retweet count']), 100)
Within "If/yes" branch of Condition, add a "Send an email" action.
Note: The Retweet count is a column in my Excel table, on your side, you should change the Retweet count into the column that you want to detect within your Excel table.
Image reference:
The flow works successfully as below:
Best regards,
Kris
v-xida-msft - i have tried your way. However it does reside on my One Drive and I am getting a bad gateway error now. If I put it on sharepoint my data connections dont work. It was created before we started using 365 and need to have this excel file for data.
Here is my excel sheet the data comes from a line on the production floor. so when the fail hits 3,. i need it to send an email.
Here is my excel sheet the data comes from a line on the production floor. so when the fail hits 3,. i need it to send an email.
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
User | Count |
---|---|
45 | |
45 | |
39 | |
35 | |
23 |
User | Count |
---|---|
48 | |
32 | |
31 | |
30 | |
29 |