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

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
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (2,385)