Building Flow that sends a Teams message if a Cell in excel goes below a certain amount

[CTovar]

Hello,

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.Table I am UsingA draft of the flow I am trying to make work

[DeepakS]

Hi @CTovar 

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".

Regards,
DS

[DeepakS]

Hi @CTovar 

To further pointer chekout  similar post -https://powerusers.microsoft.com/t5/Building-Flows/Excel-File-Updated-Send-Teams-Message-Email/m-p/3...

Regards,

DS

[CTovar]

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.

[DeepakS]

Hi @CTovar 

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:

 

Regards,

DS

[v-bacao-msft]

Hi @CTovar ,

Please also try this configuration:

Best Regards,

[CTovar]

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?

[CTovar]

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. 

https://powerusers.microsoft.com/t5/General-Power-Automate/Calculated-Column-flow-error/td-p/399026

[v-bacao-msft]

Hi @CTovar ,

Please try this method:

Best Regards,

[CTovar]

Welp I dont really know what might be going on. 

[v-bacao-msft]

Hi @CTovar ,

Please ensure that you have filled the output of the Compose 2 in Condition instead of the output of Compose.

Try again.

Best Regards,

[CTovar]

I tried both, maybe power automate may not be a good fit. Or a bug may be happening.

[v-bacao-msft]

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:

Best Regards,

[CTovar]

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

[v-bacao-msft]

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.