Power Automate not writing to a SharePoint List lookup column

Sam Schwarts (US) 0 Reputation points
2024-04-17T23:28:44.1166667+00:00

Situation:

I am looking to create a Power Automate flow that populates a lookup column. Users take an excel report, and upon a manual trigger, the automation populates an "Event List" with the report data. In the "Event List" there is a lookup column which references an "Accounts List" that has 200,000 rows of different accounts.

Result:

The automation functions and populates the list, EXCEPT FOR THE "Account" LOOKUP COLUMN. Upon review, these items that are attempting to be uploaded ARE in our "Account List". There is no reason they shouldn't populate.

Issue:

I cannot diagnose why I cannot populate the "Account" field in this lookup column when the "Account" is confirmed to exist in the "Account List" being referenced by the lookup column (screenshot 1; "Account (Blank value)" populates (Single line text column acting as a safety net), but you can see the account is in the source list but field is not populating.).

Screenshot 2 of PA flow logic. There is some branching logic upstream not shown, but can be shared if needed.

Any help is appreciated.
lookup column not populating

Account Field Not populating

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,650 questions
SharePoint Development
SharePoint Development
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Development: The process of researching, productizing, and refining new or existing technologies.
2,673 questions
SharePoint Workflow
SharePoint Workflow
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Workflow: An orchestrated and repeatable pattern of business activity, enabling data transformation, service provision, and information retrieval.
509 questions
Windows Server PowerShell
Windows Server PowerShell
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.PowerShell: A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
5,374 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. AllenXu-MSFT 16,091 Reputation points Microsoft Vendor
    2024-04-18T01:36:54.31+00:00

    Hi @Sam Schwarts (US),

    Power Automate is currently not supported in the Q&A forums, the supported products are listed over here https://learn.microsoft.com/en-us/answers/products (more to be added later on).

    You can ask the experts in the dedicated Power Automate forum over here: https://powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity.

    Thanks for your understanding.

    Have a good day:)

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments