Free Websites to Download PSD’s, Vectors & Images

There are several websites you can visit in case you don’t find the vectors or PSDs you are looking for. By the way, Freepik is a community-driven site. All of the contents are contributed by users. I have found a few more websites like this and listed below.

Most sites listed below also use the same concept as Freepik. So, here is the list.

1. FreePik

   

   Freepik is known as a website to download vectors and PSDs. To download vectors and PSDs on Freepik you don’t need to spend a dime. It’s just, there are some rules you need to obey regarding the use of the contents you downloaded. Most contents require you to credit the authors.

   Available : FREE and Registration Required for Premium Files and UNLIMITED Downloads.
   URL : freepik.com

2. Vexels

   
   Vexels is the design stock where everyone can find whatever they need – whether you’re a Graphic Designer, a Merch-Seller or an Agency, we’ve got something for everybody.

   On Vexels you can explore and discover the best ready-made graphics for personal or commercial projects – from versatile backgrounds, trendy icons and fantastic logo templates to print-ready designs and everything in between. They’ve got more than 71.000 awesome design resources that will save you lots of time and money on all your projects.

   Furthermore Vexels recently launched their revolutionary T-Shirt Maker. The Maker allows all subscribers to create outstanding T-Shirt Designs by combining and editing thousands of graphics from the Vexels design stock – giving them the opportunity to create unique T-Shirt Designs and elevate their T-Shirt Shop to the next level!

   Available : FREE & Paid Subscriptions
   URL : vexels.com

3.  Pixabay
   Find your perfect free image or video to download and use for anything.

   

   ✓ Free for commercial use

   ✓ No attribution required

   ✓ High quality images.

   Available : FREE
   (Low Resolution, Registration Required for High Resolution Downloads)
   URL : pixabay.com

4. UnSplash

   Beautiful, free images gifted by the world’s most generous community of photographers. Better than any royalty free or stock photos. Unsplash has been used in everything from Apple keynotes to the default theme shipped with WordPress. You’ve probably already seen a photo from Unsplash, you just didn’t know it.

   

   Available : FREE
   URL : unsplash.com

5. Flaticon

   

   Flaticon is a great place to download vector icons. There are about 649,000 vector icons you download on this site, which are grouped in 12,282 packs. You can download the whole pack or individual icons by adding your preferred icons to the Collections (something like shopping cart). There are four different file formats offered by Flaticon; PNG, SVG, ESP and PSD. You can use the vectors you downloaded for any purpose, but attribution is required. If you want to download a certain pack, you will be asked to create a Flaticon account first.

   Available : FREE, Registration Required for UNLIMITED Downloads and PREMIUM Features.
   URL : flaticon.com

   Hope these site help you.
   I Shall update the same post with more or i shall post a new article with more as i find in the future.

   Thank you
   MJ

   Please Note : All the information i extracted from the relevant websites of these services and also from bettertechtips.com blog.

Creating a Simple Leave Request Form with Approval Process Flow

Let’s start by creating a simple User Form with Microsoft Forms. I will be using this form to get the details from the user for this leave process.

Creating a Microsoft Form for the Application

So i created a Form with the title “Leave Request Form” and added a few fields.

I created a form with the following fields :

• No. of Days – text field
• Date From – date field
• Date To – date field
• Reason – text choice field

Just to make it simple i didn’t add more fields. But feel free to add more. One of the best features of Forms i like is its responsiveness. Any for will be perfectly responsive for mobile / tablet screens which is amazing.

Creating the Flow linking the Form

After creating the forms it’s time to create the flow. One of the easiest way to use flow is to know how to look for a suitable template on flow or to use a template and modify it to the scenario. In this i will use a template and then modify it to my specifications.

You can find what we want in the Approvals section under Templates or we can search for “approval” on the Search Template box.

Selecting a Microsoft Flow template

This is a template by Microsoft with Forms Linked to an Approval Process which will be easy to modify to our Leave Request Scenario.

Now that the connections are connected click on “Continue” and your flow will be created. You will be directed to the following page which is where we can edit the Flow. I have zoomed out the flow to show the entire mapping of the Flow.

First select the Microsoft Form you created from the “drop down selection” menu.

Here you can see a loop “Apply to each” which implies the same. Which these set of actions will be carried out for each and every response of the Form we linked.

Awesome !! Now we need to get the manager email address of this employee. O365 has several method where we can call a method and retrieve a response with these information.

Please Note : this will only work if your organization structure is correctly inserted via the O365 admin panel. Usually this configuration is done when an account is created.

Insert an Action to Retrieve User Information & Manager Information

For this we are going to use an “Action”. Click on the “+” sign in between the “Get Response Details” section and “Start an Approval” and select “Add an Action”.

Okay, next search for the “Office 365 User” Connector from the popup section as below.

Once you’ve selected that locate the method name “Get User Profile (V2)” and select it.

When you select it you will add a section to the Flow like this.

Here as you can see we need to pass a parameter to this Action and its named “User (UPN)”.

When you click on that text box or click on “Add dynamic content” link which is in blue you will get another popup window which is a very interesting and important one. This is where we can access all the details which comes from the responses or the methods we call during an Action.

From the dynamic content list select the “Responder’s Email” which will give us the email address to pass for the O365 – Get User Profile (V2) Action.

After adding it will look like below.

Similarly we need to get the Manager’s information out, so we are going to use the “Get Manager (V2)” Action next. For that we can pass the “Mail” attribute which will be returned to us during the previous “Get User Profile” Action.

Once selecting the Mail attribute from the dynamic content section it will look like this.

Now we can access the “Manager” details from our next section which is the “Start Approval” section. Here you can be creative and use the attributes to compose a meaningful message for the approval. For this example i composed an email like this.

Now that we have done the composing part, next comes the condition. Which we will use to get the response and alert the Requester regarding his/her leave request.

Finally in the “Yes” and “No” sections we can add the “Send Email / Notification” Action to notify the Requester regarding his/her request. First remove the “Create” SharePoint item which is included into the template. You can remove an item by clicking the 3 dots / more menu and selecting delete.

Once that is deleted add the “Send Email” Action and a few details.

You are all set. Now we can Save the Flow and Test it by Submitting a requesting via the Microsoft Form we created at the beginning of this scenario.

You will know if the Flow is running with this “On” button on the Top Right of your Flow Interface.

Here are my test results.

This slideshow requires JavaScript.

************************************************************

Hope this worked for you and it helped.

Please do leave a comment or drop me an email for any support on this.

Cheers
Marino
marinojoseph18@gmail.com

Insert Data into SQL using On Premises Gateway (OPG) & Microsoft O365 Flow

Hi, my name is Marino, and i am a Software Engineer / Productivity Trainer. Today i had a requirement of connecting a local database (SQL) with a Microsoft Flow application. I manage to do this using a Blank flow Application combining with an “On Premises Gateway” by Microsoft with my local database on my laptop. Here’s how i did it.

Creating the Flow Application

First i got a blank flow and inserted two random fields into it.

Adding two fields to save onto Local DB

Here i added two text fields input1 and input2 for this example.

Creating a Database Locally

Here i added two text fields input1 and input2 into a test table i created for this example.

here my local server had the following configuration with windows authentication.

Setting up the OPG on local machine.

for this to work ideally the OPG should be installed on a computer which is always on with an internet connection, but it also works on personal computers.

An on-premises data gateway is required when one or more Azure Analysis Services servers in the same region connect to on-premises data sources. To learn more about the gateway, see On-premises data gateway.

Download the OPG (On Premises Gateway) from here.
https://www.microsoft.com/en-us/download/details.aspx?id=53127  

How to install

1. Run setup.
2. Select a location, accept the terms, and then click Install.

Sign in to Azure. The account must be in your tenant’s Azure Active Directory. This account is used for the gateway administrator. Azure B2B (guest) accounts are not supported when installing and registering the gateway.

Register

In order to create a gateway resource in Azure, you must register the local instance you installed with the Gateway Cloud Service.

1. 1. Select Register a new gateway on this computer.
   2. Type a name and recovery key for your gateway. By default, the gateway uses your subscription’s default region. If you need to select a different region, select Change Region.
      
   3. Once you do the above configuration it will take a few minutes and automatically close.
   4. then Open “On Premises Gateway”
      

 

 

 

 

 

Then it will show running. Now you are all set. 🙂

Connect OPG to Flow.

Now add a SQL object on the flow and start filling the server details and select “Connect via On-Premises Data Gateway”

Next this window will collapse and you will get a select box with the tables of the database with the fields. Select the correct fields from the Flow trigger form and set them to this SQL insert row section like below.

You are all done now. Hit save and test. 🙂

Also check the database. Your data will be inserted.

Hope this worked for you and it helped.

Please do leave a comment or drop me an email for any support on this.

Cheers
Marino
marinojoseph18@gmail.com