Date format microsoft teams
Hello everyone, I work as an IT Support Tech in a company. Today, a user came with a date format issue on excel but only in teams. She tried to put a french date format in teams, but the software changed the date format all the time to put an english date. When I opened the documents in excel in local, we could put a french format to a date. Do you have any idea of where this issu can come from ? Thank you in advance,
Teams App how to edit an online Excel File in a Sharepoint site via nodejs
Hi guys, i'm new to this. i need to make a Teams App via vscode for my team that reads (already done) and edits an online Excel file on a Sharepoint site. 'til now i'm using some packages like xlsx, pnp/sp and spfx for reading the file, but now i'm blind on writing this file and save it online. what should i do? are some authentication settings and implementations needed? which packages should i use to accomplish this?Teams App that reads Excel File from Sharepoint site
Hi guys, i'm new to Teams App Development. My team leader at work asked me to start studying this technology to extend our Teams Channel (no one in my team knows how to do it). What i need are two things: 1) A better documentation and guides to Teams App, Teams Toolkit, SharePoint Framework etc. outside of official Microsoft documentation. 2) I need help to know how to go on with my project: - my goal is to make a Tab App (unfortunately i cannot make any bot 'cause of privileges problems) that reads an Excel file from a SharePoint page, extracts data from that and uses them to do XYZ operations. I started by creating a Tab with sharepoint framework, but ther's nothing i know about it. How can i do this, and which modules i need to use? thanks.
Assigning Macros in MS Teams Excel Workbooks to Buttons
Good Afternoon everyone, I have a workbook with a VBA Macro assigned to an Activex Control button. When opening the workbook I got an error message saying that form controls were not compatible outside of the MS Excel Desktop app. To get around this problem, I removed the Activex form control and inserted a shape in to the workbook which had the macro assigned. when the workbook is open in Desktop, clicking on the shape prompts the macro to run, however when the same workbook is open in teams, clicking the shape just selects it and doesnt prompt the macro to run. My question is: Are Macros completely incompatible with excel files hosted on MS Teams? And if they are, how do I add in a button or visual aid that once clicked, executes the macro? TIA Dan V
Automated Excel Tracker on Teams
Hi guys, I have a question related to both Teams and Excel functions, wondering if anyone of you has any ideas? 🙂 Our team is going to hold a 2-month training where there will be 15 trainees with 5 trainers. Trainees have to submit their assignments, trainers will grade and update comments on a tracker. I'm under the impression that this can be done with the Teams education account, but we are using the Teams business account Here is what we would like to see/do: 1. Method to submit assignments: - Is there any easy way for all trainees to submit their individual test via Teams? (Only trainers can review/download/grade the test, trainees won't be able to see each other tests) - Once trainees have submitted the test, is it possible to automatically update in a tracker (would be great if timestamp is included) and notify his/her own trainer? 2. Method to track grades/feedback - Ideally, trainees have their own benchmark tracker and we can link their data into a master grades/feedback tracker that only trainers can see. - Once trainers have updated the master tracker, trainees can see their own grades in their own benchmark tracker - If that’s not possible, we either have to copy and paste in people’s data to master or give people a blinded ID for anonymity. Or we can set one Excel tracker, where trainees can only see their individual scores, and trainers can see all scores. Not sure if there is other Teams app that is applicable for this situation (e.g. power automate), would be great if you guys can share some insights, thank you so much! 🙂
