Office365 | Some powershell script for office365 | Command Line Interface library

So there's a piece of software using the deprecated Office365 Auth type and I am working to change it. However I cannot seem to get my head around how to edit the following:

I want to copy the data from a closed file I have selected and see it in the file containing this macro.

I am using Office365.

How can i copy data from this "FullPath" workbook ?

I'm trying to create emailing service with go. When i tried to send email via gmail or office365 code works just fine but when i tried to send email via custom smtp i get "535 5.7.0 Invalid login or password" error.

I know username and password is correct because i am using same password and username with another python service with flask-mail and other services works just fine.

I don't have any documentation for custom smtp server but i know smtp server uses TLS

I tried plain auth, gomailer, smtp.SendMail() function and without startTLS but nothing changed.

here is my code;

In our project we are trying to integrate MS Teams with Web application using MS Graph API.use case is OnlineMeeting for Virtual Events.the attendees may or may not have microsoft account.

Created Azure Ad Account and created new tenant and created new user(given Global Administrator role) and registered new Application and given required API permission users.readWrite.all and onlineMreeting.readWrite.all to Application and Delegated Users.

Initially i was using UserCredientials flow(no manual authentication since its not in our usecase user should be authenticated automatically through java) to get accessToken.since its not recommended to use username and credientials(ROPC flow),so now trying to get accessToken only using clientId and clientSecret using adal4j and i am able to get accesstoken but not able to use token for endpoints with /me/onlineMeeting.since token doesnt contain required permission and scope.

so i had tried to reach endpoint with token got from clientid and secret using /users/{id}/onlineMeeting but it gives error like Application does not have permission to Create online meeting on behalf of this user

referred https://docs.microsoft.com/en-us/graph/cloud-communication-online-meeting-application-access-policy its mentioned to change access-policy.

is there any way to create online meeting on behalf of user without changing access policy? to create onlinemeeting on behalf of user do we need skype business account?

onlinemeeting can created by two endpoint /onlineMeeting & /events

so does /event in calender api require any additional previlages like office365 license to create online meeting?

to implement these usecase whats the microsoft account Type,azure ad account and what are all the license and azure subscription need?

to create onlinemeeting only with dialin do we need any special license

I have 2 tables:

Table1 containing Customer & Part#
Table2 containing Part# & Type

(The actual data lists are larger)

Table1 (Customer & Part#) & Table3 (Helper):

Table2:

Desired result for combination of customer A and Type X:

These being the 3 results of part numbers in Table1 that are Customer A and the lookup of the Part# results in Type X (see also Helper column).

I'm able to retrieve the results by creating the helper column as shown in the example data, however I want to skip this column and solve it in one go. But I don't know if that's even possible.

I was thinking about something in this direction.. =INDEX (Table1[Part'#],IF(Table1[Customer]="A",ROW(Table1[Customer])) ..but there I get stuck. I think I can pickup from there with IF, ISNUMBER, SEARCH but my head errors there.

Does anybody know a way to skip the helper column for this?

PS I have office365, but FILTER is not yet released by company rules (unfortunately).

PS I prefer a formula solution, but VBA is allowed when necessary

A coworker made a working PowerShell script to retrieve Mailboxes and Groups from Office 365. We have both admin rights on Office 365 = I can get all of these information with a internet browser on EAC. When I'm executing the PowerShell script with my Office 365 credentials, I get the excepted results. It means that I have the rights access and permissions on Exchange.

My need is to create a Python script to do almost the same thing then to create a human-readable Excel Workbook (probably using openpyxl) and send email later. Many of you will ask to me why I don't complete the PowerShell script, the simple answer is that this script will be a little part of a biggest project, written in Python.

Here, the PowerShell script:

I need help selecting an element on a webpage with Selenium. I have been using Selenium on this website for about 3 weeks and so far, I can usually find an element by css selector or XPath. However, this specific section of the website is giving me a very hard time. After I click on “reset office 365 password” a window comes up and I want to programmably put in the new password but it can’t find anything in the popup window. Here is what the page looks like: (I am too low of score to post pictures here) https://cdn.discordapp.com/attachments/768594779344470022/845811910577881098/unknown.png

Here is the whole element’s information:

I am trying using exchangelib to read emails with certain conversation_id and only read 2 attributes: eid and datetime_received. I don't know why the following code doesn't work:

I am trying to save the data that pulled out from PostgreSQL db onto designated MS SharePoint folder. To do so, first I retrieved data from local db, then I need to store/save this data onto SharePoint folder. I tried of using office365 api to do this, but no data saved on SharePoint folder. Does anyone has similar experiences of doing this in python? Any workaround to do this in python? any thoughts?

My current attempt:

first, I did pull up data from local postgresql db as follow: