Answered

PowerApps form on SharePoint list - use new dropdown field to display parent.default

(0) Share

Report

Posted on by StuCrooks

I have a SharePoint list which I've created a PowerApps form from.

I have a string field "Sales Rep" which is on the form, but I would like to have a dropdown list of available sales reps (Not office365 list - but a custom table of Staff - which I have a collection for) and when a rep is selected from the dropdown and form saved, it updates the "Sales Rep" field in SharePoint rather than having to manually type in a sales rep name in the string field.

So, essentially I want a dropdown populated with custom collection (this bit I can do), and selecting a value then updates the text field in the sharepoint list (Sales Rep) and then when opening the form from a record, display the Sharepoint field value as the default selected item.

I'm unsure how to create a new Dropdown field and link this to the Original Sales Rep field.

Setting the DefaultSelectedItems to Parent.Default complains about wanting "Expected Table Value" as does the Default field. I've tried Thisitem.SalesRep but same issue.

I'm assuming that Parent.Default relates to the Field on the form?

What am I doing wrong?

Thanks in Advance

Stu

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@StuCrooks

Don't overcomplicate it!! The form will do this for you automatically!

If you have already unlocked your Sales Rep field then you need to remove it from your form and add it back. Then before unlocking it, change the Control Type in the field edit list to "Allowed Values".

This will automatically add the dropdown and connect all the properties of the datacard to the control as needed.

It will also add a new property to the DataCard called AllowedValues. In that property you will provide a table of the Values you want to have in the dropdown. It needs to have a Value column.

So, for example, if your list of names in in a list called "Reps" and the Title column contains the Value you want to display and use, then your AllowedValues property would simply be:

RenameColumns(Reps, "Title", "Value")

That is it...the rest is done for you!

I hope this is helpful for you.

Was this reply helpful? Yes No
StuCrooks 26 on at

Like (0)

Report
Copy link

Link copied!

Thanks @RandyHayes. That's much easier.
I partially have it. The field now displays as a dropdown and the Selectable data is the Sales staff collection... but the actual Parent.Default value doesn't show in the field when the form is first opened.

Any ideas?

Was this reply helpful? Yes No
StuCrooks 26 on at

Like (1)

Report
Copy link

Link copied!

Cracked it.. Background field data had a space in the value, therefore it wasn't matching the Collection and couldn't therefore be displayed.

Thanks so much for your time and amazingly quick response @RandyHayes. I learnt something today already! Going to be a great day.
Thanks
Stu

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@StuCrooks

Excellent! Happy to help!

Was this reply helpful? Yes No