Power Platform Community Forum Thread Details

I'm utilizing add a row to Excel table in Power Automate and using the following expression in Power Automate to produces exactly the same logic as my List formula, but as text expression in excel such as:

5 visits x $50 = $250 for Pediatrician

3 visits x $23 = $69 for APP

2 visits x $58 = $116 for Adult MD-DO

Expression in Power Automate

if( equals(triggerOutputs()?['body/PositionType'],'Pediatrician'), concat( string(triggerOutputs()?['body/NumberofCompletedVisits']), ' visits x $50 = $', string( mul( int(triggerOutputs()?['body/NumberofCompletedVisits']), 50 ) ) ), if( equals(triggerOutputs()?['body/PositionType'],'APP'), concat( string(triggerOutputs()?['body/NumberofCompletedVisits']), ' visits x $23 = $', string( mul( int(triggerOutputs()?['body/NumberofCompletedVisits']), 23 ) ) ), if( equals(triggerOutputs()?['body/PositionType'],'Adult MD-DO'), concat( string(triggerOutputs()?['body/NumberofCompletedVisits']), ' visits x $58 = $', string( mul( int(triggerOutputs()?['body/NumberofCompletedVisits']), 58 ) ) ), '0 visits x $0 = $0' ) ) )

My return output from the above expression is the following: Although My column (Number of Completed Visits) in Microsoft List has a value of 12. I need to show the work for submission 12 visits x $23 = $276.00 for APP.

My column names are: Number of Completed Visits, Position Type, and Total Pay Per Visit.

I'm at a loss. Any help would be appreciated.

Thanks.

Hi @CU01042039-0,

The issue is not the business logic, but data typing and field references in Power Automate.

Root causes:

Microsoft List numeric columns often come through as strings
The field name must match the internal column name exactly
The expression needs explicit type casting
Excel text formatting does not auto‑format currency

Fixing all four ensures the output becomes:

12 visits x $23 = $276.00 for APP

if(
  equals(triggerOutputs()?['body/PositionType'], 'APP'),
  concat(
    string(int(triggerOutputs()?['body/NumberofCompletedVisits'])),
    ' visits x $23 = $',
    string(mul(int(triggerOutputs()?['body/NumberofCompletedVisits']), 23)),
    ' for APP'
  ),
  '0 visits x $0 = $0'
)

✅ If this answer helped resolve your issue, please mark it as Accepted so it can help others with the same problem.
👍 Feel free to Like the post if you found it useful.