Replacing Different Possible Text Strings to One Output

[JCH92]

I hope I can explain this correctly!

I have a Microsoft Form that is giving me the name of an Exhibition, it could be one of multiple different exhibitions and I am having to replace the text name of the exhibition to the GUID value of the exhibition from the choices in the column 'Exhibition'.  I'm doing this so I can have the Form create a lead record in Dynamics automatically. 

At the moment I have this working but it only allows me to have one choice of exhibition in the form:

replace(outputs('InputExhibitionName'),'ExhibitionA','100000008')

I believe it must be a singular output so that the Dynamics 'Create a new record' can be successful.

Thanks in advanced for your help.

[Heartholme · Accepted solution]

Hi @JCH92 ,

This can be solved with a good old if sentence, put this as an expression in your "Replace exibition name":

if(equals(outputs('InputExhibitionName'), 'ExhibitionA'), replace(outputs('InputExhibitionName'),'ExhibitionA','100000008'),
if(equals(outputs('InputExhibitionName'), 'ExhibitionB'), replace(outputs('InputExhibitionName'),'ExhibitionB','100000009'),
if(equals(outputs('InputExhibitionName'), 'ExhibitionC'), replace(outputs('InputExhibitionName'),'ExhibitionC','100000010'),0)))

Replace the 10000009 and 100000010 to your liking.

Let me know how it goes 😄

{ If my post answered your question, please Accept it as a solution ✔ }
{ This will in turn help others find solutions to similar questions }

Best Regards
Heartholme

[JCH92]

Perfect - this sorted it!

Thanks for your help.

[Heartholme]

Great! I'm glad to hear. You're very welcome 😊