Microsoft 365 Excel: Update Row
Updates Rows of an Excel sheet. The update range can be specified up to 15 columns.
Microsoft 365
Microsoft 365 Excel: Delete Row Range
Deletes data in specified rows of an Excel sheet. You can specify a range of columns to be deleted.
Microsoft 365 Excel: Get Row
Obtains data from the specified row of an Excel sheet as String-type data. The acquisition range can be specified up to 15 columns.
Microsoft 365 Excel: Append New Row
Adds a row to the end of an Excel sheet and enters data in each of its cells. The input range can be up to 10 columns.
Microsoft 365 Excel: Find Row Number By Specified Value
Searches the Excel sheet for the specified value and obtains the row number.
Microsoft 365 Excel: Update Cell
Updates cell data at the specified position in an Excel sheet.
Microsoft 365 Excel: Get Cell Value
Gets cell data at the specified position in an Excel sheet.
Quote Creation and Storage Flow, SharePoint Online Save
A quotation PDF file is generated with the drafted content.
After the quotation is submitted, the quotation PDF file is uploaded to SharePoint Online.
The quotation results are also recorded in a ledger prepared in Excel Online on SharePoint Online.
Estimate Storage Flow, Excel Online Ledger Update
A quotation PDF file is generated with the drafted content and uploaded to SharePoint Online.
After the order has been confirmed, the contents and results of the quotation are recorded in the Excel Online ledger on SharePoint Online.
Travel Request Process, Teams Chat Notification
This is the process of applying for and approving business travel.
During the application process, the address to be visited can be searched by postcode.
After the application is submitted, an approval request is posted to Microsoft Teams Chat.
Inquiry Management Process, SharePoint Online List Storage
This is a centrally managed process for handling inquiries from web forms and phone calls.
The system accepts queries from Microsoft Forms / Google Forms.
After the response is complete, the data is automatically uploaded to SharePoint Online lists (Microsoft Lists) via Power Automate.
Internal Training Application Process
This process manages applications for participation in in-house training programs.
Once the application is received, the applicant is automatically added to the training schedule in the Outlook calendar.
Internal Training Management Process
This process manages the master for internal training programs.
The Outlook calendar events and Questetra master required by the application acceptance process are automatically maintained.
Group Member List Creation Process
This process automatically creates a list of Microsoft365 group members and emails it to designated users.
If you want to do an inventory of the entire Microsoft365 group (contacting each group’s administrator for confirmation), you can use the list of group names and each group’s administrator address to do the batch process.
Add/Delete Project Member Request Process
This is the process to request the addition or deletion of a project member.
After approval, the request is automatically reflected in the Microsoft365 Group on the specified date.
Up to 50 members can be processed at a time.
Microsoft 365 Outlook: Add Attendees to Calendar Event
Add attendees to an event in the Outlook Calendar. Specify the target by event ID. Specify attendees by email address. The link URL can be acquired.
Microsoft 365 Outlook: Post Attachment to Calendar Event
Posts an Attachment to an Outlook Calendar event (1 file only, up to 2.9MB).
Microsoft365: Get Group Member List
Retrieves a list of members of a Microsoft365 group. Up to 999 lists can be retrieved.
Microsoft365: Get List (for Paging)
Retrieves a certain listing on the next page in Microsoft365. The acquired data is appended to a String-type multi-line Data Item. (When acquiring a list, there is a limit to the number of items that can be acquired at one time, and it may be necessary to divide the list into multiple pages)
Microsoft365: Delete Group Member
Removes the specified user from membership in the Microsoft365 group.