Answered

Multiple Comments for one customer using two SharePoint lists

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I think I may have a rather complex problem. Here's what I've done:

Step 1 - Main Screen (Contacts list),

Edit/view form (Form1) using a dropdown menu (OrgDropDown) from Contacts list; users select an Organization name from the OrgDropDown menu to populate Form 1.

Step 2 - Notes Screen (Notes list), gallery form for users to see notes from prior visits to the Organization that was selected in OrgDropDown on the main screen, which uses Contacts list.

Step 3 - I need users to be able to add new note through a form that will save in the Notes list based on the organization that was selected from OrgDropDown on main screen Contacts list.

Contacts list: Organization field is single-line text field

Notes list: Organization is a LookUp field from Organization in Contacts list

How do I do step 3?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

v-monli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @ttaylor ,

You need to use a Patch function to update the record to the LookUp field. The formula should be something like:

Patch(Notes, Defaults(Notes), {Title:TextInput1.Text,
Lookup:{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference", Id:Dropdown1.Selected.ID, Value:Dropdown1.Selected.Value} } )

Dropdown1 is the dropdown control name in your first screen.

Regards,

Mona

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
I'm getting an error that "Lookup column does not exist." I'm using this OnSelect forumula:

Patch(Notes, Defaults(Notes), {Title:TextInput1.Text,
Lookup:{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference", Id:OrgDropDown.Selected.ID, Value:OrgDropDown.Selected.Value} } )

)

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
I'm braindead. What should be in my Title field? The dropdown box name or the fieldname in the Sharepoint list?
{Title:TextInput1.Text,

Was this reply helpful? Yes No
v-monli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ttaylor ,

You should replace the "TextInput1" with the name of your textinput control that holds the title field.

Regards,

Mona

Was this reply helpful? Yes No