I have a people column with multiple entries allowed in a sharepoint list called as L3 Leaders. I want to display the value that is entered in the sharepoint list in power apps. I was using this formula - First('sharepointlist').'L3 Leader'.DisplayName. It was working fine when the people column was single entry. As soon as i changed it to multiple entry it is not working. Please let me know how to resolve this.
Solved! Go to Solution.
Hi @Anonymous ,
When changing the column from single select to multiselect, the column will return a table, rather than a record. This will break you app as the controls aren't expecting this.
Try replacing your code with:
Concat(First('sharepointlist).'L3 Leader',DisplayName,", ")
Hi @Anonymous ,
When changing the column from single select to multiselect, the column will return a table, rather than a record. This will break you app as the controls aren't expecting this.
Try replacing your code with:
Concat(First('sharepointlist).'L3 Leader',DisplayName,", ")
Thank you very much! Worked like a charm
User | Count |
---|---|
260 | |
110 | |
97 | |
53 | |
39 |