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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / error converting data ...
Power Automate
Unanswered

error converting data from Excel

(0) ShareShare
ReportReport
Posted on by 13

Hello,

I'm new to Microsoft Power Automate. I have an Excel file table with 4 columns and one of the columns is 'Amount' where the data in Currency format in Excel

I need to read the data from the Excel where the Amount is greater than $200

 

For this, I have the following on My Flows:

 

1. List rows present in Table

2. Apply to each

   Select an output from the previous steps: = value

   Condition is Amount greater than 200

 

Fails at 'Apply to each' step. Shows an error 'Unable to process template language expression for action 'Condition' at line '0' and column '0'. 'The template language function 'greater' expects two parameter of matching types. The function was invoked with values of type 'String' and 'Integer' that do not match'. 

 

I used int(200). It still did not work. Can you please assist. Thankyou.

Categories:
I have the same question (0)
  • Kabilesh Profile Picture
    177 on at

    Hi @Prin1790 

     

    can you please share the excel and flow which you have created?

     

    Best Regards,

    VK

  • Prin1790 Profile Picture
    13 on at

    screens attach

  • SudeepGhatakNZ Profile Picture
    14,394 Most Valuable Professional on at

    @Prin1790 ,

    I was able to replicate yur

    It would help if you converted the value from excel into a float or Integer and then compare.

    SudeepGhatakNZ_0-1671742006707.png

     

     

     

  • Prin1790 Profile Picture
    13 on at

    Thanks. @SudeepGhatakNZ  - what's the actual expression ? It's still giving me error

  • SudeepGhatakNZ Profile Picture
    14,394 Most Valuable Professional on at

    Just wrap Int() or Float () around your field like in the screenshot above.

     

  • Verified answer
    Kabilesh Profile Picture
    177 on at

    Hi @Prin1790 

     

    Hope this flow helps you ,

     

    Kabilesh_0-1671768938775.png

     

    Kabilesh_5-1671769073747.png

    Kabilesh_6-1671769103525.png

    Kabilesh_7-1671769115084.png

     

     

    Best Regards,

    VK

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 538 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 405 Moderator

#3
abm abm Profile Picture

abm abm 252 Most Valuable Professional

Last 30 days Overall leaderboard