cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
EcklerAdmin
Frequent Visitor

unique items from Sharepoint list

So, I've tried and tried all day.  I can't figure it out.

 

I have 1 sharepoint list.  It handles the Daily sheets my guys turn in.

We log by JobNumber.  So, this list has a column, JobNumber, where the same number can be repeated multiple time.
I only need it once.

Can someone point me in a direction.

I'm sure I'm going a Union Statement and Some Arrays....but could someone draw it out for me?  I'd be grateful.  Thanks.

1 ACCEPTED SOLUTION

Accepted Solutions

 

Hi @EcklerAdmin ,

 

Please refer to the following method to configure Flow.

110.PNG

Details in apply to each:

111.PNG

Expression reference:

union(variables('Number'),variables('Number'))

Please take a try.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
abm
Super User
Super User

Hi @EcklerAdmin 

 

You can use Get items and specify the Filter Query and set the Top Count as 1. This will return only 1 record if there are more than one items.

 

image.png



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials
EcklerAdmin
Frequent Visitor

I'm sorry I didn't make myself clear...I will try again.

I have a column.

 

1

1

1

2

2

3

3

 

I need a result of 1,2,3

 

Untitled.png

That's what i have so far, I get nothing.  😞  

Hi,

 

Move the 2 actions you have outside of the loop (below it)

 

Use add to array variable action and insert your JobNumbers field from the SharePoint Loop.

 

Now your array contains all the duplicate values, then your other actions clean it up.

 

Hi @EcklerAdmin ,

 

Please refer to the following method to configure Flow.

110.PNG

Details in apply to each:

111.PNG

Expression reference:

union(variables('Number'),variables('Number'))

Please take a try.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (1,882)