使用 Power Automate 添加列表项后如何更新列表项 [英] How do I update a list item after adding it with Power Automate

问题描述

我不知道如何在 SharePoint Online 中的 Power Automate 中对列值进行非常简单的更新.我已经看到了如何更新另一个列表上的项目的示例，但没有更新刚刚添加并触发工作流程的同一项目上的值.谁能给我一个例子，也许是一个非常简短的解释?

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?

我想将两列的值相乘并将其添加到同一项目的第三列，该列将为空白.我使用公式来更新我想要使用其他列中的值的列.=[Dollar Amount]*[% Chance] 但它说语法无效.这种新的电力自动化似乎没有任何直观之处，与过去的容易程度相比，这是一个可怕的失败.MS 总是犯这些错误.

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.

推荐答案

第一种方法，可以使用计算列.

The first method, you could use a calculated column.

=[% Chance]*[Dollar Amount]

第二种方法，使用Flow.测试结果:

Second method，use Flow. Test result:

这篇关于使用 Power Automate 添加列表项后如何更新列表项的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！