Hi there,
I have a SharePoint list with two columns, see below:
One is Name and the other is Number. Now the "Name" column corresponds to the User().FullName that can be made in PowerApps with the Office365 connection.
What i would like to achieve is to say, If the Users name is put in I would like to display the corresponding number on the list in another textfield(Input of Label) 🙂
Anyone who knows or can think of a clever idea to do this? I am a bit stumped myself 🙂
Thanks in advance.
- Tobi
Solved! Go to Solution.
Nevermind,
Found the solution myself after mocking around for a bit, using the LookUp function.
So the solution is:
LookUp(MedarbejderNr;Navn1 = User().FullName;'2)Nr')
One thing to note here is that there can be an issue with larger data sets as it loads the data outside the app, however in my case it is a dataset of "only" about a hundred occurences 🙂
Hope this may help whoever will need it 🙂
- Tobi
Nevermind,
Found the solution myself after mocking around for a bit, using the LookUp function.
So the solution is:
LookUp(MedarbejderNr;Navn1 = User().FullName;'2)Nr')
One thing to note here is that there can be an issue with larger data sets as it loads the data outside the app, however in my case it is a dataset of "only" about a hundred occurences 🙂
Hope this may help whoever will need it 🙂
- Tobi
User | Count |
---|---|
227 | |
101 | |
93 | |
56 | |
30 |
User | Count |
---|---|
288 | |
116 | |
109 | |
62 | |
58 |