error options appear invisible in a drop down menu gallery

[Brandini]

Im creating a new app for my company, its about projects, i have this

on the underside there is a gallery to change the information you recently saved, the problem is in the "Issue Related To" drop down menu, when you drop it down none of the options appear, it should appear the same options as in the drop down menu above with the same name, for the drop down menu above I have
Distinct(ProcessModelingAuditChecklist, IssueRelatedTo)

( ProcessModelingAuditChecklist is the List on the SharePoint and IssueRelatedTo is the column )
and that works fine, then I put it the same in the drop down menu below but it doesn't work there.

This way it appears above, in the drop down menu of the gallery the options appear empty, besides that I need that the options are seen, I need that it is updated in the sharepoint list where the information is stored, the name of that list is:
(Observations_ProcessModelingAudits)

[v-mengmli-msft]

Hi @Brandini ,

Do you want to display value of issue related to in SP list in drop down which inside gallery?

I assume that the IssueRelatedTo column is text type in two list and the items of gallery is Observations_ProcessModelingAudits. When user click the submit button the data in form will be stored in Observations_ProcessModelingAudits.

Please try this:

Items of dropdown:Distinct(ProcessModelingAuditChecklist, IssueRelatedTo)
Default of dropdown:ThisItem.IssueRelatedToColumnNameInObservations_ProcessModelingAudits

Best regards,

Rimmon

[Brandini]

Hi Man, Thanks for you help!!

But I still have problems, either the formula doesn't work or I have to change the names in the code, could

you tell me what to do? I'm new to power apps, it's my first project jeje.

(Upgrade jaja)

Now I can see the options in the drop down gallery of Issue Related To, But when I save information in the Observations_ProcessModelingAudits list and i want to change the issue related by the drop down, I use de Drop down, then I save the changes by the bottom "Save Changes" lower right corner, but it doesn't work, the information not change in the list for some reason that I dont know ;(

I share with you the list of my SH here below:

[v-mengmli-msft · Accepted solution]

Hi,

Since I did not know the column name in your list, I replace it with other in my code, it may have caused some misunderstanding for you.

Please try this:

1)Items of drop down:

Distinct(ProcessModelingAuditChecklist, IssueRelatedTo)

2)Default of drop down:

ThisItem.IssueRelatedTo

3)OnSelect of submit button:

ForAll(GalleryName.AllItems As C,Patch(Observations_ProcessModelingAudits,LookUp(Observations_ProcessModelingAudits,ID=C.ID),{IssueRelatedTo:C.DropDownName.Selected.Value}))

If my answer solves your question, please accept it as a solution.

If you have another question, you can post it in community to get instant solutions.

Thanks!😀

Rimmon