Passing Teams ID through Environment Variable

[birgem11]

Hi, I'm trying to use environment variables to pass in a Teams group ID and channel ID to post a message in Teams on a button click.  I have the following in my OnSelect function:

MicrosoftTeams.PostMessageToChannelV3(
    LookUp('Environment Variable Values', 'Environment Variable Definition'.'Display Name' = "TeamsGroupID").Value, 
    LookUp('Environment Variable Values', 'Environment Variable Definition'.'Display Name' = "TeamsChannelID").Value,
    {
        content: "<ul>
                     <li>Type: " & DataCardValue17.Selected.Value & "</li>"
                     & If(Last(submittedDates).Date <> First(submittedDates).Date, "<li>Dates: " & First(submittedDates).Date & " to " & Last(submittedDates).Date, "<li>Date: " & First(submittedDates).Date) & "</li>
                     <li>What's Happening: " & DataCardValue6.Text & "</li>
                     </ul>",
        contentType: "html"
    },
    {
        subject: "Out of Office"
    }
);

This snippet works just fine with I have the IDs hardcoded with quotes where I have the 2 env var lookups, but I get the following error when I try to use the env vars:

MicrosoftTeams.PostMessageToChannelV3 failed: {"error": {code": "BadRequest", "message"; "teamID needs to be a valid GUID.",...

Can anyone suggest how/if I can correctly pass in these values?  I've tried with both quotes and no quotes around the ID values in my vars.

Thanks in advance.

[sperry1625]

Have you verified that those lookups are returning what you are expecting?

Have you tried storing the values in variables first?  You can try using a With() clause.  I generally use the schema name for lookups as follows:

LookUp( 'Environment Variable Values', EnvironmentVariableDefinitionId.schemaname = "me_NameOfVariable" ).Value

The schema name never changes where the name can change.

Please 'Mark as Solution' if someone's post answered your question and always 'Thumbs Up' the posts you like or that helped you!

[birgem11]

Thanks @sperry1625 ... the Lookup isn't resolving to anything in the OnSelect function, but if I put the same lookup formula in the Text property of a label, it resolves to what I expected.  Same if I try to set vars in the OnSelect before the MS Teams call, or even OnStart, they don't resolve to anything.

[sperry1625]

Not sure why that is. That lookup should work in all cases. Can you provide examples of what you are doing?

Regards,

-S

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[birgem11]

Sure.

Here is the Text property of my label where you can see it resolving to the value in my env var:

And here is the same lookup function in the OnSelect property where the resolved value is blank:

[sperry1625]

What you have should work but I have seen stranger things happen. Let's try a test.  Just prior to your calls in the OnSelect let's add the following:

UpdateContext(
    {
        ctxGroupId: 
        LookUp(
            'Environment Variable Values',
            'Environment Variable Definition'.'Schema Name' = "new_TeamsGroupID"
        ).Value,
        ctxChannelId: 
        LookUp(
            'Environment Variable Values',
            'Environment Variable Definition'.'Schema Name' = "new_TeamsChannelID"
        ).Value,
    }
);

Then change your call to:

MicrosoftTeams.PostMessageToChannelV3(
    ctxGroupId, 
    ctxChannelId,
    {
        content: "<ul>
                     <li>Type: " & DataCardValue17.Selected.Value & "</li>"
                     & If(Last(submittedDates).Date <> First(submittedDates).Date, "<li>Dates: " & First(submittedDates).Date & " to " & Last(submittedDates).Date, "<li>Date: " & First(submittedDates).Date) & "</li>
                     <li>What's Happening: " & DataCardValue6.Text & "</li>
                     </ul>",
        contentType: "html"
    },
    {
        subject: "Out of Office"
    }
);

See if the context variables contain your values.

Regards,

-S

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[birgem11]

looks to have the same issue:

I tried using label.Text in the parameters of the PostMessageToChannel function since the labels seem to be getting populated correctly, but then I get the error in my original post.

[sperry1625]

This will not likely change anything, but change your Lookup to use the following:

UpdateContext(
    {
        ctxGroupId: 
        LookUp(
            'Environment Variable Values',
            // Change is here **************
            EnvironmentVariableDefinitionId.schemaname = "new_TeamsGroupID"
        ).Value,
        ctxChannelId: 
        LookUp(
            'Environment Variable Values',
            // Change is here **************
            EnvironmentVariableDefinitionId.schemaname = "new_TeamsChannelID"
        ).Value,
    }
);

Regards,

-S

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[birgem11]

Same issue unfortunately:

[birgem11]

so I know PostMessageToChannelV3 is deprecated, but I'm using it because I haven't found a good replacement to do what I'm wanting.  Any other suggestions for what I could try?