I'm looking for some time to transfer fields from a sharepoint list to a sharepoint library from which they come in word files.
Everything normally happens until the arrival of calculated fields. Word does not recognize calculated fields, and it is not possible to transfer the result of a calculated field via Flow, at least not in a number column.
on the other hand, I just discovered that it is possible to transfer the result of a calculated field of a list to a text field of a library, why not, the transmitted element is left with a sequence of zero and the "," is converted to "." ... but it works ... If once the flow is done, we change the type of fields of the library in number, it always works, and the element transmitted is a figure according to the parameters of the field ... I nevertheless think that this solution is not very conventional. What do you think?
So, we will need some more detail to think this through with you - Calcualted fields are usually just that - calculated from other values in the list / library. So why not simply pass the values that need to be calculated (assuming numbers, dates etc) into normal filed types and set up the calculated field in the new location to do its "calculation" there?
I had thought about this solution, but the calculated fields are not selectable in the properties of a word file (quickpart). It is for this reason that I transfer the results of the fields.
Hi @sharonsumner ,
The principle is that the user completes a sharepoint list form, with the information entered, some calculations are in other columns. Then actually with a sharepoint designer workflow , all the fields are transferred in a library to fill a word document in which the fields are called via the function "quickpart" "document properties".
So I try to replace this sharepoint designer workflow with a flow, on the principle all walks except that it seems to me that the circumvention of the calculated fields by making them point to text columns that I change afterwards in number field does not seem to me very much "clean"... But that works!
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!
We've given our badges an overhaul and also added some brand new ones!
Learn how to build the business apps that you need.
Find out where you can attend!
Watch & learn from the Power Automate Community Video Gallery!