Skip to main content

Notifications

Power Platform Community / Forums / General / How to remove duplicat...
General
Answered

How to remove duplicated item from an array variable?

(0) ShareShare
ReportReport
Posted on by theMac 186

With PA I get rows from an excel and store them in an array variable.
Now I need to obtain the array without duplicated items (I want just one occurrency of items), is there a simple way to do that?

Categories:
General
  • Verified answer
    Expiscornovus Profile Picture
    Expiscornovus 1,637 on at
    Re: How to remove duplicated item from an array variable?

    Hi @theMac,

     

    You can use a union function for this.

     

    Below is an example

     

    union(variables('ArrayVar'),variables('ArrayVar'))

     

    unionfunction.png

     

    Below would be the result

     

    testresult_union.png

Helpful resources

Quick Links

Exciting News for Copilot Studio Communi…

Get ready to experience a whole new level of engagement with the Copilot Studio…

Celebrating the May Super User of the…

LaurensM is an exceptional contributor to the Power Platform Community…

Check out the Copilot Studio Cookbook…

We are excited to announce our new Copilot Cookbook Gallery in the Community…

more Community News

Leaderboard

#1
renatoromao Profile Picture

renatoromao 6,459

#2
Pstork1 Profile Picture

Pstork1 1,954

#3
Expiscornovus Profile Picture

Expiscornovus 1,637

Leaderboard

Featured topics

Please Read for Updates on Forums & Blogs

Tips & tricks for using the Power Virtual Agents Boost Conversational Coverage Preview

Product updates

Microsoft Copilot Studio Community release plans