Answered

Filtering Numbers from Array in Power Automate

(1) Share

Report

Posted on by hitakshi

162

Hi @Anonymous @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 (11)

Answers (1)

sandeepstw 312 Moderator on at

Like (1)

Report

Hi There,

You can filter out the numbers from the array of values in Power Automate by using the "Filter array" action with a condition.

isNumeric(item()) == false

Based on value true or false you can take further actions.

Please give kudos and mark as solution if it helps.

Thanks,
Sandeep Mishra

Was this reply helpful? Yes No
sandeepstw 312 Moderator on at

Like (0)

Report

Thanks,

Please mark as solution, if it works.

Was this reply helpful? Yes No
hitakshi 162 on at

Like (1)

Report

Hi @sandeepstw
Thanks for your reply and solution😊,
But 'isNumeric' is not defined or not valid.' In Power Automate.

Can you suggest me another solution Please.

Was this reply helpful? Yes No
Verified answer

v-yetonggu-msft on at

Like (1)

Report
Hi @hitakshi ,
I did a test for your reference.
In my scenario:
length(item())
Best Regards,
Sunshine Gu

Was this reply helpful? Yes No
hitakshi 162 on at

Like (0)

Report

Can you give me another solution?

Was this reply helpful? Yes No
v-yetonggu-msft on at

Like (0)

Report

Hi @hitakshi ，
Is there anything wrong with my solution?
Could you please try my solution?

Best Regards,
Sunshine Gu

Was this reply helpful? Yes No
hitakshi 162 on at

Like (0)

Report

Hi @v-yetonggu-msft

These values have come from This given variable
I would like to filter out the numbers from this.

Was this reply helpful? Yes No
v-yetonggu-msft on at

Like (1)

Report

Hi @hitakshi ,
Please change the String type to 'Array' type.
Best Regards,
Sunshine Gu

Was this reply helpful? Yes No
sandeepstw 312 Moderator on at

Like (1)

Report

{
"type": "If",
"expression": {
"and": [
{
"not": {
"equals": [
"@isInt(item().columnname)",
"@bool('false')"
]
}
}
]
},
"actions": {},
"else": {
"actions": {}
}
}

Was this reply helpful? Yes No
sandeepstw 312 Moderator on at

Like (0)

Report

add condition and check if IsInt(column) 'is equal' value 'True'

Was this reply helpful? Yes No