Answered

Producing Planner Descriptions from several TypeForm checkbox entries

(0) Share

Report

Posted on by 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:

Items to not serve.png

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

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

v-yamao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
TrippK 32 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
v-yamao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi TrippK,

What’s your current situation?

Does the function work for you now?

Best regards,

Mabel Mao

Was this reply helpful? Yes No
TrippK 32 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No