Hi @mysteph,
Could you please tell what is the specific error of my solution, does the previous issue stay?
It would be appreciated if you could provide a screenshot how my solution operate on your side.
I just give a sample because I do not know your data type, so I assume that the column you fill in the dropdown is a Text type rather than a Choice type. If this is the point, please try to modify the formula as below:
Item property of the Form as below.
If(
Form2.DisplayMode = Edit,
StatusGallery.Selected,
If(
Form2.DisplayMode = View,
First(
Filter(
'Issue',)
Status.Value=FormStatusDropDown.Selected.Value,Email= User().Email
)
)
)
)
FormStatusDropDown OnChangeproperty:
If(
FormStatusDropDown.Selected.Result = "Open",
EditForm(Form2),
If(
FormStatusDropDown.Selected.Value= "Closed",
ViewForm(Form2)
)
)
Note that what scenario my solution works for. Once the FormStatusDropDown selected Open, StatusGallery will display all the related open records, and the form will be in edit mode and display the first record from your gallery. Once the FormStatusDropDown selected Closed, StatusGallery displays all the related Closed records, and the form will be in view mode and display the first record from your gallery.
Regards,
Qi