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

[derekma19]

Hi, 

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

1

5677

Random_Text

To this:

Column 1	Column 2
1
5677
	Random_Text

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

dm