Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Create a column using SELECT that display a value depending on other column being numeric or not



I have table in Excel with several columns stored in Document Library. I am using a flow with an action "List rows present in a table" to get all rows, then I am using a SELECT to create an array based on this table and create a calculated column that will include any value from Column 1 below that is not a number. This means to pass from this:


Column 1



To this:

Column 1Column 2


Is there any way of building this NOT using an apply to each loop?

In PowerApps this is something like If(IsNumeric([Column 1].Value),[Column 1].Value, Blank()) but IsNumeric doesn't exist in Power Automate as far as I am aware.


I could do it with an Apply To Each, applying a formula and configuring a run after successful/has failed, but as I can have several thousand of rows I don't think it is good approach as I can easily reach the Actions/per day limit.


Any suggestion on the best approach for this?


Thanks in advance






Helpful resources

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Users online (4,790)