Hi @JillH ,
Is pic1 a display form, pic2 an edit form?
Do you mean that the display form could not display right data, while the edit form could?
Could you tell me the data type of Project_x0020_Type column and Title column?
Did you customize the edit form to make drop downs to choose the value of Project_x0020_Type column and Title column instead of using textinputs?
I assume that both of them is text type and you make customization like what I said.
Actually, you do not need to set the display form like what you said.
You just need to customize the edit form, the display form retaining the default settings is ok.
Usually, we set display form like this:
1)set the form's data source:
BI_Project_Types
2)set the form's Item: the item that you want to edit (for example: Gallery1.Selected)
As the Project_x0020_Type column and Title column, you do not need to make any customization. Just using the default labels is enough.
The labels' settings should be like this:
1)Project_x0020_Type column
datacard's Default:
ThisItem.Project_x0020_Type
//question: what is the relationship between Project_x0020_Type column and 'Project Type Output' column?
label's Text:
Parent.Default
2)Title column
datacard's Default:
ThisItem.Title
label's Text:
Parent.Default
Then in the edit form, you could make customization on these two columns.
For example:
Delete labels in these two datacards, insert two drop downs.
1)Title column:
datacard's Update:
RoleDropDown.Selected.Result
drop down's Items:
Distinct(BI_Project_Types,Title)
drop down's Default:
ThisItem.Title
2)Project_x0020_Type column:
datacard's Update:
TypeDropDown2.Selected.Result
drop down's Items:
Distinct(Filter(BI_Project_Types,Title=RoleDropDown.Selected.Result),Project_x0020_Type)
//please notice that use "RoleDropDown.Selected.Result" represent the selection of title drop down, since you use Distinct function as its Items.
drop down's Default:
ThisItem.Project_x0020_Type
Best regards,
