web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / PowerApps Sharepoint F...
Power Apps
Answered

PowerApps Sharepoint Form to Read List from ProjectOnline and Add Item to SharePoint List

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

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?

Categories:
I have the same question (0)
  • Drrickryp Profile Picture
    Super User 2024 Season 1 on at

    You need a project name field in Your SharePoint list. The Update property of the datacard should be Dropdown1.Selected.Value

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    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.

  • Verified answer
    Community Power Platform Member Profile Picture
    Microsoft Employee on at

    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.

Helpful resources

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Valantis Profile Picture

Valantis 494

#2
WarrenBelz Profile Picture

WarrenBelz 352 Most Valuable Professional

#3
11manish Profile Picture

11manish 323

Last 30 days Overall leaderboard