web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Flow not populating al...
Power Automate
Unanswered

Flow not populating all information into SharePoint List

(1) ShareShare
ReportReport
Posted on by 4
Hello, 
 
I have created a flow to copy list items from List A to List B when the "status" column in List A is changed to "Completed". I would like everything from that list item in List A to copy over to List B. Everything copies right now except for "Assigned QCer" and "Docs to QC" columns. These are multiple select columns, and the QCer is a people column as well. I have the flow set up this way (see below). When I did not have the compose actions, it wouldn't copy at all. Now I have compose action, but it only copies some data.
 
Compose Actions:
 
 
And the Create Item Action:
Categories:
I have the same question (0)
  • Michael E. Gernaey Profile Picture
    53,963 Moderator on at
    HI,
     
    Please be more specific. What does "it only copies some data mean" exactly? Please make sure to show examples of a run, with data inputs / outputs and with pictures showing what is missing please.
     
    Thanks
  • KB-26022109-0 Profile Picture
    4 on at
    @Michael E. Gernaey I can't respond to your comment for some reason. But here is a successful run that left out the Assigned field and the Documents to QC field.
     
     
    As you can see below, it runs twice, even though the flow only shows being triggered once. And one line item leaves out the QCers column information and the Docs to QC information. Otherwise they are complete duplicates.
     
    Inputs for "when an item is created or modified" for this run:
    {
        "host": {
            "connectionReferenceName""shared_sharepointonline",
            "operationId""GetOnUpdatedItems"
        },
        "parameters": {
            "dataset""https://company.sharepoint.com/sites/GlobalProposalDevelopmentTeam",
            "table""e4b4bcca-79e3-4c94-ac8f-f4217d11a125"
        }
    }
     
     
    Outputs (I did replace my company name and employee emails with things like company.sharepoint/employee.name.company.com etc.:
     
     
     "headers": {
            "Cache-Control": "max-age=0, private",
            "Transfer-Encoding": "chunked",
            "Location": "https://flow-apim-msmanaged-na-westus2-01.azure-apim.net/apim/sharepointonline/d566971d89484ac58971a2b94516adc5/datasets/https%253A%252F%252Fcompanyname.sharepoint.com%252Fsites%252FGlobalProposalDevelopmentTeamPMRFI/tables/e4b4bcca-79e3-4c94-ac8f-f4217d11a125/onupdateditems?triggerstatecl=MTszO2U0YjRiY2NhLTc5ZTMtNGM5NC1hYzhmLWY0MjE3ZDExYTEyNTs2Mzg3Njk3MTY4NzcwMDAwMDA7OTI3ODUwMzcz",
            "Retry-After": "21600",
            "Vary": "Origin,Accept-Encoding",
            "X-NetworkStatistics": "4294967295,4294967295,4294967295,4294967295,4294967295,4294967295,4294967295,4294967295",
            "X-SharePointHealthScore": "2",
            "X-MS-SPConnector": "1",
            "X-SP-SERVERSTATE": "ReadOnly=0",
            "DATASERVICEVERSION": "3.0",
            "SPClientServiceRequestDuration": "791",
            "IsOCDI": "0",
            "X-DataBoundary": "NONE",
            "X-1DSCollectorUrl": "https://mobile.events.data.microsoft.com/OneCollector/1.0/",
            "X-AriaCollectorURL": "https://browser.pipe.aria.microsoft.com/Collector/3.0/",
            "SPRequestGuid": "eef7cfc8-62ac-4f9b-bae5-89f7dacffe54",
            "request-id": "eef7cfc8-62ac-4f9b-bae5-89f7dacffe54",
            "MS-CV": "oYhDTtAQAIA2/tzE5pUi7Q.0",
            "Alt-Svc": "h3=\":443\"",
            "Strict-Transport-Security": "max-age=31536000",
            "X-Frame-Options": "SAMEORIGIN",
            "Content-Security-Policy": "frame-ancestors 'self' teams.microsoft.com *.teams.microsoft.com *.skype.com *.teams.microsoft.us local.teams.office.com teams.cloud.microsoft *.office365.com goals.cloud.microsoft *.powerapps.com *.powerbi.com *.yammer.com engage.cloud.microsoft word.cloud.microsoft excel.cloud.microsoft powerpoint.cloud.microsoft *.officeapps.live.com *.office.com *.microsoft365.com m365.cloud.microsoft *.cloud.microsoft *.stream.azure-test.net *.microsoftstream.com *.dynamics.com *.microsoft.com onedrive.live.com *.onedrive.live.com securebroker.sharepointonline.com;",
            "MicrosoftSharePointTeamServices": "16.0.0.25812",
            "X-Content-Type-Options": "nosniff",
            "X-MS-InvokeApp": "1; RequireReadOnly",
            "P3P": "CP=\"ALL IND DSP COR ADM CONo CUR CUSo IVAo IVDo PSA PSD TAI TELo OUR SAMo CNT COM INT NAV ONL PHY PRE PUR UNI\"",
            "X-AspNet-Version": "4.0.30319",
            "X-Powered-By": "ASP.NET",
            "x-ms-environment-id": "default-b67d722d-aa8a-4777-a169-ebeb7a6a3b67",
            "x-ms-tenant-id": "b67d722d-aa8a-4777-a169-ebeb7a6a3b67",
            "x-ms-dlp-re": "-|-",
            "x-ms-dlp-gu": "-|-",
            "Timing-Allow-Origin": "*",
            "x-ms-apihub-cached-response": "false",
            "x-ms-apihub-obo": "false",
            "Date": "Fri, 07 Mar 2025 19:14:47 GMT",
            "Content-Type": "application/json; charset=utf-8",
            "Expires": "Thu, 20 Feb 2025 19:14:47 GMT",
            "Last-Modified": "Fri, 07 Mar 2025 19:14:47 GMT",
            "Content-Length": "10149"
        },
        "body": {
            "@odata.etag": "\"6\"",
            "ItemInternalId": "282",
            "ID": 282,
            "Title": "Last, First Name",
            "RequestID": "RFP_140577/140578_Qvidian_MKB",
            "Status": {
                "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
                "Id": 3,
                "Value": "Completed"
            },
            "Status#Id": 3,
            "AssignedQCer": [
                {
                    "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
                    "Claims": "i:0#.f|membership|employee.name@company.com",
                    "DisplayName": "Last, First Name",
                    "Email": "employee.name@company.com",
                    "Picture": "https://company.sharepoint.com/sites/GlobalProposalDevelopmentTeamPMRFI/_layouts/15/UserPhoto.aspx?Size=L&AccountName=employee.name@company.com",
                    "Department": "Department",
                    "JobTitle": "Job Title"
                }
            ],
            "AssignedQCer@odata.type": "#Collection(Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser)",
            "AssignedQCer#Claims": [
                "i:0#.f|membership|employee.name@company.com"
            ],
            "AssignedQCer#Claims@odata.type": "#Collection(String)",
            "QCerNeeded": {
                "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
                "Id": 4,
                "Value": "US Needed"
            },
            "QCerNeeded#Id": 4,
            "ProjectDueDate": "2025-03-07",
            "ClientName": "Invirsa",
            "BC_x0023__x0028_s_x0029_": "140577/140578",
            "TypeofOpportunity": {
                "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
                "Id": 0,
                "Value": "RFP"
            },
            "TypeofOpportunity#Id": 0,
            "Swimlane": {
                "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
                "Id": 1,
                "Value": "Advanced"
            },
            "Swimlane#Id": 1,
            "Brand": {
                "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
                "Id": 1,
                "Value": "Thermo Fisher"
            },
            "Brand#Id": 1,
            "QCStartDate": "2025-03-07",
            "QCStartTime": "10 AM EST",
            "QCCompletionDate": "2025-03-07",
            "QCCompletionTime": "2 PM EST",
            "DocumentstoQC": [
                {
                    "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
                    "Id": 0,
                    "Value": "Qvidian"
                }
            ],
            "DocumentstoQC@odata.type": "#Collection(Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference)",
            "DocumentstoQC#Id": [
                0
            ],
            "DocumentstoQC#Id@odata.type": "#Collection(Int64)",
            "EstimatedLevelofEffort": {
                "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
                "Id": 3,
                "Value": "3"
            },
            "EstimatedLevelofEffort#Id": 3,
            "EstimatedNumberofQCers": {
                "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
                "Id": 0,
                "Value": "1"
            },
            "EstimatedNumberofQCers#Id": 0,
            "Notes": "n/a",
            "Submitter": {
                "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
                "Claims": "i:0#.f|membership|employee.name@company.com",
                "DisplayName": "Last, First Name",
                "Email": "employee.name@company.com",
                "Picture": "https://company.sharepoint.com/sites/GlobalProposalDevelopmentTeamPMRFI/_layouts/15/UserPhoto.aspx?Size=L&AccountName=employee.name@company.com",
                "Department": "Clinical Research Group",
                "JobTitle": "Proposal Manager"
            },
            "Submitter#Claims": "i:0#.f|membership|employee.name@company.com",
            "Modified": "2025-03-07T19:13:35Z",
            "Created": "2025-02-28T21:28:55Z",
            "Author": {
                "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
                "Claims": "i:0#.f|membership|employee.name@company.com",
                "DisplayName": "Last, FirstEmployeeName",
                "Email": "employee.name@company.com",
                "Picture": "https://company.sharepoint.com/sites/GlobalProposalDevelopmentTeamPMRFI/_layouts/15/UserPhoto.aspx?Size=L&AccountName=employee.name@company.com",
                "Department": "Clinical Research Group",
                "JobTitle": "Proposal Specialist"
            },
            "Author#Claims": "i:0#.f|membership|employee.name@company.com",
            "Editor": {
                "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
                "Claims": "i:0#.f|membership|employee.name@company.com",
                "DisplayName": "Last, FirstEmployeeName",
                "Email": "employee.name@company.com",
                "Picture": "https://company.sharepoint.com/sites/GlobalProposalDevelopmentTeamPMRFI/_layouts/15/UserPhoto.aspx?Size=L&AccountName=employee.name@company.com",
                "Department": "Department Name",
                "JobTitle": "Job Title"
            },
            "Editor#Claims": "i:0#.f|membership|employee.name@company.com",
            "{Identifier}": "Lists%252fTFS%2bQC%2bTracker%252f282_.000",
            "{IsFolder}": false,
            "{Thumbnail}": {
                "Large": null,
                "Medium": null,
                "Small": null
            },
            "{Link}": "https://company.sharepoint.com/sites/GlobalProposalDevelopmentTeamPMRFI/_layouts/15/listform.aspx?PageType=4&ListId=e4b4bcca%2D79e3%2D4c94%2Dac8f%2Df4217d11a125&ID=282&ContentTypeID=0x0100760B64616F9884479C9FA40AD883C06900C348089433F1484CA8070AAA99BD7E30",
            "{Name}": "Last, FirstEmployeeName",
            "{FilenameWithExtension}": "Last, FirstEmployeeName",
            "{Path}": "Lists/TFS QC Tracker/",
            "{FullPath}": "Lists/TFS QC Tracker/282_.000",
            "{ContentType}": {
                "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedContentType",
                "Id": "0x0100760B64616F9884479C9FA40AD883C06900C348089433F1484CA8070AAA99BD7E30",
                "Name": "Item"
            },
            "{ContentType}#Id": "0x0100760B64616F9884479C9FA40AD883C06900C348089433F1484CA8070AAA99BD7E30",
            "{HasAttachments}": false,
            "{VersionNumber}": "6.0",
            "{TriggerWindowStartToken}": "MTszO2U0YjRiY2NhLTc5ZTMtNGM5NC1hYzhmLWY0MjE3ZDExYTEyNTs2Mzg3Njk2NTIwNzcwMDAwMDA7OTI3ODMzMDM5",
            "{TriggerWindowEndToken}": "MTszO2U0YjRiY2NhLTc5ZTMtNGM5NC1hYzhmLWY0MjE3ZDExYTEyNTs2Mzg3Njk3MTY4NzcwMDAwMDA7OTI3ODUwMzcz"
        }
     
     
     
    For "CREATE ITEM"
     
    {
        "host": {
            "connectionReferenceName""shared_sharepointonline",
            "operationId""PostItem"
        },
        "parameters": {
            "dataset""https://company.sharepoint.com/sites/SPDQCReview",
            "table""1efc55ab-7a2c-4623-8292-5d7e257e71b5",
            "item/Title""Employee Name",
            "item/Re""RFP_140577/140578_Qvidian_MKB",
            "item/AssignedQCer""join(triggerOutputs()?['body/AssignedQCer'], ', ')",
            "item/QCerNeeded/Value""US Needed",
            "item/ProjectDueDate""2025-03-07",
            "item/ClientName""Invirsa",
            "item/BC_x0023__x0028_s_x0029_""140577/140578",
            "item/TypeofOpportunity/Value""RFP",
            "item/Swimlane/Value""Advanced",
            "item/Brand/Value""COMPANY",
            "item/QCStartDate""2025-03-07",
            "item/QCStartTime""10 AM EST",
            "item/QCCompletionDate""2025-03-07",
            "item/QCCompletionTime""2 PM EST",
            "item/DocumentstoQC""join(triggerOutputs()?['body/DocumentsToQC'], ', ')",
            "item/EstimatedLevelofEffort/Value""3",
            "item/EstimatedNumberofQCers/Value""1",
            "item/Notes""n/a",
            "item/QCReview"false
        }
     
    And Outputs:
      "statusCode": 201,
        "headers": {
            "Cache-Control": "max-age=0, private",
            "Vary": "Origin",
            "X-NetworkStatistics": "4294967295,4294967295,4294967295,4294967295,4294967295,4294967295,4294967295,4294967295",
            "X-SharePointHealthScore": "0",
            "X-MS-SPConnector": "1",
            "X-SP-SERVERSTATE": "ReadOnly=0",
            "DATASERVICEVERSION": "3.0",
            "SPClientServiceRequestDuration": "305",
            "IsOCDI": "0",
            "X-DataBoundary": "NONE",
            "X-1DSCollectorUrl": "https://mobile.events.data.microsoft.com/OneCollector/1.0/",
            "X-AriaCollectorURL": "https://browser.pipe.aria.microsoft.com/Collector/3.0/",
            "SPRequestGuid": "6841efee-cca0-4b25-82c1-a3d06388e19a",
            "request-id": "6841efee-cca0-4b25-82c1-a3d06388e19a",
            "MS-CV": "oYhDT0DQAIAhFlmuIr5jlA.0",
            "Alt-Svc": "h3=\":443\"",
            "Strict-Transport-Security": "max-age=31536000",
            "X-Frame-Options": "SAMEORIGIN",
            "Content-Security-Policy": "frame-ancestors 'self' teams.microsoft.com *.teams.microsoft.com *.skype.com *.teams.microsoft.us local.teams.office.com teams.cloud.microsoft *.office365.com goals.cloud.microsoft *.powerapps.com *.powerbi.com *.yammer.com engage.cloud.microsoft word.cloud.microsoft excel.cloud.microsoft powerpoint.cloud.microsoft *.officeapps.live.com *.office.com *.microsoft365.com m365.cloud.microsoft *.cloud.microsoft *.stream.azure-test.net *.microsoftstream.com *.dynamics.com *.microsoft.com onedrive.live.com *.onedrive.live.com securebroker.sharepointonline.com;",
            "MicrosoftSharePointTeamServices": "16.0.0.25812",
            "X-Content-Type-Options": "nosniff",
            "X-MS-InvokeApp": "1; RequireReadOnly",
            "P3P": "CP=\"ALL IND DSP COR ADM CONo CUR CUSo IVAo IVDo PSA PSD TAI TELo OUR SAMo CNT COM INT NAV ONL PHY PRE PUR UNI\"",
            "X-AspNet-Version": "4.0.30319",
            "X-Powered-By": "ASP.NET",
            "x-ms-environment-id": "default-b67d722d-aa8a-4777-a169-ebeb7a6a3b67",
            "x-ms-tenant-id": "b67d722d-aa8a-4777-a169-ebeb7a6a3b67",
            "x-ms-dlp-re": "-|-",
            "x-ms-dlp-gu": "-|-",
            "Timing-Allow-Origin": "*",
            "x-ms-apihub-cached-response": "true",
            "x-ms-apihub-obo": "false",
            "Date": "Fri, 07 Mar 2025 19:14:48 GMT",
            "Content-Length": "3548",
            "Content-Type": "application/json; charset=utf-8",
            "Expires": "Thu, 20 Feb 2025 19:14:48 GMT",
            "Last-Modified": "Fri, 07 Mar 2025 19:14:48 GMT"
        },
        "body": {
            "@odata.etag": "\"1\"",
            "ItemInternalId": "112",
            "ID": 112,
            "Title": "Employee Name",
            "Re": "RFP_140577/140578_Qvidian_MKB",
            "AssignedQCer": [],
            "AssignedQCer@odata.type": "#Collection(Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser)",
            "AssignedQCer#Claims": [],
            "AssignedQCer#Claims@odata.type": "#Collection(String)",
            "QCerNeeded": {
                "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
                "Id": -1,
                "Value": "US Needed"
            },
            "QCerNeeded#Id": -1,
            "ProjectDueDate": "2025-03-07",
            "ClientName": "Invirsa",
            "BC_x0023__x0028_s_x0029_": "140577/140578",
            "TypeofOpportunity": {
                "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
                "Id": 0,
                "Value": "RFP"
            },
            "TypeofOpportunity#Id": 0,
            "Swimlane": {
                "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
                "Id": 1,
                "Value": "Advanced"
            },
            "Swimlane#Id": 1,
            "Brand": {
                "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
                "Id": 1,
                "Value": "Thermo Fisher"
            },
            "Brand#Id": 1,
            "QCStartDate": "2025-03-07",
            "QCStartTime": "10 AM EST",
            "QCCompletionDate": "2025-03-07",
            "QCCompletionTime": "2 PM EST",
            "DocumentstoQC": [],
            "DocumentstoQC@odata.type": "#Collection(Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference)",
            "DocumentstoQC#Id": [],
            "DocumentstoQC#Id@odata.type": "#Collection(Int64)",
            "EstimatedLevelofEffort": {
                "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
                "Id": 2,
                "Value": "3"
            },
            "EstimatedLevelofEffort#Id": 2,
            "EstimatedNumberofQCers": {
                "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
                "Id": 0,
                "Value": "1"
            },
            "EstimatedNumberofQCers#Id": 0,
            "Notes": "n/a",
            "QCReview": false,
            "Modified": "2025-03-07T19:14:49Z",
            "Created": "2025-03-07T19:14:49Z",
            "Author": {
                "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
                "Claims": "i:0#.f|membership|employee.name@company.com",
                "DisplayName": "Employee Name",
                "Email": "employee.name@company.com",
                "Picture": "https://Company.sharepoint.com/sites/SPDQCReview/_layouts/15/UserPhoto.aspx?Size=L&AccountName=employee.name@company.com",
                "Department": "Clinical Research Group",
                "JobTitle": "Strategic Proposal Dev Spec"
            },
            "Author#Claims": "i:0#.f|membership|employee.name@company.com",
            "Editor": {
                "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
                "Claims": "i:0#.f|membership|employee.name@company.com",
                "DisplayName": "Employee Name",
                "Email": "employee.name@company.com",
                "Picture": "https://company.sharepoint.com/sites/SPDQCReview/_layouts/15/UserPhoto.aspx?Size=L&AccountName=employee.name@company.com",
                "Department": "Clinical Research Group",
                "JobTitle": "Strategic Proposal Dev Spec"
            },
            "Editor#Claims": "i:0#.f|membership|employee.name@company.com",
            "{Identifier}": "Lists%252fQC%2bReview%2bTracker%252f112_.000",
            "{IsFolder}": false,
            "{Thumbnail}": {
                "Large": null,
                "Medium": null,
                "Small": null
            },
            "{Link}": "https://company.sharepoint.com/sites/SPDQCReview/_layouts/15/listform.aspx?PageType=4&ListId=1efc55ab%2D7a2c%2D4623%2D8292%2D5d7e257e71b5&ID=112&ContentTypeID=0x01001A6069906E6AA44599D474594649AF3000BA09F9A2415FCC45BB0DCC25504F1F07",
            "{Name}": "Employee Name",
            "{FilenameWithExtension}": "Employee Name",
            "{Path}": "Lists/QC Review Tracker/",
            "{FullPath}": "Lists/QC Review Tracker/112_.000",
            "{ContentType}": {
                "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedContentType",
                "Id": "0x01001A6069906E6AA44599D474594649AF3000BA09F9A2415FCC45BB0DCC25504F1F07",
                "Name": "Item"
            },
            "{ContentType}#Id": "0x01001A6069906E6AA44599D474594649AF3000BA09F9A2415FCC45BB0DCC25504F1F07",
            "{HasAttachments}": false,
            "{VersionNumber}": "1.0"

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 840

#2
Valantis Profile Picture

Valantis 661

#3
Haque Profile Picture

Haque 589

Last 30 days Overall leaderboard