Hi,
I´m working on an app to display data from a SharePoint List. I want to display details from items in a gallery, but not in a Display Form. I'm using labels and the gallery.Selected.field Text Property to display the details, but I'm having trouble with data from choice fields in sharepoint. Is there a way to display choice, lookup and calculated sharepoint fields on labels in powerapps?
Thanx!
Solved! Go to Solution.
Hi @AFernandez
For choice fields, lookup fields - use gallery.selected.column.Value - to get the text
for person - use gallery.selected.column.Email or gallery.selected.column.DisplayName
Regards,
Reza Dorrani
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @AFernandez,
Since the Label control is used to display text, while choice, lookup and calculated field are complex data type.
So you need some special formulas to make them diaplay in label control.
1)single choice, single lookup
Gallery1.Selected.fieldname.Value
2)multiple choice, multiple lookup
Concat(Gallery1.Selected.fieldname,Value&",")
3)calculated sharepoint field
I've try these settings all.
Just using this formula is OK:
Gallery1.Selected.fieldname
Here's a doc about how to use complex data type of sharepoint list in PowerApps for your reference:
https://powerapps.microsoft.com/en-us/blog/default-values-for-complex-sharepoint-types/
Hi @AFernandez
For choice fields, lookup fields - use gallery.selected.column.Value - to get the text
for person - use gallery.selected.column.Email or gallery.selected.column.DisplayName
Regards,
Reza Dorrani
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @AFernandez,
Since the Label control is used to display text, while choice, lookup and calculated field are complex data type.
So you need some special formulas to make them diaplay in label control.
1)single choice, single lookup
Gallery1.Selected.fieldname.Value
2)multiple choice, multiple lookup
Concat(Gallery1.Selected.fieldname,Value&",")
3)calculated sharepoint field
I've try these settings all.
Just using this formula is OK:
Gallery1.Selected.fieldname
Here's a doc about how to use complex data type of sharepoint list in PowerApps for your reference:
https://powerapps.microsoft.com/en-us/blog/default-values-for-complex-sharepoint-types/
Thank you very much for the help!
Thank you very much!
User | Count |
---|---|
225 | |
101 | |
93 | |
56 | |
30 |
User | Count |
---|---|
288 | |
116 | |
109 | |
62 | |
58 |