Pages

Wednesday, April 29, 2020

Friday, March 20, 2020

How to find MS Flow instance running to SharePoint list item or document


We implemented MS flow in the custom share point list, when an item is created then MS flow will trigger & do business logic's.

if we go to MS flow Log History, which is very difficult to find which MS flow run is related to that Sharepoint List ID

this is workaround to update hyperlink value with MS flow instance running URL, So that you can click on the link to open respective MS flow instance.


Add compose action with workflow function to get flow details


Add another compose action and update this formula

concat('https://asia.flow.microsoft.com/manage/environments/',
workflow()?['tags']['environmentName'],
'/flows/',
workflow()?['name'],
'/runs/',
workflow()?['run']['name'])



update compose 2 value into hyperlink column in the list


now you can click on the link to open MS flow


Thursday, February 13, 2020

Microsoft Flow – How to clear people or person fields in SharePoint list items

Using the HTTP request I can clear the people or person field by setting the StringId to an empty string and the Id to -1.


Wednesday, August 21, 2019

PowerApps Set Dropdown default value formula

I have PowerApps form with dropdown box is Priority, when user open the form , by default it will load dropdown value is Low.

Here you are:

LookUp(Choices(ITHelpDesk.'Priority'),Value="Low")


Thursday, July 4, 2019

How do I get Current User Login detail from MS power Apps

You can use the Office 365 Users Connector to get this information. 

Current User
Office365Users.MyProfile().Department
Office365Users.MyProfile().DisplayName
Office365Users.MyProfile().GivenName
Office365Users.MyProfile().Id
Office365Users.MyProfile().JobTitle
Office365Users.MyProfile().Mail
Office365Users.MyProfile().MailNickname
Office365Users.MyProfile().Surname
Office365Users.MyProfile().TelephoneNumber
Office365Users.MyProfile().UserPrincipalName
Office365Users.MyProfile().AccountEnabled

To show information about another user:
Office365Users.UserProfile(name@company.com).Department
Office365Users.UserProfile(name@company.com).DisplayName
Office365Users.UserProfile(name@company.com).GivenName
Office365Users.UserProfile(name@company.com).Id
Office365Users.UserProfile(name@company.com).JobTitle
Office365Users.UserProfile(name@company.com).Mail
Office365Users.UserProfile(name@company.com).MailNickname
Office365Users.UserProfile(name@company.com).Surname
Office365Users.UserProfile(name@company.com).TelephoneNumber
Office365Users.UserProfile(name@company.com).UserPrincipalName
Office365Users.UserProfile(name@company.com).AccountEnabled

To show information about another user's manager:Office365Users.Manager(name@company.com).Department
Office365Users.Manager(name@company.com).DisplayName
Office365Users.Manager(name@company.com).GivenName
Office365Users.Manager(name@company.com).Id
Office365Users.Manager(name@company.com).JobTitle
Office365Users.Manager(name@company.com).Mail
Office365Users.Manager(name@company.com).MailNickname
Office365Users.Manager(name@company.com).Surname
Office365Users.Manager(name@company.com).TelephoneNumber
Office365Users.Manager(name@company.com).UserPrincipalName
Office365Users.Manager(name@company.com).AccountEnabled

Thursday, June 6, 2019