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!
Solved! Go to Solution.
@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:
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:
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"
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.
@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:
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
191 | |
67 | |
46 | |
42 | |
20 |
User | Count |
---|---|
247 | |
120 | |
83 | |
75 | |
69 |