Unanswered

Replace a number in a field with a Text Value.

(0) Share

Report

Posted on by rowan_preston

I'm setting up an export in power automate for users (will run from canvas app) and in one of the fields I ideally would like to show them a text value instead of the number that is in the field. The number relates either to a customer type and the text value is not contained in the table anywhere. Can I hardcode this into Automate with an IF statement or something? I've tried a few things but keep getting the 'statement is invalid'!

eg: the field 'Category Code' - CMTYPE has a value of 0-5. In my canvas app I use the following formula to display the text the user is expecting:

If(ThisItem.CMTYPE="0","Corporate",If(ThisItem.CMTYPE="1","Green Grass",If(ThisItem.CMTYPE="2","Off Course",If(ThisItem.CMTYPE="E","International",If(ThisItem.CMTYPE="3","Sporting Goods",If(ThisItem.CMTYPE="4","Driving Range",If(ThisItem.CMTYPE="5","Other",ThisItem.CMTYPE)))))))

Appreciate any help.

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

Sort by

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @rowan_preston ,

Please try:

If( equals(ThisItem.CMTYPE,'0'), 'Corporate', If( equals(ThisItem.CMTYPE,'1'), 'Green Grass', If( equlas(ThisItem.CMTYPE,'2'), 'Off Course', .....

Best Regards,

Bof

Was this reply helpful? Yes No
Chriddle 8,674 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Adress it with item()['CMTYPE']

Was this reply helpful? Yes No
Chriddle 8,674 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
You may also consider to change the nested IFs to an object like this:

{ "0": "Corporate", "1": "Green Grass", "2": "Off Course", "E": "International" }

and use this with following expression:

coalesce(outputs('Compose')?[item()['CMTYPE']], item()['CMTYPE'])

Example flow:

Since this example flow only loops over the CMTYPE's values, the expression look a bit different:

coalesce(outputs('Compose')?[item()], item())

Was this reply helpful? Yes No