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!
We are excited to announce that Demo Extravaganza for 2021 has started!
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks