Lookup Field Update Item Properties

[HubbardInc]

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

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

[PowerAddict]

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

[HubbardInc]

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

[HubbardInc]

Also, here is the items property of the dropdown.

[v-xida-msft]

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,

[HubbardInc]

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?

[v-xida-msft · Accepted solution]

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,