Answered

Filtering Numbers from Given Array in Power Automate

(0) Share

Report

Posted on by hitakshi

162

Hi @Power @automate @AutoMatey @automate3 @IAutomate @HAutomate @PowerAutomate @powerautomater1 @yipowerautomate @powerautm12 @powerautomate88 @powerautomate17 @o365_comunity ,

I'm working on a Power Automate flow where I have an array of values. The array includes a string. Here is the array:

[
"Current Date/Time",
"1",
"Invoice ID Customer",
"Customer ID",
"Customer tax ID",
"Customer name",
"Customer address",
"Customer address recipient",
"8",
"Billing address recipient",
"Due date",
"Payment terms",
"Invoice amount",
"Amount due",
"Purchase order ID",
"Previous unpaid balance",
"Remittance address",
"Remittance address recipient",
"Service address",
"Service address recipient",
"Service start date",
"End date",
"Shipping address",
"Shipping address recipient",
"Subtotal",
"25",
"Vendor tax ID",
"Vendor name",
"28 ",
"Vendor address recipient"
]

I would like to filter out the numbers from this array, so I'm left only with the string values. How can I achieve this in Power Automate? Any guidance or sample flow would be greatly appreciated.

Thank you in advance!

Hitakshi

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

Gdarmon Outlook 372 on at

Like (1)

Report
Copy link

Link copied!
In Power Automate, you can use the "Filter array" action combined with an expression to achieve this task. You can create a flow that filters out the numeric values from the array of strings using the isNumeric function available in Power Automate.
Here are the steps to achieve this:
Initialize your array: Set up an action to initialize your array of values.
Filter array action: Add a "Filter array" action in your flow.
Set the Filter array action configuration:
Use the expression not(isNumeric(item())) or isString(item()) within the Filter array action. This expression checks if the current item in the array is not a number.
Gill

Was this reply helpful? Yes No
hitakshi 162 on at

Like (0)

Report
Copy link

Link copied!

Hi @DarmonGill
But 'isNumeric' is not defined or not valid.' In Power Automate.

Was this reply helpful? Yes No
Gdarmon Outlook 372 on at

Like (0)

Report
Copy link

Link copied!

try this
Check if a variable is numeric - Power Automate | Microsoft Learn

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @hitakshi ,

You can use isInt function.

To get string values instead of numbers, change the order or elements in the if statement:

if(isInt(item()),'',item())

Best regards,

Was this reply helpful? Yes No