cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JRAMOS1
Regular Visitor

how to control double in a library with power automate or other tools ?

Hello everyone, we have created a sharepoint library where users come to submit documents for validation. These documents have a number given to them by the depositor as well as a revision index. How to check during the deposit that there is no duplicate in the association number+revision index?

Thanks in advance for your help

JRAMOS1_0-1648575870684.png

 

3 REPLIES 3
jnernst
Helper III
Helper III

This may help you out.

"Get Items" of your logged info (For comparison).

Apply to each.

Add an If statement Control.

Have it read as: "If Concat(*Number* + *Revision*) does not equal Concat(*Logged Number* + *Logged Revision*)

Now, your flow is filtered to avoid having duplicates.

 

If you have any questions, don't hesitate to ask. I'll do my best to help you out.

 

Josh

JRAMOS1
Regular Visitor

Thank you jnernst for your answer, it helps for sure.
I have one difficulty: *Number*+*Revision" not available in the choices offered in the dynamic contents for Get ItemS...

 

I only have "Body" & "Value". For the concat() on the Get Item, it is ok...

Thanks again for your light. 

 

JRAMOS1_0-1648634623509.png

 

jnernst
Helper III
Helper III

That's weird, if you are fetching the information correctly it should be there. Are you positive you are getting information from the correct table?

 

I am glad I could help, at least, a little bit. I wish I could have finished the job for you!

 

Josh

 

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022- Season 2 has kicked off!

Users online (4,373)