Unanswered

Help on default value for lookup lists

(0) Share

Report

Posted on by JohnArrow1

On the browser screen of my Powerapp I have a drop down to a sharepoint list:. The name of the control is DropdownEvent, the Data Item (SharepointList) is called ObservationEvent and the Column name is Title.

I want to make what users select from the above the default value for all new records added in my EditForm. The edit form points to another SharePoint list “Observations 03” which has a column called Event.

I have seen a number of posts regarding default values for lookup lists but have not been able to get anything to work. I’m also not sure if I should be making the default value in the Data Card or the Combo Box. Any help on the syntax and where it should be is welcomed.

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (13)

Answers (0)

WarrenBelz 154,445 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @JohnArrow1 ,
Firstly I am assuming that the output from your control DropDownEvent will be DropdownEvent.Selected.Title as the Items property will refer to ObservationEvent.Title in some way.
I am assuming also that when you refer to all new records added in my EditForm, you are putting this form in FormMode.New and creating a new record. Also assuming this form has the DataSource 'Observations 03' and a control in it connected to the field Event
So bearing this in mind make the Default of this control
DropdownEvent.Selected.Title
and it should populate your field 'Observations 02'.Event with the value selected in DropdownEvent when the new form is submitted.

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
JohnArrow1 12 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the quick reply. I am new to powerapps and as far as I know all your assumptions are correct.

It doesn't seem to like the syntax.

I have attached some screenshots that might help.

Thanks

Powerapp error.docx

Was this reply helpful? Yes No
WarrenBelz 154,445 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Thanks @JohnArrow1 ,
Your attachment will not open here. Try typing DropdownEvent.Selected. (note the second dot) and see what values are underneath.
What is the Items property of DropdownEvent?

Was this reply helpful? Yes No
JohnArrow1 12 on at

Like (0)

Report
Copy link

Link copied!

Hope you see the attachments now. I do see title as an option for the second dot point but I get a red X that says expected record value.

Was this reply helpful? Yes No
WarrenBelz 154,445 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @JohnArrow1 ,
The Default needs to be on the Control, not the Card.
As well, I would put this to allow for other use of the control value during Edit or View modes
If( YourFormName.Mode = FormMode.New, //replace with your form name DropdownEvent.Selected.Title, Parent.Default )
You will also need to put the Card Default back to what it was before

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 154,445 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@JohnArrow1 ,
Adding to the below, looking at your error again, there are two issues.
The first I have covered below in where the code needs to go. The second was a question I had not asked - what type of column is Event in your data source. I am suspecting it is a Choice column going by the error - can you please confirm if this is the case.

Was this reply helpful? Yes No
JohnArrow1 12 on at

Like (0)

Report
Copy link

Link copied!

Hi Warren it is a list not a choice. I had no luck with this
If(EditForm1.Mode = FormMode.New,
DropdownEvent.Selected.Title,
Parent.Default
)

I'm presuming I need to have lookup in the code which was what I was originally playing with but could not get the syntax right.

John

Was this reply helpful? Yes No
WarrenBelz 154,445 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Ok @JohnArrow1 ,
This should be really simply except I cannot see you data structure or controls.
What type of control is Event contained in on your EditForm1 and what type of field is it in your List - can you please send me screen shots of both of these.

Was this reply helpful? Yes No
JohnArrow1 12 on at

Like (0)

Report
Copy link

Link copied!

Hi Warren

Some screen shots

Was this reply helpful? Yes No
JohnArrow1 12 on at

Like (0)

Report
Copy link

Link copied!

and some more
ObservationEvent is a Sharepoint list used as a lookup for Observation 03 which has a column called Event.

Hope that makes sense.

John

Was this reply helpful? Yes No