cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bheijligers
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

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
eka24
Super User
Super User

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.

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

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.

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 🙂

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.

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.

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.

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.

 

 

Thank you a lot for your patience and help!

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PWREduCon768x460.png

Join us at PWR EduCon - A Power Platform Conference

Learn from the top Power BI, Power Apps, Power Automate & Power Virtual Agents experts!

Top Solution Authors
Top Kudoed Authors
Users online (3,125)