I work on SharePoint 2019 and I have a list containing name(type: text) and price (type: currency) of food columns. How can I fetch them to other custom forms?

I use lookup type in the custom form to connect List but I can't achieve price column because of currency type.

In Lookup column not showing currency columns, told to create a workflow to transfer the currency values to another number or text column, how can I create a workflow to convert type?

1 Answer 1


For this requirement, you need to create a new column of number type to hold the currency value in number format, this column you can refer in your custom forms.

To copy the currency value to number column, you need to create a SPD workflow in your list, where you will have only one action step, Set Field in Current Item, in which set the currency field value to Number field value.

Make this workflow to run on item update and item add. so you need to update all the items in your list. In this way you can bring in all currency value to number.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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