Using Condition with Excel value is not working to send email communication

[sagarbtech008]

Hi All, 

Very good morning. I am new to this platform. Need your support in one issue. I have a Excel Table in which EmailID and WorkTime column are there. In WorkTime column whose value is less than 7 hours, I need to send Mail to them. How can i achieve that using condition. 

Please help me in this regard. How can I send Email communication to those user only who have less than 7 hours WorkTime.

Please see below the Sample Excel Table.

User Name   Employee Id  # Days Worked   # Days Assigned   DiffRank     Work TimeUser Email Id   

Jyothi	51915301	4	22	18	Last 20%	3.63	madathala.nagar@hcl.com
Sagar Sahoo	51515486	18	22	4	Last 20%	7.34	sagarhemaranjan.s@hcl.com
Pitchumani Varathara	51303704	10	22	12	Last 20%	4.72	pitchumani.v@hcl.com
Chidanand Bangalore	40108804	20	22	2	Mid 60%	7.63	chidanand.kb@hcl.com
Venkata Prasad	51832483	21	22	1	Last 20%	7.62	venkataprasad@hcl.com

Regards,

Sagar

[v-hanytian-msft]

Hi @sagarbtech008 ,

May I ask what formula in the Condition and Filter Array?

According to your Error Message, we Suggest use float().

We made a Sample for you.

Data Source:

Power Automate:

If Yes:

Testing:

Hope this will help you,

Best Regards,
Tina

[sagarbtech008]

Hi @v-hanytian-msft ,

Thanks for your quick response. Followed the way you have advised, but in the end getting this error. Can you please help me to resolve this! Is there something which I am missing here. 

Regards,

Sagar

[v-hanytian-msft]

Hi @sagarbtech008 ,

May I ask what formulas in the Actions in the Screenshot?

Best Regards,
Tina

[sagarbtech008]

Hi @v-hanytian-msft ,

Posting the entire flow here. Hope it might help to identify the problem.

That is the entire flow. And the excel is basic one having those columns with Value.

User Name   Employee Id  # Days Worked   # Days Assigned   DiffRank     Work TimeDaily EstimatedTime  Unaccounted Time   User Email Id   

Jyothi	51915301	4	22	18	Last 20%	3.63	8.18	4.54	madathala.nagar@hcl.com
Sagar Sahoo	51515486	18	22	4	Last 20%	7.34	8.01	3.66	sagarhemaranjan.s@hcl.com
Pitchumani Varathara	51303704	10	22	12	Last 20%	4.72	6.18	1.47	pitchumani.v@hcl.com
Chidanand Bangalore	40108804	20	22	2	Mid 60%	7.63	8.83	1	chidanand.kb@hcl.com
Venkata Prasad	51832483	21	22	1	Last 20%	7.62	8.82	1	venkataprasad@hcl.com

Regards,

Sagar

[v-hanytian-msft · Accepted solution]

Hi @sagarbtech008 ,

Please replace the Output('Compose_2') of he Output of Condition,

Hope this will help you,

Best Regards,
Tina

[sagarbtech008]

Hi @v-hanytian-msft ,

Thanks a lot for your quick support. It helped me to get the desired result. it is working fine now. 

Really Appreciated. If I want to apply one more condition  like In that table one column is "Band". I want to send communication to those users who are E0,E1,E2 band along with Work Time less than 7 hours.

Please guide me how can I achieve this multiple condition !

Thanks a lot again for your timely support.

Regards,

Sagar