cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Advocate III
Advocate III

Using Integers from an Excel Get Rows

There have been some updates to the Excel Get Rows actions. I used a function to calculate the inverse of a column and update a sharepoint list with the new (now positive) value. 

 

mul(items(*Action*)?['Amount'],-1)

 

In the last month since I used that formula some updates were made that changed the way Flow recognizes this column and now pulls as a string instead of an integer.

 

Is there an fix for this while MS tries figure out how to recognize a column thats fomatted as a number (currency, amount, ect)?

5 REPLIES 5
Highlighted
Community Support
Community Support

Re: Using Integers from an Excel Get Rows

Hi @crf200,

 

Do you want the Amount column in excel table to be seen as number type?

 

I have made a test on my side, if you want the Amount column in excel table to be seen as number type, you could add a int() expression beside the expression of the Amount column, and the expression on your side should be :

mul(int(items(*Action*)?['Amount']),-1)

 

Best regards,

Alice

Highlighted
Advocate III
Advocate III

Re: Using Integers from an Excel Get Rows

Hi Alice,

 

Int Capture.JPG

 

 

 

 

 

Its not recognizing the string as a valid parameter.

 

I've even separated the int() into a separate compose with the same outcome.

 

-Chad

 

Highlighted
Community Support
Community Support

Re: Using Integers from an Excel Get Rows

Hi @crf200,

 

Please don't rename the Apply to each on your side, I afraid that the expression in invalid for you have rename the Appply to each with wrong formate name.

 

I have made a test on my side, the screenshot of the flow as below:

Capture.PNG

 

The expression in the Condition as below:

mul(int(items('Apply_to_each')?['Amount']),-1)

The flow would run successfully as below:

Capture.PNG

 

 

Best regards,

Alice

 

 

Highlighted
Advocate III
Advocate III

Re: Using Integers from an Excel Get Rows

I completely redesigned the flow as it worked for some list items but would fail on others when it was built just like that. I saw the new 'List Items from Table' that connects with Sharepoint Online so adopted it on the rebuild so other members of my team can also have access to the files.Capture 1.PNG

 

 

 

 

 

The new action uses Excel Online but even opening the online file and ensuring the columns were formatted appropriately the flow still failed.Capture.PNG

 

 

 

Highlighted
Advocate III
Advocate III

Re: Using Integers from an Excel Get Rows

I've been running some recent tests and I've found a formula that works on only some entries but fails on others. 

 

mul(int(items('ATE2')?['Amount']), int(-1))
 

Any other ideas?

 

Failed.PNGSuccess.PNG

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (3,474)