Lookup Field Update Item Properties

(0) Share

Report

Posted on by HubbardInc

122

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

PowerAddict 7,316 Most Valuable Professional on at

Like (0)

Report
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

Was this reply helpful? Yes No
HubbardInc 122 on at

Like (0)

Report

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

Was this reply helpful? Yes No
HubbardInc 122 on at

Like (0)

Report

Also, here is the items property of the dropdown.

Was this reply helpful? Yes No
v-xida-msft on at

Like (0)

Report
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,

Was this reply helpful? Yes No
HubbardInc 122 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Verified answer

v-xida-msft on at

Like (1)

Report
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,

Was this reply helpful? Yes No