cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MrYYxx
New Member

Show Sharepoint column value in a label

Hi all,

I have a SP list with 10 items.
For Each item I want  to show a specific column as a label in a Power App but I don´t know how to setup the label text property.

I want to do the assigment throug ID column and displayed should be the title column.
Is this even possible?

1 ACCEPTED SOLUTION

Accepted Solutions

Hi,
thanks for your reply.
I´ve already found a solution with the Powerapps Lookup function. With this I can assign one specific SharePoint item to a specific label in Powerapps.

View solution in original post

4 REPLIES 4
Drrickryp
Super User
Super User

Hi @MrYYxx 

Put a datatable on the screen and set its Items property to Filter(yourSPlist,ID=0).  Remove the columns you don't want, adjust the order of the fields and the width to match your gallery.  

YoYo1982
Helper I
Helper I

@Drrickryp 
Thanks for your answer but a datatable will not work for me, I need a label because I need it inside a form.

If I put there your filter expression (Filter(yourSPlist,ID=0) it did not work.

Hi @MrYYxx,

Could you please share a bit more about your scenario, you could draw a picture to express your need.

You need a Label inside your form, what do you mean, you could add controls corresponding to each field, why would you like to insert a Label?

I thought that you want to display all the records in a Gallery and it seems to solve your problem.

1). You could set the Items property of a Gallery as your SP list

2). Sort the Gallery by the ID column, set the Items as below:

Sort(SPList,ID,Ascending)

3). Inset a Label and set the Text property as below:

ThisItem.Field

If the above is not what you want, please provide more details.

Regards,

Qi

Best Regards,
Qi

Hi,
thanks for your reply.
I´ve already found a solution with the Powerapps Lookup function. With this I can assign one specific SharePoint item to a specific label in Powerapps.

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

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