cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
HubbardInc
Helper III
Helper III

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

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

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

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

 

PowerApps FilterGallery17 Update Field.jpg

Also, here is the items property of the dropdown.

 

HubbardInc_0-1597145768298.png

 

v-xida-msft
Community Support
Community Support

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.

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?

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.

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,219)