Friday, September 11, 2020

Power Automate with SharePoint - 'Update Item' Action - Working with Multiple selection in PeoplePicker field

While updating an item in a list/library, we need to specify values for all or at the least mandatory fields.

However, specifying values for PeoplePicker fields, that too with Multiple selection becomes a tedious job. More so as the values to be selected in 'Apply To Each' loop are not directly available in the Dynamic content option.

To demonstrate an easy way to achieve this, I will start with a list - 'Department Details' with some regular columns like - DeptName, Address, and a PeoplePicker column named Associates.




We need to update the Status field based on presence of Address 1 values in the list. So, if Address 1 field is not empty, we need to update the Status field to ‘Valid’, else the default value is ‘Invalid’.

Now, create a new Flow using ribbon button for Automate.

As the Associates field is a Mandatory field, we need to specify values for this field too.

Initialize an Array variable – AssociatesArray


Add a new action – ‘Apply to each’, and in ‘Select an output from previous step’, select ‘Associates’ array field as shown below - 

It should be - triggerBody()?['Associates']



Add a ‘Compose’ action inside this ‘Apply to each’ loop, and add an array structure and ‘Claims’ value for the Associates field, as shown below:

The value should be - items('Appy_to_each')['Claims'] when you hover over it.


Add action – ‘Append to Array Variable’, and use the outputs from Compose action, as shown below – 


Insert a condition to check if Address 1 is not empty.

 


If Yes, then add ‘Update Item’ action, and specify all mandatory fields.

For Associates field, the Flow provides an option to manually enter the multiple person values.

 


However, we are going to use the array we created in previous step. Click on ‘Switch to input entire array’ as shown below –



I hope this post was helpful. For any other queries, please post comments.

I thank you for reading and look forward to seeing you on my blog next week!



Tuesday, August 30, 2016

How to repackage project for sandbox which do not use code

If you are not using code in sandbox solution,  but cannot deploy the solution due to auto generated assembly... here is solution
Just set the  “Include Assembly in Package” project property to false in visual studio.
Please note that running code-based sandbox solutions in the SharePoint Online environment will be disabled

Monday, June 22, 2015

WebAssembly


WebAssembly is answer for Faster WebPrograms will be compiled in a load time efficient format for web. The browser will execute the code faster in this format. The execution model is specifically desinged to serve as a compilation target for web.

The people behind the project include JavaScript inventor  Brendan Eich,  Mozilla's Firefox team ,  Google's Chrome team and Microsoft team. The team is working from more than one year behind close door to close the loose ends.

Wepages and application over operating  system of Android, Apple and microsoft has found a way to merge. The technology powering these app and pages will become one. HUg huge win for Computer and mobile world.










Sunday, January 25, 2015

Iframes IE doesnt trust external sites

Wiered error. The session value were getting lost in one of the App part( provider hosted apps with several App Parts).The site has to send an extra header to say to IE to be trusted.


1
2
3
4
    
      
        name="P3P" value='CP="CAO PSA OUR"'/>

Thursday, July 25, 2013

SharePoint Foundation 2010 is not supported on Microsoft SQL Server 2014.

https://technet.microsoft.com/en-us/library/cc288751(v=office.14).aspx

Sunday, June 2, 2013

How to hide 12:00 AM from Calendar View

try
var elementlink = document.getElementsByTagName('a');

for(var i=0; i < elementlink.length; i++) {
      elementlink[i].innerHTML = elementlink[i].innerHTML.replace("12:00 AM","");
    }

Thursday, June 21, 2012

Twitter support needed on SharePoint

you have option of third party like
http://www.virtosoftware.com/sharepoint/social-aggregator-web-part

Thursday, June 2, 2011

how to check if member is in group

isExist = IsUserMemberOfGroup(currentUser, groupName); 

Saturday, December 25, 2010

ISO format of date needed in list creation via soap

Specify date field value in ISO format, for example 2016-03-09T00:00:00Z

Thursday, November 25, 2010

custom list form must exist in e folder for the list

this is must . if form are outside they wouldn't work