Warm tip: This article is reproduced from stackoverflow.com, please click
sharepoint-online

How do I update a list item after adding it with Power Automate

发布于 2021-03-05 19:34:54

I can't figure out how to do a very simple update of a column value in Power Automate in SharePoint online. I've seen examples of how to update an item on another list, but nothing that updates a value on the same item that was just added and triggered the workflow. Can anybody give me an example and maybe a very brief explanation?

I want to multiply the values of two columns and add it to a third column on the same item which will be blank. I used the formula to update the column I want using values from other columns. =[Dollar Amount]*[% Chance] but it says invalid syntax. There seems to be nothing intuitive in this new power automation and it's a horrible failure compared to how easy it used to be. MS is always making these mistakes.

Questioner
user4274335
Viewed
0
Amos_MSFT 2020-11-18 11:02

The first method, you could use a calculated column.

=[% Chance]*[Dollar Amount]

Second method,use Flow. enter image description here Test result: enter image description here