Combo box with id and display value, won't save id

(0) Share

Report

Posted on by ruth

212

I have a combo box with the following command in Items which displays nicely

ForAll( audit,
{CID: ID,
cboDisplay: ID & " - " & ContractPeriod.Value & ": " & Text(DateValue('ContractPeriod:BegDate'.Value,"en-US"),ShortDate) & " - " & Text(DateValue('ContractPeriod:EndDate'.Value,"en-US"),ShortDate)})

On Update, I'd like to save the ID. I've tried cboAID.Selected.CID and I'm getting an error that it's expecting a record. So I remove CID and enter cboAID.Selected, I don't get the error but my ID doesn't save.

Any idea on how to save the ID?

ruth

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Sort by

WarrenBelz 155,495 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @ruth ,

What is the name and type of field you are writing back to? If it is a Lookup field (which I suspect), what is the list name and field name it is looking up?

Was this reply helpful? Yes No
ruth 212 on at

Like (0)

Report
Copy link

Link copied!

Yes, it is a lookup field. The list name is audit and the field name is the ID. An audit can have multiple observations. So I need to store the audit id in the observations list.

Was this reply helpful? Yes No
WarrenBelz 155,495 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @ruth ,

You are Patching Audit - what is the name of the field and list that the Lookup field in audit you are trying to patch is looking up?

Was this reply helpful? Yes No
ruth 212 on at

Like (0)

Report
Copy link

Link copied!

Hi @WarrenBelz ,

Observations links to Audits via the Audit ID (internal ID) field. In the Observations list, I have AID which is a lookup to the Audit ID.

ruth

Was this reply helpful? Yes No
Verified answer

WarrenBelz 155,495 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @ruth ,

To confirm, the field in Audit which is shown in cboAID (Combo Box) is called 'Audit ID', which is a lookup to a field called AID in the Observations list? If so your update will be something like this

{ Value:cboAID.Selected.xxxx, Id: LookUp( Observations, AID = cboAID.Selected.xxxx ).ID }

with xxxx being the valid output of the combo box (you have not told me the Items)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
WarrenBelz 155,495 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @ruth ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
ruth 212 on at

Like (0)

Report
Copy link

Link copied!

Thanks @WarrenBelz , I have not resolved it yet. Had to put it aside, but am back on it.

I had to read your response a few times as I think you have it reversed.

Audit ID is in the Audit list - it uniquely identifies an Audit though it is the Sharepoint generated ID. In the Observations list, AID is a lookup to the ID in the Audit list. So, an audit consists of one to many observations.

Here is the cboAID items code:

ForAll(
'Audit',
{ CID: ID,
cboDisplay: ID & " - " & ContractPeriod.Value & ": " & Text( DateValue( 'ContractPeriod:BegDate'.Value, "en-US"), ShortDate) & " - " & Text(DateValue('ContractPeriod:EndDate'.Value,"en-US"),ShortDate)
}
)

Ruth

Was this reply helpful? Yes No
ruth 212 on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz THANKS!! This did it. I just changed Observations to Audit and plugged in the corrected ids. Works GREAT Thanks, sooo much!!!!

Was this reply helpful? Yes No