Unanswered

Passing Teams ID through Environment Variable

(0) Share

Report

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

Categories:

Building Power Apps

I have the same question (0)

All responses (13)

Answers (0)

Sort by

sperry1625 763 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

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

Was this reply helpful? Yes No
birgem11 67 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
sperry1625 763 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
birgem11 67 on at

Like (0)

Report
Copy link

Link copied!

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:

Was this reply helpful? Yes No
sperry1625 763 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

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

Was this reply helpful? Yes No
birgem11 67 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
sperry1625 763 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

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

Was this reply helpful? Yes No
birgem11 67 on at

Like (0)

Report
Copy link

Link copied!

Same issue unfortunately:

Was this reply helpful? Yes No
birgem11 67 on at

Like (1)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
sperry1625 763 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Can you show me the definition for the Environment Variables? Where is the value stored, as the Default, or a 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.

Was this reply helpful? Yes No