Excel Macro Code

 Excel Macro Code

Test

 Processing..

Test

Processing...

Test

Processing....

Test

Processing...

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

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.