Show data from additional fields from a lookup column to the custom layout header
Hi,
I wanted to show data from additional fields from a lookup column to the custom layout header.
Example:
List 1:
Submit Round (text),
Deadline Date (date),
Result Date (date)
List 2:
Project (text),
Submit Round (lookup),
Deadline Date (additional fields from lookup),
Result Date (additional fields from lookup)
So, I want to configure the header format to show the Deadline Date and Result Date in the Header when the user selects a Submit Round.
Is it possible to achieve this by only custom the header of the Sharepoint list (I’m trying to avoid PowerApps)
Additional challenge: I want to create a new column by combining a lookup column with a Date column by creating a Calculated column but I got an error state the columns are defined as a data type that is not supported in formulas. is there a workaround?
I feel like it is the same problem that may have a similar solution to it.
Thank you.
Hi, I wanted to show data from additional fields from a lookup column to the custom layout header.Example:List 1:Submit Round (text),Deadline Date (date),Result Date (date) List 2:Project (text),Submit Round (lookup),Deadline Date (additional fields from lookup),Result Date (additional fields from lookup) So, I want to configure the header format to show the Deadline Date and Result Date in the Header when the user selects a Submit Round. Is it possible to achieve this by only custom the header of the Sharepoint list (I’m trying to avoid PowerApps) Additional challenge: I want to create a new column by combining a lookup column with a Date column by creating a Calculated column but I got an error state the columns are defined as a data type that is not supported in formulas. is there a workaround? I feel like it is the same problem that may have a similar solution to it. Thank you. Read More