Power Platform Community Forum Thread Details

Hello

I have a form that is completed, which asked for budget for a number of elements. However sometimes not all elements will be needed therefore sometimes there is no data in the budget field. i.e. one time it could be Accom, 100, Rail, 50, Meals, 100. the next time it may be Car Hire 100, Meals 30, Mileage 100.

I want to convert all the totals into currency format when I am inputting the results into a sharepoint list as it looks nicer. I have used a compose to convert the totals from a string to a float and then used the Format numbers. This works, however it fails when some of the total fields are missed because they are not needed.

Therefore I think in my compose I need to put:

If (carhirebudget) not empty, then convert to a float

However I am only just learning expressions and I can not get these to convert. I have managed to write the empty function and know it returns a true or false but then I cant get it to then convert the string to a float if not empty.

I attempted this:

If(empty(body('Get_response_details')?['rcarehirebudget'], '0', 'true', 'false' float(body('Get_response_details')?['carhirebudget'])))

but it states it is invalid

Any help on this would be greatly appreciated

Categories:

General topics