Hi,
I currently have a form control that connects to my main SharePoint list. I have another list that contains historical updates of a field in the main list.
I wanted to add a label inside the form control that looks at my historical update list and shows the latest update that was done based on the Title field of the main list. would this be possible? I wanted to show who last entered a data on that field by reading my historical list.
sure @powerdevkris ,
You can use lookup function to get the desired information from a list by passing filter value. You have to assign the value to the label control text property.
LookUp(
'Historical Updates',
Title = ThisItem.Title
).ColumnToDisplay
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.