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
Solved! Go to Solution.
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.
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
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.
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
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
User | Count |
---|---|
196 | |
126 | |
87 | |
49 | |
42 |
User | Count |
---|---|
284 | |
162 | |
138 | |
75 | |
72 |