cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
derekma19
Regular Visitor

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

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 1Column 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

 

 

 

0 REPLIES 0

Helpful resources

Announcements
October Events

Mark Your Calendars

So many events happening this month - don't miss out!

 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

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

Users online (2,024)