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

Display Sharepoint list field value to text label

I want to set label text property with sharepoint list field value.So,I filtered the item with current user.In that item i need specific field value to display it on the text label field.How to achieve this?

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Community Champion
Community Champion

Re: Display Sharepoint list field value to text label

Please can you show the formula used in filtering. What is the name of the column you want to put in the textbox.

If you like this post give thumps up.

View solution in original post

Highlighted
Resolver III
Resolver III

Re: Display Sharepoint list field value to text label

Hi @Sreenu ,

 

The problem you have is that a label is from 1 single record, using filter the system expects a table.

I would recommend using a LookUp but not with the display name because that is not a unique value ( there can be 2 John Smith's).

You could use : 

LookUp(EmployeeLeaveInfo,EmpName.Email=User().Email).TotalCreditedLeaves

 

Keep in mind that I don't know the structure of your data.

 

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

View solution in original post

3 REPLIES 3
Highlighted
Community Champion
Community Champion

Re: Display Sharepoint list field value to text label

Please can you show the formula used in filtering. What is the name of the column you want to put in the textbox.

If you like this post give thumps up.

View solution in original post

Highlighted
New Member

Re: Display Sharepoint list field value to text label

This is the formula i used.

Formula: Label4.Text=Filter(EmployeeLeaveInfo,EmpName.DisplayName=User().FullName).TotalCreditedLeaves.

Trying to display total credited leaves of particular employee in label.

Highlighted
Resolver III
Resolver III

Re: Display Sharepoint list field value to text label

Hi @Sreenu ,

 

The problem you have is that a label is from 1 single record, using filter the system expects a table.

I would recommend using a LookUp but not with the display name because that is not a unique value ( there can be 2 John Smith's).

You could use : 

LookUp(EmployeeLeaveInfo,EmpName.Email=User().Email).TotalCreditedLeaves

 

Keep in mind that I don't know the structure of your data.

 

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

View solution in original post

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (7,279)