cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
thori19
Frequent Visitor

Multi Select Persons Field - sequence of Persons

I am trying to follow Reza's example on using Multi Select Persons field from a MS365 Sharepoint list (refer to this link: https://www.youtube.com/watch?v=gb_FUeRjgg4&list=PLTyFh-qDKAiFUGTtwSwFT79Y7_jq_Aipe&index=3)

13:30 min in the video. In my case, I cannot change the sequence of the people inserted - they seem to be fixed somehow. Anyone has an idea to to release the given order?

Thank 

1 ACCEPTED SOLUTION

Accepted Solutions

I don't know if I'm understanding your issue. They are usually sorted in the order they were added.

Please share a screenshot of your flow.

View solution in original post

5 REPLIES 5
ryleybauer
Resolver II
Resolver II

Hi @thori19, I don't think you can control the order as I'm pretty sure they're shown in the order they were added, not any specific sorting. 

In your flow, you can probably do some sorting if the display order is important. Maybe add them all to an array variable (using email or UPN value is probably best), then you could perform a sort on the array (this is advanced) and then set the multi-select field to "array mode" and use the array value in place of the multi-select people. 

 

To switch a multi-select field to accept an array of all values, click on the "T" box to change the symbol to a "table" icon. 

ryleybauer_0-1656518695286.png

 

thori19
Frequent Visitor

Dear ryleybauer,

 

thanks for your response. Actually, this is basicly the issue: I DONT want to get them sortet. I want them in the order they get inserted.

but tHey are getting sorted according to smth, which I even cannot really distingish: names are like

„Wxxx Sxxx

Rxxxx Txxxx

Gxxxx Sxxxx“.

 

So no real sequence to be identified by me at the first glance.

Anyhows: if I change them into

“Wxxx Sxxx,

Gxxxx Sxxxx

Rxxxx Txxxx“,

it falls automaticly back to the first order after saving.

is there maybe smth in the corporate directory, which might force sharepoint to maintain the same order allways? Any hidden index possible?

Or is there any workarround (maybe with JSON) to disable this appearently automated sorting function?

 

thanks for assist!

 

Thori19

I don't know if I'm understanding your issue. They are usually sorted in the order they were added.

Please share a screenshot of your flow.

thori19
Frequent Visitor

Hey ryleybauer,

 

🤒trying again this morning, you are right.  But I am 100% sure that yesterday, it didn't work out.

Thanks and sorry for disturbance!

Thori19

 

thori19
Frequent Visitor

Hey again,

 

now I have the same issue again, and I am able to hardcopy it. Pls refer to marked lines from the Sharepoint list: "RT" ist always first; "MP" always last. No matter if I am inserting the data visa versa - tries out serveral times. But somewhen, it also worked they way you-ve answere. But I have no clue why and how.

 

Names are selected from corporate directory of my company.

 

Here the hardcopies - hoping, they are visibnle enough:

original list:

thori19_3-1657030695998.png

 

thori19_2-1657030672884.png

change sequence:

thori19_4-1657030724772.png

save - but still same result as before:

thori19_5-1657030741593.png

 

 

 

 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,027)