web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Filtering Numbers from...
Power Automate
Answered

Filtering Numbers from Array in Power Automate

(1) ShareShare
ReportReport
Posted on by 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.

 

hitakshi_0-1701064976075.png

 

 

Thank you in advance!

Hitakshi

Categories:
  • sandeepstw Profile Picture
    312 Moderator on at

    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 

     
  • sandeepstw Profile Picture
    312 Moderator on at

    Thanks,

     

    Please mark as solution, if it works. 

  • hitakshi Profile Picture
    162 on at

    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.

  • Verified answer
    v-yetonggu-msft Profile Picture
    Microsoft Employee on at

    Hi @hitakshi ,

    I did a test for your reference.

    In my scenario:

    vyetonggumsft_0-1701065955484.png

    vyetonggumsft_2-1701066071054.png

    length(item())

    Best Regards,

    Sunshine Gu

  • hitakshi Profile Picture
    162 on at

    Can you give me another solution?

  • v-yetonggu-msft Profile Picture
    Microsoft Employee on at

    Hi @hitakshi ,

    Is there anything wrong with my solution?

    Could you please try my solution?

     

    Best Regards,

    Sunshine Gu

  • hitakshi Profile Picture
    162 on at

    Hi @v-yetonggu-msft 

    These values have come from This given variable

    hitakshi_0-1701066651544.png

    I would like to filter out the numbers from this.

  • v-yetonggu-msft Profile Picture
    Microsoft Employee on at

    Hi @hitakshi ,

    Please change the String type to 'Array' type.

    vyetonggumsft_0-1701067216642.png

    vyetonggumsft_2-1701067381958.png

    Best Regards,

    Sunshine Gu

  • sandeepstw Profile Picture
    312 Moderator on at
    {
      "type": "If",
      "expression": {
        "and": [
          {
            "not": {
              "equals": [
                "@isInt(item().columnname)",
                "@bool('false')"
              ]
            }
          }
        ]
      },
      "actions": {},
      "else": {
        "actions": {}
      }
    }
  • sandeepstw Profile Picture
    312 Moderator on at

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 414

#2
11manish Profile Picture

11manish 335 Super User 2026 Season 2

#3
M Bilal Khan Profile Picture

M Bilal Khan 274

Last 30 days Overall leaderboard