Answered

Collect function in PowerApps not populating data in lookup field in SharePoint list

(0) Share

Report

Posted on by Shaunus

Hi potential question answerer,

I'm building a Power App that has a gallery of "Issues". When you select an item my "frmIssues" goes into update mode via "varCurrentIssue" variable. I want to attach some referential data to this Issue item but I'm getting some strange behaviour..

I have a "BugCreator" SharePoint list I want to link to the "Issues" SharePoint list:

I have a button that that creates some data in the BugCreator list that should tie back to the Issue:

Collect(BugCreator, {Title:"Bug: " & varCurrentIssue.Title, StoryPoints:5, IssueTrackerItem:varCurrentIssue});
Set(varStatus, "Bug Created");
SubmitForm(frmIssue);
ResetForm(frmIssue);

The problem is the Title is there and looks good:
Title: "Bug: A New problem",

StoryPoints: 5,

IssueTrackerItem: !Required Info

Why is there no data in only the lookup column?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

mdevaney 29,991 Moderator on at

Like (1)

Report
Copy link

Link copied!
@Shaunus

The LookUp column requires a special structure. I am assuming varCurrent issue doesn’t contain something that looks like this:

{ '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference", Id: 1, Value: "Text Description" }

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
Shaunus 4 on at

Like (0)

Report
Copy link

Link copied!

@mdevaney Thanks for the quick reply 😁

You've solved it in one!
I couldn't work out why it would accept the type but wouldn't link it SP side.. I did see that syntax but couldn't for the life of me figure out how to get it to compile until you laid it out for a 5 year old.

I normally work with C# - feel like a right idiot now 😅

Thanks again, much appreciated!

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!

@Shaunus

Anytime man! Best of luck building your app.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No