I am building a flow that hopefully sends a notification message to a Teams group if a cell in the "% Time Remaining" goes below 15.
This excel sheet will be updated periodically and then the flow will check periodically as well, if a certain row with a cell in the above mentioned column goes below 15 then it triggers it.
I have a draft but it does not have a run action , I am trying to learn and I like this feature in office 365 to automate tasks so some pointers would be useful or even alternatives thanks.
To automate the FLOW you should store Excel in one drive or in SharePoint. Then you can use flow trigger action "When file created or Modified in One drive" or "When file created or Modified in SharePoint".
To further pointer chekout similar post -https://powerusers.microsoft.com/t5/Building-Flows/Excel-File-Updated-Send-Teams-Message-Email/m-p/3...
Tried that but for some reason the Excel sheets dont show up,
the SLA is my target file but it does not appear in power automate. Tried several other share point triggers as well.
You don't need to select file there just the document library as you already doing, in second flow step use "List Row Present In Excel" action to get the rows in excel and apply your other logic.
Here is an example:
Hi @CTovar ,
Please also try this configuration:
Wow this may be very close to the solution although I am getting an error on the condition part, I have tried to change the fields to Fixed Decimal and Double and still no luck and even typing 15.00. Is it because in line 1 there are titles in the table?
Ah I searched around a bit and you came up again in this thread with a potential solution, I am going to try this and lets see if it works.
Hi @CTovar ,
Please try this method:
Hi @CTovar ,
Please ensure that you have filled the output of the Compose 2 in Condition instead of the output of Compose.
The color of the output of Compose 2 has changed, indicating that it has been converted to float.
Make sure that you are indeed configuring the output of Compose 2 in the Condition, and then you can use the following expression to convert the type of 15 to float.
My test results here are correct:
Well that part worked now another error comes up, and I noticed it stops on the first row then it says failed even though there is a 14 in the column below 81 that should flag as true. Is this a limitation of this logic ?
the first row number is 81 so when i set it to float(90) it works because the 81 is less than 90 but it still shows as failed in the runs.
If i do float(15) it fails and it wont send a message even though there is a 14.. 3 rows down.. the logic is "list rows present" so i would hope it would list the rows that are less than 15
You should click Next fails to check the output of Compose and Compose 2. Please try to troubleshoot according to the information displayed in the error message.
Check out new user group experience and if you are a leader please create your group
See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.
Many congratulations to the Season 1 2021 Flownaut Crew!
ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.