Announcements
Hello,
I'm fairly new to PowerApps. I've created a PowerApps Sharepoint form to add items to a SP list. It is designed to collect information related to projects that are being managed in Project Pro and Project Online. The form updates the list properly if the project name is typed into a 'project name' field. But now I want to provide a dropdown selection list for 'project name' that gets pulled from Project Online. I connected to Project Online datasource and used 'ProjectOnline.ListProjects' to pull the list in and that works well. However, now when I use that list and field and create a new record for the SP list it won't save it and gives an error message that a necessary field is either empty or is invalid. I think I am close, so this problem is maddening. Can anyone help me understand how to fix this problem?
You need a project name field in Your SharePoint list. The Update property of the datacard should be Dropdown1.Selected.Value
Thanks for the quick reply. I had tried to use 'dropdown1.selected.value but it did not like that; gave me the red x. I tried it again based on your suggestion, ignoring the red x, but I got the same error message when trying to save. So instead I used what I thought was the most likely option from the options provided, which turned out to be 'dropdown1.Selected.Name. No error messages, but of course that is giving me the error when I try to save. I do have a field in SP list called Project Name. The field I am pulling from Project is just called Name.
The process I went through was to delete the datavalue element from the Project Name datacard and replace it with a dropdown control which takes the name dropdown1. This is how Shane Young's video suggested doing it, and seems consistent with your post that references dropdown1.
This turned out to be a fairly easy, if somewhat obscure, fix. Instead of using ***.selected.value it took ****.SelectedText.Value.
Thanks for your help.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Valantis 494
WarrenBelz 352 Most Valuable Professional
11manish 323