I am new to this and have not been able to get my app to work by going through the existing posts on this topic - any help is appreciated!
I have added a SharePoint list as a data source in my app:
List Name: 'Recognition Program'
Column Name: 'Person Nominated'
Column Name: 'Points Approved'
I want to display the total number of points approved for the person who is using the app. I am keeping track of all the nominations and points in this single SharePoint list, so I am trying to filter the list to only look at the entries where the person nominated = the user and then sum the points approved column.
Here is the formula I am trying:
Sum(Filter('Recognition Program',Match(Office365Users.MyProfile().DisplayName,'Person Nominated'),'Points Approved'))
Solved! Go to Solution.
That removed the error, but I am still not getting a value displayed.
Here are the errors/warnings I am seeing now:
That removed the 'Sum' error, but still no value being displayed.
there we go @jmazzoni Sum(Filter('Recognition Program','Person Nominated'.DisplayName = User().FullName),Value('Points Approved'))
and if multiple selection is allowed Sum(Filter('Recognition Program', First('Person Nominated').DisplayName = User().FullName),Value('Points Approved'))
Check out new user group experience and if you are a leader please create your group
Check out how to claim yours today!
Test your skills now with the Cloud Skill Challenge.
We are excited to announce that Demo Extravaganza for 2021 has started!