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

How to make Datafields "manuel" without a datatable?

Hi

 

how can i show only one Datafield from a sharepoint list in my Power APP without using a Datatable?

 

my APP is connected to a sharepoint list, but i can not "make" fields manuell to show the information of the list. only with a datatable. is it possible to make a field like "mysharpointlist;name_of_the_field" to show whats inside?

 

maybe:  Username: Name of the user

              Department: Name of the department

 

with a datatable it works but not with datafields...?

 

thanks

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
eka24
Super User III
Super User III

Use a Gallery. On the Items put the name of the table.

Then inside the Gallery, if you need only one field, delete all the Labels and leave one.

In the text of that label put the column if your choice;

ThisItem.Department

 

If you want another

ThisItem.OtherColumn

 

You can also arrange the labels inside the Gallery to look like a Table.

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

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

Hi@AndyPBC,

Could you please share a bit more about your app's configuration?

Further, could you please share more details about your SP list?

I have a test on my side, please take a try as below.

Set the Items property of the Gallery control to the following formula:

 

Filter(SPlist,Author.Email=User().Email)

 

In addition, you could also take a try with the following workaround:

Set OnVisible property of the first screen of your app to the following formula:

 

UpdateContext({CurrentUser:User().Email})

 

Set Items property of the Gallery control to the following formula:

 

Filter(SPlist,Author.Email=CurrentUser)

 

Best Regards,

Qi

Best Regards,
Qi

View solution in original post

5 REPLIES 5
eka24
Super User III
Super User III

Use a Gallery. On the Items put the name of the table.

Then inside the Gallery, if you need only one field, delete all the Labels and leave one.

In the text of that label put the column if your choice;

ThisItem.Department

 

If you want another

ThisItem.OtherColumn

 

You can also arrange the labels inside the Gallery to look like a Table.

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

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

okay, that works. 🙂

 

And is it possible to filter the gallery? 

 

show me only entries of the current user, for example?

 

Thanks

Hi@AndyPBC,

Could you please share a bit more about your app's configuration?

Further, could you please share more details about your SP list?

I have a test on my side, please take a try as below.

Set the Items property of the Gallery control to the following formula:

 

Filter(SPlist,Author.Email=User().Email)

 

In addition, you could also take a try with the following workaround:

Set OnVisible property of the first screen of your app to the following formula:

 

UpdateContext({CurrentUser:User().Email})

 

Set Items property of the Gallery control to the following formula:

 

Filter(SPlist,Author.Email=CurrentUser)

 

Best Regards,

Qi

Best Regards,
Qi

View solution in original post

eka24
Super User III
Super User III

Use the structure below on the Items property of the Gallery:

Filter(Datasource, UserColumn=User(). FullName)

 

Or

Filter(Datasource, Emailcolumn=User().Email)

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

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.

well, it is only a simple sharepoint list to manage the holidays of the users.

Begin, Ending, Username, Department, Date of create, thats all.

 

in this APP the current User have an overview of his holidays <- that works fine with a datatable

on the second screen the User would be see all the holidays of the users in his (same) department

 

the problem that i have is an the second screen, because i wanted  2 field (one for current username, (user().fullname) and the second field with the department (i dont know, which formula that is) of the current user. 

 

the datatable shows then all holidays form the users with the same department from the current user.

 

thanks

 

Andy

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

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

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.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (1,131)