Answered

Producing Planner Descriptions from several TypeForm checkbox entries

Like (0) Share

Report

Posted on 25 Oct 2017 18:53:56 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

I have the same question (0)

All responses (4)

Answers (1)

TrippK 32 on 09 Nov 2017 at 03:22:45

Like (0)

Report

Re: Producing Planner Descriptions from several TypeForm checkbox entries

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

Was this reply helpful? Yes No
v-yamao-msft on 02 Nov 2017 at 09:28:13

Like (0)

Report

Re: Producing Planner Descriptions from several TypeForm checkbox entries

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 26 Oct 2017 at 19:00:04

Like (0)

Report

Re: Producing Planner Descriptions from several TypeForm checkbox entries

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
Verified answer

v-yamao-msft on 26 Oct 2017 at 08:20:58

Like (0)

Report
Re: Producing Planner Descriptions from several TypeForm checkbox entries

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

Community site session details

Producing Planner Descriptions from several TypeForm checkbox entries

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Telen Wang – Community Spotlight

Congratulations to the July Top 10 Community Leaders!

Leaderboard > Power Automate

Featured topics

Product updates

Community site session details

Producing Planner Descriptions from several TypeForm checkbox entries

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Telen Wang – Community Spotlight

Congratulations to the July Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Power Automate

Featured topics

Product updates