Update Items

(0) Share

Report

Posted on by CJ-07071921-0

When using the update item function in power automate is it possible to instead of updating an existing column tied to the ID to have the action create a new column to hold the new values, while saving the old.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Pstork1 68,717 Most Valuable Professional on at

Like (0)

Report

Not really possible. The update item is expecting the list to have a defined schema. You can't change the schema by adding a column on the fly when updating an item.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No
CJ-07071921-0 15 on at

Like (0)

Report

Is there another action that would be able to make this effect possible?

Was this reply helpful? Yes No
Tomac 3,953 Moderator on at

Like (0)

Report

@CJ-07071921-0 Adding new columns can be done, but it's a really, really bad solution. Can you explain the goal of your flow and maybe the community can suggest a better method?

Was this reply helpful? Yes No
Pstork1 68,717 Most Valuable Professional on at

Like (1)

Report

@CJ-07071921-0 The problem is that the SharePoint connector records the schema of the list when you create the connection. If you add a column to the list that column won't be visible in the flow until you delete the connection and re-add it. So although there are actions that can create and modify SharePoint lists using them will automatically invalidate any connection used in an update or create item in the flow. So its really not feasible to do. As @Tomac said, if you give us more information on what you are trying to accomplish we may be able to suggest an alternate approach.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No