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 : orf+TxpPeYsp4axTG9lwkP
Power Automate - General Discussion
Answered

error converting data from Excel

Like (0) ShareShare
ReportReport
Posted on 22 Dec 2022 18:38:57 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.

I have the same question (0)
  • Kabilesh Profile Picture
    177 on 22 Dec 2022 at 18:44:25
    Re: error converting data from Excel

    Hi @Prin1790 

     

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

     

    Best Regards,

    VK

  • Prin1790 Profile Picture
    13 on 22 Dec 2022 at 18:50:47
    Re: error converting data from Excel

    screens attach

  • SudeepGhatakNZ Profile Picture
    14,381 Most Valuable Professional on 22 Dec 2022 at 20:47:29
    Re: error converting data from Excel

    @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 22 Dec 2022 at 21:25:39
    Re: error converting data from Excel

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

  • SudeepGhatakNZ Profile Picture
    14,381 Most Valuable Professional on 22 Dec 2022 at 23:30:45
    Re: error converting data from Excel

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

     

  • Verified answer
    Kabilesh Profile Picture
    177 on 23 Dec 2022 at 04:19:51
    Re: error converting data from Excel

    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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Tom Macfarlan – Community Spotlight

We are honored to recognize Tom Macfarlan as our Community Spotlight for October…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 707 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 499 Moderator

#3
chiaraalina Profile Picture

chiaraalina 312

Last 30 days Overall leaderboard