Answered

SharePoint Custom Form - Update Fields Based on Drop Down Selection

(0) Share

Report

Posted on by KathyRowland

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

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

Any help would be appreciated!

Categories:

Building Power Apps

All responses (6)

Answers (1)

Sort by

WarrenBelz 156,748 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
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
KathyRowland 28 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you, Warren, for your quick response! Unfortunately, I receive the following error:
WarrenBelz 156,748 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@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
KathyRowland 28 on at

Like
a
(0)

Report
Copy link

Link copied!

"We didn't find any data"
WarrenBelz 156,748 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

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.
Verified answer

KathyRowland 28 on at

Like
a
(0)

Report
Copy link

Link copied!

@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:

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