Forum Discussion

Kelemvor333's avatar
Kelemvor333
Iron Contributor
Jun 27, 2019

Can I have a form in a channel that will post in the conversations tab any time it gets filled out?

We have a recognition program at work where people currently fill out a paper form and turn it in and then generally post about it in Teams so everyone knows.  We want to get rid of the paper form po...
microsoft teams
VasilMichev's avatar
VasilMichev
MVP
Jun 27, 2019

You can tie in a Flow to the Form and have the response inserted into the channel?

Kelemvor333's avatar
Kelemvor333
Iron Contributor
Jun 27, 2019

VasilMichev 

I've not used FLow before but I think I'm on the right track.  I created the flow with:

Trigger: When a new response is submitted

 

For the Action, I tried Post a message (V3) (Preview) as well as Post a message as the Flow bot to a channel (preview).  However, what I'd like to do is post the message and include one of the fields from the form where they write up what they want to say about the person.  I'm not seeing any way to do that so far.  Is that possible?

  • adam deltinger's avatar
    adam deltinger
    MVP
    Jun 27, 2019
    Add a forms action after the first one of “get response details” you should be able to use the dynamic content from the form answers then
    • ChrisWebbTech's avatar
      ChrisWebbTech
      MVP
      Jun 27, 2019
      Yeah what Adam said, get response details and use I think it's the ID from the first trigger. Then you'll have the fields available to use in the post a message action.
      • Kelemvor333's avatar
        Kelemvor333
        Iron Contributor
        Jun 28, 2019

        OK, I was able to get the Post to Channel thing working, but all the posts have my name on them since it's my Flow so that's not going to work.

        I found some other pages about using a Card to make the post and that sounds like it would work great.  I started looking at the Webhook idea but apparently the HTTP action is a Premium feature so I can't use that.  But then I noticed that there's an action under Teams called: Post your own adaptive card as the Flow bot to a channel.  That sounds like exactly what I need.

        So, I set everything up but now I get an error when the flow runs that simply says:

        Action 'Post_your_own_adaptive_card_as_the_Flow_bot_to_a_channel' failed

        The specified Teams flowbot adaptive card request is missing or invalid.

        Any idea what that means?

         

        Here's my Card info in case that helps.

        Thanks.

         

        {
        "$schema": "https://adaptivecards.io/schemas/adaptive-card.json",
        "type": "AdaptiveCard",
        "version": "1.0",
        "body": [
        {
        "type": "ColumnSet",
        "columns": [

        {
        "width": "stretch",
        "items": [
        {
        "type": "TextBlock",
        "text": "ACED IT"
        }
        ]
        }
        ]
        },
        {
        "type": "ColumnSet",
        "spacing": "large",
        "separator": true,
        "columns": [

        {
        "width": "stretch",
        "items": [
        {
        "type": "TextBlock",
        "text": "**@{body('Get_response_details')?['r4bc2e11a0eaf4839b4a4fbe0d0420a41']} got an Aced It!**"
        },

        {
        "type": "TextBlock",
        "spacing": "small",
        "isSubtle": true,
        "wrap": true,
        "text": "@{body('Get_response_details')?['r37a7fa26eb234a488418e20fbfe1bdba']}"
        },
        {
        "type": "TextBlock",
        "spacing": "none",
        "isSubtle": true,
        "wrap": true,
        "text": "From: @{body('Get_response_details')?['responder']}"
        }
        ]
        }
        ]
        }
        ]
        }

Resources