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
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
69 | |
23 | |
17 | |
16 | |
13 |
User | Count |
---|---|
123 | |
35 | |
33 | |
28 | |
26 |