
Hello all,
I am currently trying to populate the text inside of a datacardvalue with a column value from a SharePoint list. Here is an image of my formula which is being placed in the "Default" property:
What the Filter part of this is saying is, it is going to look at the CurrentRoster SharePoint list, find the employee name that is equal to the employee name selected in the AuthorComboBox, and then return me that person's Current Supervisor. I think the issue arises from using the Filter() function. Any help on how I can get this to work so that this is autopopulated with the Current Supervisor when a selection is made in AuthorComboBox?
Thanks!
Hi @Anonymous ,
The issue is indeed because you are using a Filter. This returns a table which the control can't handle. Replacing it with a LookUp function may fix that issue. However this will only return the first hit against the condition (EEName = AuthorComboBox.Selected.EEName), so if the same value for EEName appears multiple times in the CurrentRoster data source, this will not give the desired result.