I am building very simple flow to "Get info from a selected row from an excel table, and "Create a new Item in a sharepoint list".
But for any of the number type columns - there is no dynamic content available. One workaround from your forums is to convert these columns from number to text - but that creates a lot of problems with the list in our case because Unfortunately these number columns are used in calculations on the sharepoint list - when I convert the columns to text - the column using the data for some of the calculations use less than "<" and Greater Than ">" and can not use text, without complex changes to the formula. ( a lot of work and complexity - surely there is a better way?)
Is there a known work around to get numbers into a number type of column when using "flow"?
Appreciate suggestions and advice
You can see that the get action from excel (for business) has the information, but the problem is with the action of creating item in the sharepoint list. In the example below - I have clicked on a "text type of column", and can find the material size data from the excel get action, but when I click on the material size column in the create sharepoint item column (which is a number type of column) there is no dynamic contant available as shown above.
Hi @SharepointRex ,
Could you provide a full screenshot of the Flow configuration?
Like:
You could also use float() function to convert it to a number value, as below:
float(triggerBody()['entity']['MAT SIZE'])
Use Compose to type in Dynamic content you want to use first, and then see what Expression that makes up it is.
Please take a try.
Best Regards,
WarrenBelz
146,745
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,091
Most Valuable Professional