Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Unanswered

Document Checked-in or Checked-out condition True or False

(0) ShareShare
ReportReport
Posted on by

Hi everyone,

I have exhausted all avenues, so would be very grateful for your help. I am new to Flow, so please excuse me if I sound ignorant. So far I have progressed with the information I have found on forums, so thank you.

I am wanting to check whether a file is checked-in or out, and based on the answer check it in or out accordingly. If it is checked-in, then check it out and vice versa. It's a development stage for me to understand how this works.

I have managed to get as far as testing whether the file is Checked-in or Checked-out and the condition returns  the correct answer. I have set up flow to email me the result of the condition, but the condition doesn't follow the appropriate branch.

So to test it I have a file which is checked-out to me in SP. Confirmed.

Flow.JPG

When I test the flow it send me the email (Send an email 3) confirming the file is Checked-out 

Send an email 3.JPG

 

Email receivedEmail received

The flow from the condition 5 is as follows

Condition 5.JPG

 

Now when I test this flow I expect the result of the condition will mean the 'Yes' branch will be followed, because the file is already checked-out, so I want it to be Checked-in. But I receive an error and find the test has gone down the 'No' branch. Inspecting the results of the test the error occurs in the Send an HTTP request to Check-out document step, it states the file is already checked-out. 

Error.JPG

So I seem to be missing something here. I have tested the IsCheckedOut property, which determined it is. I don't understand why the condition is failing as it is also interrogating the same.

 

Interestingly, I changed the condition from "is equal to" to "is not equal to" and the flow worked. This defies logic to me, but I must be not considering something because the file is checked out.  Condition 5.1.JPG

Resulting flow test

Flow 1.JPG

But it only works once, now the file is Checked-in and I try running it again. The file is confirmed Checked-in in the email, but the condition goes down the 'Yes' branch and then gives me an error "the file is already checked-in". I expected it to go down teh 'No' branch. 

 

Any assistance will be greatly appreciated. Apologies this is so long, but I really wanted to make sure I was articulating the problem properly. 

Kind regards,

Russel

  • Community Power Platform Member Profile Picture
    on at
    Re: Document Checked-in or Checked-out condition True or False

    Hi @LeeHarris thank you for your reply.

    The compose was something I only added a day or so ago after reviewing another persons post, but it didn't change the result I received. With or wothout the compose action it acts the same. Thank you for your consideration.

    Compose.JPG

     

  • LeeHarris Profile Picture
    1,026 on at
    Re: Document Checked-in or Checked-out condition True or False

    Hi @Anonymous 

    From the screenshots it looks like the condition is using the output from the Compose action. Are you able to share what this Compose action is doing? If you view the output of this Compose action in a previous Flow run does it display the value you are expecting to see?

     

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,635 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,997 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow