Power automate - JackHu88/Comm GitHub Wiki

If(
    IsEmpty('BSO List'), 
If(SearchInput.Text ="", 
Filter('Channel Partner', gtDocStatus=Dropdown1.Selected.Value And AppAuthorID=UserPin),
SortByColumns(
Filter('Channel Partner', StartsWith(gtDocSerialNo,SearchInput.Text) Or StartsWith(ContractNo,SearchInput.Text)),
     "gtSubmitDate",Ascending)),
If(SearchInput.Text ="", 
Filter('Channel Partner', gtDocStatus=Dropdown1.Selected.Value),
SortByColumns(
Filter('Channel Partner', StartsWith(gtDocSerialNo,SearchInput.Text) Or StartsWith(ContractNo,SearchInput.Text)), 
"gtSubmitDate",Ascending)))

@equals(triggerBody()?['Business_x0020_Unit']?['Value'], 'Indiana')

$(document).ready(function () {  
    ExecuteOrDelayUntilScriptLoaded(AttachClickEventToButton, 'SP.js');  
});  
  
### This method attaches click event to input button.  
function AttachClickEventToButton() {  
    try {  
        $("#btnTriggerMicrosoftFlow").click(function () {  
            StartMicrosoftFlowTriggerOperations();  
        });  
    }  
    catch (e) {  
        console.log("Error occurred in AttachClickEventToButton " + e.message);  
    }  
}  
  
### This method triggers the microsoft flow  
function StartMicrosoftFlowTriggerOperations() {  
    try {  
        var dataTemplate = "{\r\n    \"emailaddress\":\"{0}\",\r\n    \"emailSubject\": \"{1}\",\r\n    \"emailBody\": \"{2}\"\r\n}";  
        var httpPostUrl = "<Supply with the HTTP POST Url>";  
        //Call FormatRow function and replace with the values supplied in input controls.  
        dataTemplate = dataTemplate.FormatRow($("#txtEmailAddress").val(), $("#txtEmailSubject").val(), $("#txtEmailBody").val());  
  
        var settings = {  
            "async": true,  
            "crossDomain": true,  
            "url": httpPostUrl,  
            "method": "POST",  
            "headers": {  
                "content-type": "application/json",  
                "cache-control": "no-cache"  
            },  
            "processData": false,  
            "data": dataTemplate  
        }  
  
        $.ajax(settings).done(function (response) {  
            console.log("Successfully triggered the Microsoft Flow. ");  
        });  
    }  
    catch (e) {  
        console.log("Error occurred in StartMicrosoftFlowTriggerOperations " + e.message);  
    }  
}  
  
### This method formats the rowTemplate by replacing the placeholders based on the arguments passed.  
String.prototype.FormatRow = function () {  
    try {  
        var content = this;  
        for (var i = 0; i < arguments.length; i++) {  
            var replacement = '{' + i + '}';  
            content = content.replace(replacement, arguments[i]);  
        }  
        return content;  
    }  
    catch (e) {  
        console.log("Error occurred in FormatRow " + e.message);  
    }  
}  

//use variables in expression
variables('DelegateSecurityLeader')

//get field
first(body('Get_items')?['value'])?['ID']

//Get multiple user field
first(first(body('Get_FYI')?['value'])?['Users'])?['Claims']

//get user claims
first(body('Get_items')?['value'])?[Claims']

//update user field in in item property
"Site_x0020_Manager": {
    "Claims": if(empty(variables('SiteManager')),null,variables('SiteManager'))
}
  
//update choice field in item property
{
  "WF_x0020_Status": {
    "Value": "Released"
  }
}

//update user claims
SiteManager
if(empty(variables('SiteManager')),null,variables('SiteManager'))

//update mutiple user field
Owners
concat(';','[email protected]',';','[email protected]')

//clear user field
single-valued user field: ‘<user field name>Id’ : -1
multi-valued user field: ‘<user field name>Id’ : { ‘results’: [0] }

Send http requst to sharepoint
{
"__metadata": {
"type": "SP.Data.COEAuditListItem"
},
"CurrentOwnerId": "-1"
}
https://jobs.collab365.community/how-to-update-the-sharepoint-people-picker-field-using-power-automate/?__cf_chl_captcha_tk__=8be9109fb76120cfcc86eca70e8278a8fc64da4f-1610688783-0-AYyGX7jrbiWKYMAA4P70X2bxFledvPpWXhW0ffi2zq9PK-kJNZHfUSUkU-xqlrrymeTdk5sPsELBmaDNDj5p24_ssemIbZbNV7N79RPANndxcy64e-fHS4_EkCTjNC_JeV_p_Hs4IF9uoEv76JrLtk5mH7f_jMEWfx847XaLRTHADUQ0YLhG3v7bh3SOv7dJvyeuTg4ZBjhgkh4CLBqcWoChhfvSSpQ9nyVruADXgJuGDgeBlFQ89XDteL1dUgb3MqhVVOMjEtoTo1N9edS0hK_aTr-j8AswblSGT8eYCofPI5qBaagA3MAQQdDQQNEsegEWZnZG6wsLH4hcGZ1R_msMNIGR16mPx5Dy4Y3SlGe3dfBiFRrgzpCzV_9cncLev8uep94_jLQd5STlUN23-jOK3viV58RaNCjYxD_tsle7D59D_vbya4RkfoGi3Syiuzlf41a1dbP83Xm5cEE1YFWtNDf0o5bNZ5OLnBpLaaTQZ-eChoYNd-lcA7PyJ6RkoJ7OofKnqZsYpg9xjpPJn9UlWdS9AxxJgEXAFkIWFf19PuVPYEwx3Fucic2DqtwTeVPCHx1XAZuDAY4HN647s2hpz25nlRXhsYe6d1nAa_rH

uriComponentToString(replace(uriComponent(triggerOutputs()?['body/Description']), '%0A', '<br>'))