Forum Discussion
Anuj_Pratap_Singh_0210
Jan 31, 2023Copper Contributor
Can't access bot inside shared channel
I've built an application for the Microsoft Teams app and published it in my organization using the Developer portal.
I want to access the bot inside a team's shared channel but cannot do so. I've also provided "sharedChannels" inside the supportedChannelTypes property in the manifest but still, it isn't working.
The manifest of my application looks somewhat like this:
{
"$schema": "https://developer.microsoft.com/en-us/json-schemas/teams/v1.15/MicrosoftTeams.schema.json",
"version": "1.0.1",
"manifestVersion": "1.15",
"id": "10d58ca5-e2fd-4bb0-b488-ec31a1e071e5",
"packageName": "Bot",
"name": {
"short": "Bot",
"full": "Application"
},
"developer": {
"name": "Organization",
"websiteUrl": "https://example.com/",
"privacyUrl": "https://example.com/privacy",
"termsOfUseUrl": "https://example.com/termsofuse"
},
"description": {
"short": "Test application",
"full": "Test application."
},
"icons": {
"outline": "outline.png",
"color": "color.png"
},
"accentColor": "#60A18E",
"configurableTabs": [
{
"configurationUrl": "https://test.com/configure",
"canUpdateConfiguration": true,
"scopes": [
"team"
]
}
],
"bots": [
{
"botId": "bot-id",
"scopes": [
"groupchat",
"team",
"groupChat"
],
"commandLists": [
{
"commands": [
{
"title": "register",
"description": "register"
}
],
"scopes": [
"team"
]
}
],
"isNotificationOnly": false,
"supportsCalling": false,
"supportsVideo": false,
"supportsFiles": false
}
],
"validDomains": [
"test.com"
],
"defaultGroupCapability": {
"team": "bot",
"groupchat": "bot",
"meetings": "bot"
},
"authorization": {
"permissions": {
"orgWide": [],
"resourceSpecific": []
}
},
"supportedChannelTypes": [
"sharedChannels",
"privateChannels"
]
}
I finally understand what you want to do and believe you can achieve it by using structured references and an OFFSET function to pick-up the number from the row below.
In E2 the formula becomes:
=[@[Amt Added]]+[@[Amt Withdrawn]]+[@Return]+OFFSET([@[Current Value]],1,0)
and in F2:
=[@Return]+OFFSET([@[VOT Amt]],1,0)
Make sure that these have filled down all the way to the bottom of the table.
When you now insert row 3, both formulas will auto-complete in the new row. See attached.
As to why the initial formula doesn't work, take a look at the formulas before you insert row 3.
From the start the formulas in E2 and F2 refer to cells E3 and F3. Insert row 3 and the references will update to E4 and F4 (i.e. two rows down), just as one would expect. The formulas on what is now row 4, still reference E5 and F5. I.e. only one row down. The same for all rows down the table.
Columns E and F now will no longer auto-complete as you have inconsistent formulas in them. Row 3 will be left blank and, the formulas in row 2 are wrong.
6 Replies
Sort By
- Meghana-MSFT
Microsoft
We will check this at our end and get back to you.- Meghana-MSFT
Microsoft
Anuj_Pratap_Singh_0210 - We tried this at our end, but we are not able to @mention the bot, are you also experiencing the same problem?
- Anuj_Pratap_Singh_0210Copper ContributorYes I'm getting the same problem