cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

Lookup Field Update Item Properties

I have a lookup field that uses the following properties for the items:

HubbardInc_0-1597086460915.png

 

Then the update property is this but it does NOT update the record. Please help.

HubbardInc_1-1597086509228.png

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Lookup Field Update Item Properties

Hi @HubbardInc ,

Thanks for your detailed statement, I got it. I think the solution I provided above could achieve your needs. I think the 'Ticket Number' column is the LookUp column in your 'Support Ticket Notes' List, which references ID column value from the 'DWH Portal Support Tickets' List.

 

Within the Edit form, please set the Update property of the 'Ticket Number' data card  to following:

{
  Id: Value(DataCardValue70.Selected.NewID),
  Value: Value(DataCardValue70.Selected.NewID)
}

or

{
  Id: DataCardValue70.Selected.ID,
  Value: DataCardValue70.Selected.ID
}

Note: The DataCardValue70 represents the 'Ticket Number' ComboBox.

 

Regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

6 REPLIES 6
Highlighted
Super User II
Super User II

Re: Lookup Field Update Item Properties

Hi @HubbardInc 

 

Is your 2nd screenshot correct? It shows a Fill color. Can you please share the correct screenshot? 

 

That being said, I think I know what the issue may be. Since you are using AddColumns function, it creates a temporary modified table, so it is no longer the same as the original table. 

 

You will have to do a LookUp to fetch the original table's value. Something like this (without looking at the current Update property, this is just a guess):

LookUp('DWH Portal Support Tickets', ID = Dropdown.Selected.Value)

Also, let me know the Items property of the dropdown. 

 

Let me know if this helps. 

 

---
If you like this reply, please give kudos (Thumbs Up). And if this solves your problem, please mark this reply as a solution by selecting Accept as Solution. This makes it easier for others to find answers to similar questions. 

 

Thanks!

Hardit Bhatia

Microsoft Business Applications MVP

Blog | Twitter | LinkedIn | Facebook | YouTube  |  Email

Highlighted
Helper II
Helper II

Re: Lookup Field Update Item Properties

I'm sorry, here is the correct screen shot.

 

PowerApps FilterGallery17 Update Field.jpg

Highlighted
Helper II
Helper II

Re: Lookup Field Update Item Properties

Also, here is the items property of the dropdown.

 

HubbardInc_0-1597145768298.png

 

Highlighted
Community Support
Community Support

Re: Lookup Field Update Item Properties

Hi @HubbardInc ,

Could you please share a bit more about the 'Ticket Number' column in your data source? A Text type column or Number type column or Choice type column?

 

If the 'Ticket Number' column is a LookUp type column in your data source, I think there is something wrong with the formula you typed within the Update property of the 'Ticket Number' data card. Please consider set the Update property of the 'Ticket Number' data card to following:

 

{
   Id: Value(DataCardValue70.Selected.NewID),
   Value: Value(DataCardValue70.Selected.NewID)
}

 

Note: I assume that the 'Ticket Number' column reference values from the ID column in your 'DWH Portal Support Tickets' List.

 

Please try above solution, check if the issue is solved.

 

Regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Helper II
Helper II

Re: Lookup Field Update Item Properties

Hi there!

 

When someone submits an IT Ticket, it uses the sharepoint built in "ID" field for the ticket number.

 

Then, a support technician may want to create a note on a ticket or more than one note through a period of time. To do this, we have another sharepoint list called Support Ticket Notes. There is a lookup column in this list that looks up ticket numbers from the support ticket list.

 

Does this explain it better?

Highlighted
Community Support
Community Support

Re: Lookup Field Update Item Properties

Hi @HubbardInc ,

Thanks for your detailed statement, I got it. I think the solution I provided above could achieve your needs. I think the 'Ticket Number' column is the LookUp column in your 'Support Ticket Notes' List, which references ID column value from the 'DWH Portal Support Tickets' List.

 

Within the Edit form, please set the Update property of the 'Ticket Number' data card  to following:

{
  Id: Value(DataCardValue70.Selected.NewID),
  Value: Value(DataCardValue70.Selected.NewID)
}

or

{
  Id: DataCardValue70.Selected.ID,
  Value: DataCardValue70.Selected.ID
}

Note: The DataCardValue70 represents the 'Ticket Number' ComboBox.

 

Regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Watch Now

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (6,203)