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
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.
The flow works successfully as below:
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.
Check out new user group experience and if you are a leader please create your group
May the fourth be with you, join us online!
See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.
ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.