Power Automate not writing to a SharePoint List lookup column

Question

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.

Answer 1

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.