Producing Planner Descriptions from several TypeForm checkbox entries

[TrippK]

We have a Typeform that asks our guests their type of food preferences.  Simple checkboxes for items like Spicy Foods, Nuts, Shellfish, etc.  So I have created a flow to take those answers and create a Planner Task for my kitchen staff to verify we do not serve these items in house.  However, my description looks terrible because I can only think to have the entry look something like this:

And the result comes out looking like this (Assuming Guest only wanted Guava Juice): 

Task Name - Breakfast Items To Not Serve for Guest XXXX

Description -  , , , , , , , , , , , , Guava Juice, 

Can someone share with me an idea on how to just skip the extra spaces and commas if the value they were attached to are blank?

Thank you in advance,

Tripp

[v-yamao-msft · Accepted solution]

Hi TrippK,

Please consider to add Compose actions in your flow, then use workflow definition language to return the value you want.

Please take this flow configuration for a reference.

The function I am using in the Compose action is:

if(empty(triggerBody()?['3: enter you email']),'',concat(triggerBody()?['3: enter you email'],','))

This function will check if the dynamic content is empty or not, if it is empty, return a blank value, if not, concat the dynamic content with a comma.

In my case, I just test with one dynamic content, for your scenario, you may consider to add more compose actions in the flow, then use the outputs of the compose actions for the description field.

The documentation about workflow definition language for your reference:
https://docs.microsoft.com/en-us/azure/logic-apps/logic-apps-workflow-definition-language

Please have a try with it. Please feel free reply if you need more help.

Best regards,
Mabel Mao

[TrippK]

Thank you very much for your help.  I will give this a try and see if it will produce my desired results and get back with you.

Grateful,

Tripp

[v-yamao-msft]

Hi TrippK,

What’s your current situation?

Does the function work for you now?

Best regards,

Mabel Mao        

[TrippK]

WIth your help I have been able to produce some better results in my output.  Thank you Mabel.