Market Value on Fund

@Bob Rickards
if the external source is an excel file that you have access to modify, make the range in the excel as table, then you can get row in a table by a “key”, which is your fund id.

if the external source is sharepoint, you can use ODATA Filter.

@Bob Rickards
show a screenshot of the output from the action which you are getting the “number” that you are trying to do formating, so I can see what the data type is you are working with before suggesting what expression to use.

I'm assuming your data type is probably string and the dollar sign is part of the string, if that's the case, you may want to update your SP list data type if you want better handling.. or leave it but will need to do a “replace” first. But let's start with a screenshot

@Bob Rickards
need the screenshot for the Get a row action's output where the 30533.42 came from

@Bob Rickards
need the output body. your screenshot cuts off with only 4 lines shown..

this is where the new “view” doesn't do well.. can't display the output of the action well..

once back to the “old view”, click on “Show raw outputs” and screenshot where the “body” begins

@Bob Rickards
given that MarketValue is a string, the expression is:

if(empty(outputs('Get_a_row')?['body/MarketValue']), '', formatNumber(float(outputs('Get_a_row')?['body/MarketValue']), 'c'))

this takes care of IF the MarketValue is blank (but not take care of if MarketValue is not a number.

this use float() b/c your MarketValue can be decimal, as int() will not do decimal.