Unanswered

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

(1) Share

Report

Posted on by TomChivs

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 ...

... after pressing save here ...

... turns into this ...

I'm totally stuck! Any ideas?

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Sayan 818 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
TomChivs 7 on at

Like
a
(1)

Report
Copy link

Link copied!

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.

(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!

Was this reply helpful? Yes No