Download SharePoint, Power Platform and SPFx Solutions
Power Automate Send 7 or 14 Day Task Due Reminder Emails
We developed a Scheduled Cloud flow in Power Automate that will send a reminder email to users on specific days:
- Due Date is Today – The assigned users will be reminded that the task expires today.
- 7 Days Before the Due Date – The assigned users will be reminded that the task will expire in 7 days.
- 14 Days Before the Due Date – The assigned users will be reminded that the task will expire in 14 days.
- 7 Days After the Due Date – The assigned users will be reminded that the task has already expired for 7 days.
- 14 Days After the Due Date – The assigned users will be reminded that the task has already expired for 14 days.
This allows users to prioritize and finish their tasks on time or before the due date.
To build this, we will create a SharePoint List [TaskList] with these columns below:
- TaskName (Default Title Column)
- AssignedTo (Person or Group column)
- TaskPriority (Choice type column (High, Medium, Low))
- TaskStatus (Choice type column (Completed, InProgress, Yet to start))
- DueDate (Date and Time type)
- DueDateBefore7Days (Calculated column(=DueDate-7))
- DueDateBefore14Days (Calculated column (=DueDate-14))
- DueDateAfter7Days (Calculated column (=DueDate+7))
- DueDateAfter14Days (Calculated column (=DueDate+14))
The scheduled flow runs every day @10.00 AM.
Let’s Download the Complete Solution and try it out!!
Power Automate Create Multiple Sites in SharePoint Online from Excel
We developed a Power Automate Scheduled Cloud flow, which will run daily [at a specific time], and create the SharePoint sites below from an Excel.
- Communication site
- Office 365 Group connected Team site
- Office 365 not Group connected Team site
We have an Excel Spreadsheet [Site Request] that contains all the columns below:
- Title
- Site Owner
- Site Type
- Alias
- Site URL
- Site Description
- Site Member
- Max Storage
- Max Storage Warning Limit
When a user requestor wants to create bulk SharePoint Online sites, he/she will request or enter all the site details [Title, SiteOwner, Site Type, etc.] in the Excel sheet.
Every day, when flow runs at a particular time, it retrieves all the data from Excel.
Then, the flow will check the requestor Site Type, and if the Site URL is equal to Blank, it will check the storage limit field.
If the Storage limit is greater than 50 GB, then it will send an approval request to the SharePoint Administrator.
Otherwise, it will create the specific SharePoint Site, Add Members, and Set the Storage limit [based on the user’s request].
If the SharePoint Administrator approves the Storage limit, we will create a SharePoint site, set the Storage limit, and add members to it. Otherwise, the requester will get a reject notification that “Your Site(s) request has been rejected.“
Let’s Download the Complete Solution and try it out!!
Create Multiple Tabs in Power Apps Form [Lead Management Apps Example]
Download this app to learn how to create multiple tabs in Power Apps. Here we have created 4 tabs in the Power Apps Canvas App. We have created a Lead Management App here. Data we are storing in a SharePoint Online list having 26 columns. Below are the functionalities of the Power Apps App.
- Home Page
- Add New Leads [Tabbed Form]
- Display All Leads
- Edit Leads [Tabbed Form]
- Details Screen [To view selected item]
From the Home page, users can navigate to see all leads or add new leads also. Detailed Screen will display all leads and the user can select an item to see details about it. From there, users can edit or delete a lead. The New Form and Edit form will open as a Tabbed form.
You can follow the read me file to know how to install and use the Canvas App.
Create List With Different Types of Columns using Power Automate [From Excel File]
If you want to know how to create a SharePoint List with Power Automate, then download the solution. I have explained how to create a list and add different types of columns:
- Single line of text
- Choice
- Number
- Person
- DateTime
- Yes/No
- Hyperlink
The solution is dynamic and all the columns we are reading from an Excel file.
The user needs to create an Excel file having supported columns and properties, then once the flow runs, it will create the list and add the columns from the Excel file.
Power Apps CRUD Operations App [Business Consultation App]
Get this app to learn how to perform CRUD operations in Power Apps. Here we have created four screens in the Power Apps Canvas App, where users can create a new business consultancy, read or view the consultancy details, update or modify an existing consultancy, and delete a consultancy.
- Welcome Screen
- Add/Edit Screen [add or modify existing item]
- Consultancy Details Screen [To view all items]
- Display Screen [To display selected item]
From the Welcome Screen, users can navigate to see all consultancy or add a new business consultancy (Add/Edit Screen). In Consultancy Details Screen, users can view all consultancy. Similarly, on the display screen, users can view the details of the selected consultancy and modify the details from there.
You can follow the read-me file to learn how to import and use the Canvas App.
Power Automate Multilevel Approvals [Digital Purchase Order]
Download this app to learn an automated cloud flow in Power Automate where users can request a purchase order by filling out a SharePoint form. The form contains the following columns:
- Employee ID (Default Title column)
- Employee Name (Person column)
- Employee Gender, Employee Role, and Employee Department (Choice columns)
- Product Name and Product Price (Lookup Columns)
- Product Quantity and Total Cost (Number type)
- Product Color and Approval Status (Choice type columns)
- Product Date (Date and Time type)
Once the purchase order request is initiated, it will create and send an approval request to the respective TeamLead. If TeamLead approves the request, the flow will proceed forward to check whether the total purchase cost is more than $10k or not; Otherwise, the flow will stop there.
Similarly, if the purchase cost is less than $10k, then it will again create an approval request for the Financial Team directly; if the cost is more than $10k, then the approval will send to Manager. If the Manager approves the request; again it will create another request for approbation from Financial Team.
Here, the Financial Team must need to respond the approval request; otherwise, the request will be auto-approved, and at each step of the flow, the requestor gets notified via Email.
You can follow the Read-me file to learn how to import and use this automated application.
Expense Reimbursement and Approval using Power Automate
We developed an Automated cloud flow, where users will request expense reimbursement, by filling out the Microsoft form. This Microsoft form contains the below columns
- Full name (Text)
- Employee Id (Text)
- Organizational email (Text)
- Department (Choice)
- Expense Date (Date)
- Expense Category (Choice)
- Type of payment (Choice)
- Amount of reimbursement (Number)
- Description (Text)
- Reciept (Upload file)
Once the flow is initiated, it will submit the response and attachment to the SharePoint list. Which contains the following columns:
- Title (Employee Id) – Single line of text
- Full name – Single line of text
- Department – Choice
- Expense Date – Date/time
- Expense category – Choice
- Payment mode – Choice
- Amount requested – Currency
- Description – Multiple lines of text
- Attachments – Attachments
- Status – Choice
Then the manager gets a request for approval. If the manager will approved it will go to the finance team else the rejected email go to the requestor/employee.
If the manager approved and requests reimbursement, go to the Finance team. They will get an email, and the reimbursement is added to the Planner as a task for the finance team.
Based on the Progress status of the task in the planner, we will update the status of items in the SharePoint list, also we will send an email to the requestor for updates about the request.
Power Apps Gallery Control Examples [20 Real world Scenarios]
Download this app to learn about 20 real-world examples of Power Apps Gallery Control, including:
- Power Apps Gallery Display Items from the Collection
- Power Apps Gallery Display Items from SharePoint List
- Delete Power Apps Item(s) from Power Apps Gallery
- Power Apps Gallery Count Rows
- Power Apps Gallery with Conditional Formattings
- Power Apps Gallery Filter By another gallery
- Power Apps Filter Gallery for top 5 values
- Power Apps Gallery Order By
- Power Apps Gallery Group By
- Power Apps Gallery Validations
- Power Apps Gallery Pagination
- Power Apps Gallery Filter
- Power Apps Gallery Filter by Current User
- Power Apps Gallery Filter by Single Dropdown
- Power Apps Gallery Filter by Multiple Dropdown
- Power Apps Gallery Filter by Text Input
- Power Apps Gallery Filter by Last N Days
- Power Apps Gallery Filter by Date Range
- Power Apps Gallery Filter by Checkbox
- Power Apps Gallery Navigation
For this, I have two custom SharePoint Lists, i.e., Car Rental Services and Car Gears.
The first SharePoint List [Car Rental Services] has these many columns below:
- Car Name – Single line of text
- Car Type – Choice
- Seats – Number
- Color – Choice
- Daily Price – Single line of text
- Rent Date – Date and time
- Location – Choice
- Person Name – Single line of text
- Person Email – Single line of text
- Mobile Number – Number
- Car Image – Image
- Confirmation Status – Choice
Similarly, the second SharePoint List contains only three columns i.e.
- Car ID – Single line of text
- Car Name – Lookup
- Car Gear Type – Choice
We will use the Power Apps Gallery Control with several examples based on these two SharePoint Lists.
The second SharePoint list [Car Gears] is used for only the 6th example, i.e., Power Apps Gallery Filter By another gallery, and the 9th example, i.e., Power Apps Gallery Group By (Lookup Column).
You can follow the read-me file to learn how to import and use the Canvas App.