User Profile
Anthony_Antonacci
Copper Contributor
Joined 3 years ago
User Widgets
Recent Discussions
Re: Range borders in Excel
For those trying to do the same as me (add a broder in a excel file in sharepoint) here is a solution you use: .../Range(address='A1:B2')/format/borders('EdgeTop') and send Json with only top information. this works.... its not really documented anywhere.... [{"sideIndex":"EdgeTop","id":"EdgeTop", "color": "#000000" , "style": "Continuous", "weight":"Medium"}]158Views0likes0CommentsRe: Mcgraph pop-up blocking entry
not sure what your are trying to do, but i created an application in Entra (AzureAD) and then connect using web request. if you use the connect-mggraph commands you need to install them first.... (i am not sure if gives you a token, i think it "logs you in" .... Install-Module -Name Microsoft.Graph Connect-MGGraph Then it will ask you to login with your MS365 User....118Views0likes0CommentsRe: Range borders in Excel
Forgot to Mention, the "get" command works, same thing but in get format https://graph.microsoft.com/v1.0/drives/{drv}/items/{id}/workbook/worksheets/sheet1/range(address='B3:C4')/format/borders not sure what happened to my pastese, part of the url is missing 😞 https://graph.microsoft.com/v1.0/drives/{drv}/items/{id}/workbook/worksheets/sheet1/range(address='B3:C4')/format/borders(edgeLeft)240Views0likes1CommentRange borders in Excel
Hi, Trying to add a simple Border around a table in Excel using Graph. i tried multiple combinations from API docs but i cant get it to work 😞 any help would be greatly appreciated. Trying this command (i know its not documented on the api page, but almost non of them are when it comes to sharepoint access) $url= "https://graph.microsoft.com/v1.0/drives/{drv}/items/{id}/workbook/worksheets/sheet1/range(address='B3:C4')/format/borders(edgeLeft)" pushing this simple body $body='[{"color":"#000000","style":"Continuous","weight":"Medium"}]' getting a BadRequest Back... i'm sure its a small detail i'm missing....243Views0likes2CommentsRe: OneDrvice Graph API for to read columns from Excel
if you just want to read 10 columns its 'https://graph.microsoft.com/v1.0/drives/{drive-id}/items/{item-id}/workbook/worksheets/{worksheet-id}/usedrange' i think there is one where you specify the range, but i believe you need to specify the columns and rows... (i ended up using used range) it will get the "used range" so all lines and columns used. from there you can pick only what you want. item-id is your file id and worksheet-id is your sheet in the file (I believe for worksheet you can use the name "sheet1" or "expense" you dont need the id.141Views0likes0CommentsRe: Microsoft Teams won't send dial pad inputs when navigating a phone tree during a conference call
Yes, there are lots of things in Teams phone that could be improved. but at least for conference there is a work around. And its not a bad thing, you pause yourself out of the group, privately call the new user, dial the extension and then merge de call. You probably have tested multiple phones systems and each one has issues... at least with this one its fully integrated into MS and we (if you are a reseller) get incentives everymonth 🙂2.6KViews0likes0CommentsAdd to a name an Alias or Nickname to Teams phone (or teams calling?)
Hi, If you setup the Auto Attendant and tell it to directory search by name. You might want to give nicknames or alias to some of your staff, for exemple, I have a single person in accounting, and her main email is "accounting" some user call her and say "accounting" other use her real name (in her signature) "lily" since her name in AD is "Lily" lily works but not accounting. in other cases some customers have complicated forein first or last names and they use a second simpler name but the real name needs work as well. anyone know how to do this?4.1KViews1like0CommentsRe: Microsoft Teams won't send dial pad inputs when navigating a phone tree during a conference call
What if went back to the 80s and used DTMF tone generator? maybe an app that plays tones in the "microphone" ?? I know its a little dumb, but if microsoft can't make a dial pad appear cant we have one. perhaps even a app added in teams 😛5.4KViews0likes1CommentRe: Renaming Call Queue or Auto Attendant
So in PS, if i use the command Get-CsCallQueue or Get-CsAutoAttendant the Name property matches the name in the admin center. but when I receive calls name is the "old" name. for example : Original name : CI_MainIVR New Name : CI_FR_Incoming under a missed call : "Missed transfer by CI_MainIVR"2.6KViews0likes2CommentsRenaming Call Queue or Auto Attendant
Hi, we created our Teams phone system and gave the auto attendant and Call Queue technical names (ex: Voice_AA_Ci_IVR ) once we are in production i realised that these names who up when users receive calls from either an Auto Attendant or a Queue. I tried renaming them but the old name still shows up (its been more than 48 hours) - is there a place where the original name is stored? (cause i realise that each AA has a name, then has a tied in ressource account (also has a name) and then a User with a license (also has a name and email) ...Solved2.8KViews0likes5Comments
Recent Blog Articles
No content to show