Adding multiple field titles in one

[Ashwinreddy]

Hi Team,

I'm  trying to achieve an scenario where there are 5 different fields with different name for example A,,B,C,D,E,F and they are Boolean valued

now I want to send email where there will be title as XYZ and if any of the field value is true then it should be appended under XYZ if not the email should be null as shown below if A and B was selected as true then in email XYZ= A,B

can I get the solution for this please

[PrasadAthalye]

You can declare a string variable and then add conditions to check if each boolean field is true or not. If yes, use append to string variable action and append field name. 

Finally add a condition to check if string variable is not empty. If not empty, send email and add string variable.

[v-bofeng-msft · Accepted solution]

Hi @Ashwinreddy :

I've made a test for your reference:

My flow:

I set an object type variable "TheVar" to simulate the situation you describe.

Reference Expression:

concat(
  'XYZ=',
  if(variables('TheVar')['A'],'A',''),
  if(variables('TheVar')['B'],'B',''),
  if(variables('TheVar')['C'],'C',''),
  if(variables('TheVar')['D'],'D',''),
  if(variables('TheVar')['E'],'E','')
)

The Result:

Best Regards,

Bof

[PrasadAthalye]

You should not add anything inside else part .. refer below

Something like below.. Please ensure that closing brackets match...

concat(
'XYZ=',
if(variables('TheVar')['A'],'A',
if(variables('TheVar')['B'],'B',
if(variables('TheVar')['C'],'C',
if(variables('TheVar')['D'],'D',
if(variables('TheVar')['E'],'E','')))))
)