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
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,
Hi @DarmonGill
But 'isNumeric' is not defined or not valid.' In Power Automate.
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:
Gill
WarrenBelz
146,786
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,093
Most Valuable Professional