Replace a name or names in multi-select person column based on a Filter Query

[jaanihsm]

Hi! I need help trying to replace a name or names in a multi-person column that satisfies a filter query.

I have 2 SP Lists, ListData2 and ListData2Delegation.

ListData2 have a multi-person column for Signers (similar to approvers).

ListData2Delegation is where approvers log their time away for a period of dates (From and To).

My flow checks to see if any of the approvers of an item in main list are away and then I want to replace their names with the assigned backups from delegation List. Is this possible? My filter query works but I don't know how to update the names in multi-person column in ListData2.

Here is my flow:

Any help is appreciated! Thank you!

[v-yueyun-msft]

Hi , @jaanihsm 

According to your description, do you mean you want to directly replace the multiple-person  column in SharePoint?

And you use the Filter query to get the items from your list and you just need to update the item when the length =1.

So you can refer to this flow:

outputs('Get_items')?['body/value']?[0]?['Signers']

item()?['Claims']

Best Regards,

Yueyun Zhang

[jaanihsm]

Hi @v-yueyun-msft. Thank you for your response! Appreciate your help and time! 🙂

Do I add Select after Get Items? I tried this but I get this error...

Also, will this work in this scenario? 

I have 2 Signers, first one is available, second one needs to delegate? 

How do I get the Signers array where it keeps the first name then replaces the second name with the assigned backup?

Thank youu! 🙂

[v-yueyun-msft]

Hi， @jaanihsm 

This error code means that your expression is wrong in your side.

outputs('Get_items')?['body/value']?[0]?['Signers']

In my test flow ,  What it achieves is to replace all the people in the column.

For example, the column in List A contains Person A and Person B; Then I'll replace the column in List B with Person A, Person B.

And , i am not surely understand the meaning of "get the Signers array where it keeps the first name then replaces the second name with the assigned backup". Can you give me a screenshot for your two SharePoint list and give me a detailed example for it so that i can help you better!

Best Regards,

Yueyun Zhang

[jaanihsm]

Thank you so much for the follow-up response @v-yueyun-msft! I really appreciate your time and efforts!

Here is my main list (ListData2) where users create an item for signature/approval.

Signers is a dynamic multi-select person column.

Assigned To is a single-select person column and automatically gets the first signer then moves to the next one in the sequence.

Signatures Collected (default value = 0) column counts the number of actions taken by the approvers. Flow continues to forward the approval until Signatures Collected = number of signers, unless anyone rejects.

Here is my second list (ListData2Delegation) where signers/approvers log their time away.

Delegating To is a single-select person column. 'Created by' will be one of the approvers that assigns a backup for a period of time (From, To).

My Approval flow type is Approve/Reject - First to respond because I need the signers to sign in order.

I need help to update the 'Signers' column through a Filter query from the ListData2Delegation

where > (Author/Email eq 'Current Signer or Current Assigned To') and (From le 'utcNow()' ) and (To ge 'utcNow()').

Replace the current 'Signer' (when it's his/her turn) with assigned back up from ListData2Delegation and apply the same to other Signers if applicable.

Here is my approval flow without the delegation part. Not sure how to properly execute it. The screenshot from my first post is a test flow I'm trying.

Thanks in advance for sharing your knowledge! Greatly appreciate it!

[jaanihsm]

Is it best to first, take all Signers names and check if any of them have delegates based on the filter query, then replace the names of Signers satisfying the query while maintaining the Signers sequence and then start the flow approval? I'm not sure which way is better or easier. And I'm lost as to how to execute the delegation requirement. Thanks again @v-yueyun-msft !

[v-yueyun-msft · Accepted solution]

Hi , @jaanihsm 

I create a test flow and this is my test Sahrepoint and the end result in my side:

This is my flow , you can refer to :

(1)The Select and Get items action:

concat( ' Author/EMail eq ''' , item()?['Email'] , '''' )

join(body('Select'),' or')

utcNow()

(2)The Select 2 and initialize variable action:

item()?['Author']?['Email']

(3)The Apply to each action:

contains(body('Select_2') , items('Apply_to_each')?['Email'] )

true

xpath( xml(json(concat('{"root":{"item":',outputs('Get_items')?['body/value'],'}}'))) , concat('/root/item[./Author/Email="' , items('Apply_to_each')?['Email']  , '"]/DelegatingTo/Claims/text()' ))?[0]

items('Apply_to_each')?['Claims']

(4) The Update item action:

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance! 

Best Regards,

Yueyun Zhang

[jaanihsm]

Hi @v-yueyun-msft! I believe this is what I need! I will test and let you know! Thank you so much for your support! Greatly appreciate it. 🙂

[jaanihsm]

Hi @v-yueyun-msft! I was able to test it today. Looks great! Working as expected! Genius!

However I have a follow-up question. I also have an 'Assigned To' single-select person column which automatically gets the Signer name who is their turn to sign (based from the Signer order).

How do I update it too? In this case, first Signer was delegated. Please see screenshot.

I tried something but my outputs are inconsistent. 😞 Thank you so muuuch! 🙌

[jaanihsm]

Hi @v-yueyun-msft! I hope you can help me with this last part on my flow. 🙂 Thank you in advance for your support!

[v-yueyun-msft]

Hi , @jaanihsm 

Thanks for your response! If you want to make the first person in [Assigned To] column.

You can use this expression in the last action:

first(variables('Approvers'))?['Claims']

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance! 

Best Regards,

Yueyun Zhang

[jaanihsm]

That did it @v-yueyun-msft! Thank you so much! You're so helpful! Appreciate your time and knowledge-sharing! 🙂