web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : 1gCvT0BYtoK9z8uSw4W5mP
Power Automate - Using Flows
Answered

Send email with a specific colomn excel

Like (0) ShareShare
ReportReport
Posted on 20 Feb 2024 13:35:39 by 8

Hi everyone,

 

I am using Power Automate with a form trigger. This form allows users to select a material for purchase (we are in a school), and students choose the material and specify the quantity. The data is then transferred to an Excel sheet, which is used for stock management.

Within the flow, I also create a Teams approval request for the requested material, which we manually approve. Now, I want the flow to send an email to the individuals responsible for making a purchase when a material is running low and falls below 20 units.

Unfortunately, I am encountering an issue. Everything else works perfectly fine. I am receiving the message: 'Unable to process template language expressions for action 'Condition_1' at line '0' and column '0': 'The template language function 'lessOrEquals' expects two parameters of matching types. The function was invoked with values of type 'String' and 'Integer' that do not match.'

In my table, there are 5 columns and 10 rows (representing 10 types of materials). I want an email to be sent if a material falls below 20 units. I am also struggling with the 'For each' loop because it sends several emails when I only want to send one.

I am not sure if I am being clear, but I have attached some screenshots. Thank you for your assistance.

Flow1.PNG

Flow2.PNG

Flow3.PNG

Flow4.PNG

flow5.PNG

flow 6.PNG

flow7.PNG

  • LULU5 Profile Picture
    8 on 22 Feb 2024 at 08:06:27
    Re: Send email with a specific colomn excel

    Yes great !

  • Nived_Nambiar Profile Picture
    17,982 Super User 2025 Season 2 on 21 Feb 2024 at 17:18:14
    Re: Send email with a specific colomn excel

    does the issue got resolved ?

     

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel

    🔍 Found my answer helpful? Please consider marking it as the solution!
    Your appreciation keeps me motivated. Thank you! 🙌

  • LULU5 Profile Picture
    8 on 21 Feb 2024 at 08:47:36
    Re: Send email with a specific colomn excel

    Thank you so much i receive emails now !
    It's great!

  • Verified answer
    Nived_Nambiar Profile Picture
    17,982 Super User 2025 Season 2 on 20 Feb 2024 at 17:26:30
    Re: Send email with a specific colomn excel

    Hi @LULU5 

     

    based on error details which you have shared, i think this is due to highlighted content

    Nived_Nambiar_0-1708449902695.png

     

    So may that value is considered as string even though it is integer. So one way would be resolve this error would be to wrap int() function around the highlighted dynaimaic content. I hope that would helps !

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 986 Moderator

#2
stampcoin Profile Picture

stampcoin 699 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 577 Super User 2025 Season 2

Featured topics

Restore a deleted flow
Loading complete