Office365
I had the opportunity to work with Excel, which has hundreds of worksheets, and I tried to sort the worksheets by name because it was difficult to find the desired sheet. But Excel doesn't have the ability to sort worksheets by name. I end…
A note on the Microsoft Graph (Office365) API for obtaining and using an admin token. impetus I tried to add and remove users and groups in Azure Active Directory using the API. The Azure Active Directory API has been integrated with the M…
I was interested in single sign-on (SSO) services and tried various services for a while. www.ekwbtblog.com I wanted to log in with my Office365 user as a key, so I ended up using Azure Active Directory SSO. As for the usage, I mainly use …
One way to manipulate the Web version of Office365 is through the Microsoft Graph (Office365) API. For example, with the Microsoft Graph (Office365) API, you can use the Send email from OutLook Excel Online file editing SharePoint file ret…
I am interested in SSO (Single Sign On) and have tried various SSO services. I am completely new to SSO, so here is a brief summary of what SSO is and how it works, and how easy it is to use. motive I use various web services, each of whic…
I use SheetJS (xlsx) to load Excel files in JavaScript (TypeScript). The usage is a bit peculiar and I forget how to use it easily, so this is a memo for my own use. manual https://www.npmjs.com/package/xlsx install npm install xlsx File r…
When I received an email, I wanted to upload the email attachment to Slack and tried to use Microsoft (Office365) Flow to perform that task. Microsoft (Office365) Flow has a Slack connector, so I thought it would be easy to create one, Unf…
It's not much, but I wrote about Slack in a rambling way. Slack or Microsoft Teams? We use Office365, so we have access to Microsoft Teams, but we use Slack as our chat tool. Teams also tried using the tool, but at a glance, it was difficu…
Postscript (08/06/2019) Since only String type data can be passed from PowerApps to Flow, I had to manually convert map data to String, but you added a function to convert JSON data to String! qiita.com Now you can easily pass data! Data s…
Microsoft Flow has data types such as basic types, arrays, and maps (objects), but because the operations are wrapped in a GUI, it is very difficult to understand how to get from the data to the desired element values. Often, after much tr…
Introduction. I used to touch Office365 PowerApps. PowerApps is a rather obscure tool, and I had neglected it, thinking that I would forget how to use it if I didn't write down how to use it. I haven't touched the application in a while to…
Introduction. I used to touch Office365 PowerApps. PowerApps is a rather obscure tool, and I had neglected it, thinking that I would forget how to use it if I didn't write down how to use it. I haven't touched the application in a while to…
Introduction. I used to touch Office365 PowerApps. PowerApps is a rather obscure tool, and I had neglected it, thinking that I would forget how to use it if I didn't write down how to use it. I haven't touched the application in a while to…
I have been touching OneDrive for a while now. I tried to use OneDrive on Ubuntu as well, but OneDrive does not have a Linux client. I did some research and found an article about a free OneDrive client for Linux, so I gave it a try. qiita…
OneDrive is about the same price as Dropbox with Office365, so I decided to switch from Dropbox to OneDrive when Dropbox renewed, and here are my impressions after using OneDrive for a while. The following is my impression of OneDrive for …
I am using the paid version of Dropbox. My renewal month is coming up, so I tried to renew. The fee is 1200 yen/month.... Huh? Did I do this much? I have 1TB, but I haven't used even half of it... If it were a few hundred yen per TB, I cou…
When using Microsoft Flow normally, if some error occurs in the middle of the process, the action stops there. For example, suppose you have a Flow that retrieves a list of users from SQL Server and sends a Slack to those users. If there i…
I was looking for Japanese holiday data to create a national holiday table in a database. In the end, I was able to obtain the data in CSV format that I wanted most from the following site (thanks to the author), but I took a long detour t…
Office365 provides an API called Microsoft Graph API that allows you to access Office365. However, it is a bit time-consuming, as you need to acquire the token yourself and learn how to use the API. So, we will show you how to use Office36…
