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

Community site session details

Session Id : a+YR30ku6t/rdD/qK07NoE
Power Automate - Power Automate Desktop
Unanswered

Update File Properties | Doesn't Work For Choice Column In SharePoint

Like (1) ShareShare
ReportReport
Posted on 13 Jul 2024 12:59:31 by 7

After Power Automate Desktop has uploaded a document to an application from a SharePoint Library, I want it to change a column in that library from No to Yes, to reflect the success of the upload. (The SharePoint column is a 'Choice' column which only accepts Yes/No values or is null. It's the same as a boolean or logical column in other contexts. It's often visually represented by an On/Off toggle or switch.)

However, although I can update many SharePoint file properties successfully in Power Automate Desktop, this kind does not work. Whenever I make the change in Power Automate Desktop, when I reopen it, the change has gone back to 'No'.

In other words, this ...

TomChivs_1-1720874552337.png

... after pressing save here ...

TomChivs_0-1720874534597.png

... turns into this ...

TomChivs_2-1720875484415.png

I'm totally stuck! Any ideas?

 

  • TomChivs Profile Picture
    7 on 13 Jul 2024 at 14:05:27
    Re: Update File Properties | Doesn't Work For Choice Column In SharePoint

    Yes, I've run the workflow as I thought it might just default back to "No" on opening the step. But it didn't make any difference.

    I'm working on a server which is connect to a couple of processes so prefer not to restart it unless required...

    Here's the SharePoint Library - it's empty because I've just deleted all of the test data.

    TomChivs_1-1720879463185.png

    (I do have a workaround which is to use a text-based proxy column, have Power Automate Desktop update that to True, and then have Power Automate update the proper column in response to that. However, it is not ideal as it creates an extra thing to go wrong, and ideally I would prefer to do it all in the Desktop flow for obvious reasons.)

    All help much appreciated!





  • Sayan Profile Picture
    789 Super User 2025 Season 2 on 13 Jul 2024 at 13:42:50
    Re: Update File Properties | Doesn't Work For Choice Column In SharePoint

    Hey @TomChivs 

     

    Have you run the Workflow?

    This situation I have also faced some time. You can restart your computer once and then try to update the

    SharePoint column.

    can you please share the screenshot of the SharePoint.

     

    ------------------------------------------------------------------------------------------------------------------------------

    If my suggestion helps you, Gives it a Thumbs up 👍 and Marks as a Solution ✔️. Which motivates to solve more problems.

    Thanks,

    Sayan Patra | Consultant RPA Developer

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

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 986 Moderator

#2
stampcoin Profile Picture

stampcoin 699 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 577 Super User 2025 Season 2

Loading complete