cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
KathyRowland
Frequent Visitor

SharePoint Custom Form - Update Fields Based on Drop Down Selection

I'm a newbie to PowerApps and sure would love some help with the following scenario! 

 

I have two SharePoint document libraries with some common fields.  I want to customize the form for the 'Resubmittals' library to include a dropdown to the 'Submittals' library.  When a choice is made from the dropdown, the other fields are set/filled based on the choice, where the selection in the dropdown is equal to the Title field in the Submittals library.

 

SharePoint Library – ‘Submittals’

Title – Single line of text

OrigPlanSetType – Single line of text

OrigPlanTerm – Single line of text

OrigProjectName – Single line of text

SharePoint Library – ‘Resubmittals’

Title – Single line of text

PlanSetType – Choice (dropdown)

PlanTerm – Choice (dropdown)

ProjectName – Single line of text

 

KathyRowland_3-1637697653258.png

I feel like this is probably pretty easy, but I can't figure it out.

Any help would be appreciated!

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
KathyRowland
Frequent Visitor

@WarrenBelz, thank you for your help!  I was able to get the desired results by setting the Items property for the Plan dropdown to the following:

 

KathyRowland_1-1638193709604.png

 

And by setting the OnChange property for the Plan dropdown to the following:

 

KathyRowland_2-1638193788856.png

 

 

View solution in original post

6 REPLIES 6
WarrenBelz
Super User
Super User

Hi @KathyRowland ,

The first one would be

Filter(
   Resubmittals,
   Title = PlanDropdonwName.Selected.Title
).PlanSetType

and just change the last bit for the other two.

 

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.

Visit my blog Practical Power Apps

Thank you, Warren, for your quick response!  Unfortunately, I receive the following error:

 

KathyRowland_0-1637701151034.png

 

@KathyRowland ,

That formula is for the Items, not the Default.

 

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.

Visit my blog Practical Power Apps

"We didn't find any data"

 

KathyRowland_0-1637705221238.png

 

Hi @KathyRowland ,

It won't unless something matching is in the first dropdown. The syntax is correct providing your field names and types are as posted.

KathyRowland
Frequent Visitor

@WarrenBelz, thank you for your help!  I was able to get the desired results by setting the Items property for the Plan dropdown to the following:

 

KathyRowland_1-1638193709604.png

 

And by setting the OnChange property for the Plan dropdown to the following:

 

KathyRowland_2-1638193788856.png

 

 

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (2,325)