cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Dorp down Sharepoint list in Power Aoo

Hello,

 

I have a question. I create a Time Sheet app form Sharepoint list to power app. But in this time sheet i made a drop down.

So  i have to sharepoint list:

 

1: Time Sheet;

2: Create project.

 

The Time sheet list is linked to the create project, in this way the project all have the name and people only the need to select.

 

But in power app time sheet, this drop down doesnt work instead of giving the correct project names it only gives:

item 1;

item 2;

item 3;

etc.

 

Does anyone knows how to fix this?

 

Thank you!

Bob

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User III
Super User III

Re: Dorp down Sharepoint list in Power Aoo

Please  I asked for the formula / Screenshot on the ITEMS property of the Dropdown in powerapps.

Meanwhile if it a choices column try:

Choices('Project aanmaken'.ProjectCode)

 

Dropdowni.PNG

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

View solution in original post

9 REPLIES 9
Highlighted
Super User III
Super User III

Re: Dorp down Sharepoint list in Power Aoo

In the Item property of the dropdown put:

CreateProjectList.ProjectColumn

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Highlighted
Helper I
Helper I

Re: Dorp down Sharepoint list in Power Aoo

Hello,

Thank you for you quick replay.

 

I dont really understand what you're saying. 

In sharepoint it works very well i when to choose informatie form different colomn. Than i created the power app and i get this.
maybe the pictures help us.

Example power app item.PNG

 

Where exactly.PNG

Highlighted
Super User III
Super User III

Re: Dorp down Sharepoint list in Power Aoo

Take a screenshot of the Items Property of the Combobox or the dropdown.

Apart from the What is the Name of the Sharepointlist and the ColumnName you want to show?

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Highlighted
Helper I
Helper I

Re: Dorp down Sharepoint list in Power Aoo

sharepoint connection.PNGSharepoint list.PNG

 

I dont want to show anything more than the dropdown options i also have in the sharepoint above.

1 on 1.

 

Maybe later with a filter to only show the open projects and not the closed one anymore, but first thing first 🙂

Highlighted
Super User III
Super User III

Re: Dorp down Sharepoint list in Power Aoo

Please  I asked for the formula / Screenshot on the ITEMS property of the Dropdown in powerapps.

Meanwhile if it a choices column try:

Choices('Project aanmaken'.ProjectCode)

 

Dropdowni.PNG

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

View solution in original post

Highlighted
Helper I
Helper I

Re: Dorp down Sharepoint list in Power Aoo

formulabar.PNG

 

Sorry, iam a very new user of power apps.

 

Here it looks good but in de realtime app not.

Thanks for your help.

Highlighted
Super User III
Super User III

Re: Dorp down Sharepoint list in Power Aoo

What is the issue with the realtime App?

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Highlighted
Helper I
Helper I

Re: Dorp down Sharepoint list in Power Aoo

Here in this example if i work "programme" the app it gives the good names also when i do a preview.

 

But in de the real app it only give item 1, 2, 3, etc.

 

 

Highlighted
Helper I
Helper I

Re: Dorp down Sharepoint list in Power Aoo

Thank you a lot for your patience and help!

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Watch Now

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (5,753)