1

I have a list with a calculated column (the column takes the value from another column but when there is a value in a second column the calculated column has to take that value =IF(Budget="";[Budget PlusMin];Budget).

I want to use the calculated column value in a flow to assign the value to a normal list item but I can't choose for it. It doesn't show up in the flow.

I can not use sharepoint designer. Is there a possibility to copy the value of a calculated column?

1

I have managed to replace the calculated collumn. I used a flow "when an existing item is modified" I did the action "item update" to put automatically the value Budget PlusMin in the previous named calculated field. Then I tested if the Budget collumn had aan amount > than 0, If yes, then I used 'item update' to put the amount Budget into the previous named calculated collumn. And now I can use that collumn to work within a flow.

But I'm very glad with the answers from Venkat Konjeti. I 'll certainly use that link to have more information about writing code. Thanks a lot!!!

0

I can use the calculated column in Microsoft Flow which I am using to insert the values to another list item. See my below flow

enter image description here

  • Can you tell me know which flow template you used? – NLV Jun 19 '17 at 16:20
  • I have created a custom flow and also got this worked in OOB Templates (Send a customized email when a new SharePoint list item is added) – Venkat Konjeti Jun 19 '17 at 17:04
  • I use "when an existing list item is modified, complete a custom action" – user2136102 Jun 22 '17 at 9:55
  • I want the calculated collomn to become a simple numeric list item. I can't use Designer. – user2136102 Jun 22 '17 at 9:57
  • Will you be able to copy the calculated column to another list item which is your first question? About conversion, you can use "Data Operations" action. You can refer the formulas here docs.microsoft.com/en-us/azure/logic-apps/… – Venkat Konjeti Jun 22 '17 at 13:04

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.