Unanswered

Set default value for choice box with sharepoint lookup column

(0) Share

Report

Posted on by LukasR

Hello everyone,

I have created a simple datamodel in sharepoint by referencing other lists through lookup columns. In my app I now want to automatically set the default value of a choice box by a global variable. The variable contains the ID of the record I want to reference. I know I can create a record [variable] and set this as the defaultselecteditems to that record. The correct ID then appears but after submitting the ID does not appear in the sharepoint list.

What am I doing wrong here?

Thanks for your help, Lukas

Categories:

Building Power Apps

I have the same question (0)

All responses (14)

Answers (0)

Sort by

CNT 10,921 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@LukasR Can you share the formulas you have in the default property of this combobox and also the update property of the datacard that holds this combobox.

Was this reply helpful? Yes No
LukasR 16 on at

Like (0)

Report
Copy link

Link copied!

Hello,

these are the settings of the combobox.

and this is whats in the update property,

Thanks for your help,
Lukas

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@LukasR The DefaultSelectedItems can't be just an ID, it has to be a table with the record that you want. So you have to do a Filter and find the matching record,
Filter([@Putendaten_EinstallDaten], DurchgangsID=CalId)

Was this reply helpful? Yes No
LukasR 16 on at

Like (0)

Report
Copy link

Link copied!

@CNTThanks for your reply. I tried that, too, but get the error that I cannot compare a record (DurchgangsID) to a text (CalID).

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@LukasR Looks like DurchgangsID is a LookUp. Then you will have to have, DurchgangsID.theID (rename it to the correct name)

Was this reply helpful? Yes No
LukasR 16 on at

Like (0)

Report
Copy link

Link copied!

@CNTYes, DurchgangsID is a Lookup, that looks up the ID of the referenced list and I need that ID to be the defaultselecteditem. So what is the correct formula for that?

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@LukasR What is the datasource for the EditForm?

Was this reply helpful? Yes No
LukasR 16 on at

Like (0)

Report
Copy link

Link copied!

@CNTthe datasource for the EditForm ist Putendaten_Einstalldaten and it looksup the ID of the list "Putendaten_Durchgang"

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@LukasR If DurchgangsID is a LookUp to "Putendaten_Durchgang" which has an ID column then try this,
Filter([@Putendaten_EinstallDaten], DurchgangsID.ID=CalId)

Was this reply helpful? Yes No
LukasR 16 on at

Like (0)

Report
Copy link

Link copied!

@CNTI'm sorry, it's so difficult with me!

This still doesn't work. I get the error message that the Name DurchgangsID.ID is not valid and it doesn't recognize the identifier. I double checked the column name "DurchgangsID" in "Putendaten_Einstalldaten" and there is an "ID" in the lookedup list "Putendaten_Durchgang".

I somehow think, I have to filter the Putendaten_Durchgang list. Isn't that the correct record i want to get???

Was this reply helpful? Yes No