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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Create new document an...
Power Automate
Unanswered

Create new document and update metadata on SharePoint

(0) ShareShare
ReportReport
Posted on by 11

For the last 6+ years I was using Nintex Workflows so I am fairly new to Flow. In my scenario a user creates a document in a SharePoint library and populates a People column. In my flow I want to use the value from that column and also get the email address and phone number for the user and update the properties. The problem is that it might take a while before that column is populated and the flow is triggered when the file is created. I am trying to use the Do until action with a Condition but it doesn't seem to be working. If the value is not populated immediately (there is a 1 minute delay at the beginning) the Condition is always  resolved to true (Yes). Any idea why? What am I missing here? 2020-12-08_20-37-18.jpg

Categories:
I have the same question (0)
  • sudharsan1985 Profile Picture
    1,325 on at

    Hi @LetMeSP 

    Try to use the check-in & Checkout feature. Check whether the file is checked in state and then trigger the flow. If you make the column mandatory, so that the user when uploads the document, they have to fill in the field, and then they have to check-in. In your flow, you have to check whether the document is checked in or not based on that you can continue with the functionality.

     

  • LetMeSP Profile Picture
    11 on at

    Hi @sudharsan1985 

     

    Thanks for the suggestion - I will give it a try. Do you have any idea why my original solution is not working?

  • Verified answer
    LetMeSP Profile Picture
    11 on at

    I ended up using the solution from this page and it seems to be working: https://www.timlinenterprises.com/power-automate-file-lock-fail/

     

    Thanks

    Igor

  • sudharsan1985 Profile Picture
    1,325 on at

    Hi @LetMeSP 

    I have a doubt about the above solution. When the flow is waiting to update an item what happens if another user tried to update the same item? Since you are using delay, you have to be very cautious and check multiple scenarios before releasing it to the end-users.

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 538 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 405 Moderator

#3
abm abm Profile Picture

abm abm 252 Most Valuable Professional

Last 30 days Overall leaderboard