How to get a graph API token in Postman tool

1) Open postman native application from desktop
2) Go to authorization tab
3) Click "Get new access token"

4) Fill the following properties

Auth URL :  

https://login.microsoft.com/(Tenant ID)/oauth2/v2.0/authorize

Access Token URL :

https://login.microsoft.com/(Tenant ID)/oauth2/v2.0/token

Scope: 

https://graph.microsoft.com/.default

Grant Type:

Client Credentials

5) Click Request token

6) You will receive the token under the existing token

7) Select Add token to header as shown in above image and click use token

8) You are ready to run graph APIs from postman

How to get Tenant ID?
1) Get your Tenant ID from Azure AD. Choose Properties - your Tenant ID is the Directory ID. 

How to get Client ID?
1)  You have to register your app in Azure. https://docs.microsoft.com/en-us/graph/auth-v2-service#4-get-an-access-token

How to get Secret key?
2) You have to register your app in Azure https://docs.microsoft.com/en-us/graph/auth-v2-service#4-get-an-access-token

How to use filter query in get items in Microsoft Flows

You can  use filter query option to filter the data in Microsoft flows

e.g. I want to filter the data where expiry date not equal to null. You can do it by following way

1) Expand the advance options
2) Enter the condition as shown in below image Epirydate ne null

1) NE = Not equal to
2) EQ = Equal to
3) LEQ = Lest than equal to
4) GEQ = Greater than equal to

Use AND, OR expression in flow conditions

Usually in Microsoft flows you can add only one condition in basic mode. There are no options to add expression like AND, OR. To use these expressions go to advance mode and use the AND, OR . e.g.

I want to use a condition

if (contract value is < 100000 and standard term = 'Yes' )
then
      Do this
else
      Do else


1) To use it in the flows enter the first condition in basic mode, go to advance mode and  copy it in notepad
2) Delete the first condition
3) Apply the second condition, go to advance mode and  copy it in notepad

Create the condition yourself with @and

@and
(
     lessOrEquals(body('Get_item')?['Contractvalue'], 100000),
     equals(body('Get_item')?['standardterms']?['Value'], 'Yes')
)

NOTE: remove all other @ signs from conditions expect with @and

1) Paste the created condition in MS flows condition box in advance mode and you are done.
2) Save the flow and see it is not showing any errors


For more information please use the following URL

How to handle Apostrophe in Ms Flows

Question: How to handle Apostrophe in Ms Flows?

Answer : Use the replace function to handle it 

replace(['Registered_x0020_Business_x0020_'],'''',' ')

It will replace the Apostrophe with a blank space.

MS Flows | SharePoint Choice Field with multiple selections or pick list, not supported. Workaround

Question: MS Flows | SharePoint Choice Field with multiple selections or pick list, not supported. Workaround

Answer:

1) Take a string or array variable, I am taking a string variable

2) Then use apply each and append to string function to collate the value in one string, I have placed a "," to separate the values

Then use this string in your flows.

MS Flows | How to remove last few character in MS Flows from a string

Question: How to remove last few characters from a string in MS Flows?

Answer:

substring(variables('LicenseTypes'),0,sub(length(variables('LicenseTypes')),2))

1) I took example of a string variable

2) Make sure change the variable with your values

3) Make sure you Change the number value at end, I am removing last 2

characters from the string

MS Flows | How to add days function works

Question: How to use add days function in MS flows

OR

Question: How to play with Date and time in MS Flows


Answer:

This answer shows you to add 7 days in SharePoint Date field


formatDateTime(addDays(formatDateTime(string(['License_x0020_Expiry_x0020_Date'])), 7))

1) Convert that date field to string
2) Convert into ISO 8601 format
3) Add 7 days
4) Return the ISO 8610 format date