Hello,
I am trying to copy a SharePoint list from one SharePoint site to another. I have it almost working it copies everything but a column with "Person or Group" type. I researched this a little and it was suggested that I use the Initialize variable followed by an append to array variable. The flow works but nothing populates for that particular column. Flow looks like this:
So I don't think it's actually capturing the array/ contents of the column. Any thoughts? Thanks
Hi @ice2921 ,
Unfortunately, the answer is no.
When you set the value of a Person column, that person (i.e. user account) must already exist within MS 365 tenant (Azure AD/Entra ID).
A workaround for you could be to create a new Text column, then populate that column with the display name of the account that don't exists in your MS 365 tenant. This way, you wont loose this user account information.
Ellis
____________________________________
If I have answered your question, please mark the post as ☑️ Solved.
If you like my response, please give it a Thumbs Up.
My Blog Site
new error message:
The specified user [{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser","Claims":"i:0#.f|membership|user@domain","DisplayName":"user, user","Email":"user@domain.com","Picture":"https://","Department":"","JobTitle":""}] could not be found.
clientRequestId: e4331639-b9d2-48ad-82be-7e05018e1053
serviceRequestId: ac151ea1-b0f0-0000-2c71-a72a71026cf4
Hi @ice2921 ,
Based on what I can see from the output of the Compose action, please try:
Remember to switch map to text mode for the Select action by clicking the icon as shown below:
Here is the output from my demo flow:
Ellis
____________________________________
If I have answered your question, please mark the post as ☑️ Solved.
If you like my response, please give it a Thumbs Up.
My Blog Site
Hi @ice2921 ,
Try searching for the Dynamic content using the search box:
If that doesn't work, add a compose action as shown below, then please share the runtime output of the Compose action:
Ellis
____________________________________
If I have answered your question, please mark the post as ☑️ Solved.
If you like my response, please give it a Thumbs Up.
My Blog Site
Hi @ice2921 ,
You could try the following flow:
Here are the actions within the Apply to each loop:
Ellis
____________________________________
If I have answered your question, please mark the post as ☑️ Solved.
If you like my response, please give it a Thumbs Up.
My Blog Site
#1
WarrenBelz
146,670
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,004
Most Valuable Professional
Share
Report
All responses (
Answers (
