cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

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
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

View solution in original post

5 REPLIES 5
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

Frequent Visitor

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

View solution in original post

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
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (33,462)