Matching IDs in two lists - code syntax problem

[matteoseni]

Goodmorning everyone,

first of all I would like to explain my problem, taking into account the fact that I am a beginner with databases and this platform:

I'll start by explaining which are the lists in Sharepoint that are used as a database for the App in PowerApps.

• there is a "Customers database" list containing all the names of the customers, with their main information.
• there is a "Key Contacts" list in which all the contacts relating to a specific customer are present
• and so on...

the main problem is that by creating the lists, each Costumers (in the Costumers database) will have an ID, and within the Key Contacts, each Contact will have another ID ...

however a customer can have multiple contacts, so I thought of putting a secondary ID in the Key Contacts list, the problem is that it should be updated manually every time, making the costumer ID (Costumers Database) equal to the new secondary ID in the Key Contact, but doing so would be inconvenient ... I wanted to ask you: is there an automatic way to correlate the IDs in the two lists?

Trying to work around this problem, I thought of inserting a formula, in which I match not the IDs, but the names… to bypass the problem, but it gives me this error (maybe I have wrong the syntax):

App screen:

List in SharePoint:

I wanted to ask you for a hand in this regard, both for the first case, and (possibly if not possible), for the second.

Thank you!

Matteo.

[JR-BejeweledOne]

Try this instead,

Filter('Key Contacts'; Company_x0020_name in GalleryCustomer.Selected.'{Name}')

[matteoseni]

Thank a lot for the reply! But unfortunately it doesn't work.. as below:

And the field name in the Customers Screen (app screen referenced by the selected item), is correct, as below: ( {Name} )

Thank you very much if you can help me!

[JR-BejeweledOne]

Where is Company_x0020_name coming from?  Is it a field that someone has selected or something else?

Also can you translate your error for me?

[matteoseni]

Company_x0020_name is the field name of the "Key Contacts" list in SharePoint.

and this field is the same as the name shown in "{Name}" in the screenshot I attached above (Gallery Costumer).

Precisely I would like that when the {Name} selected in the Costumer Gallery, is found in the "Company Name" column in Key Contacts, it gives me back the Company_x0020_name, that is the Company Name.

(it is only an explanatory example, to project a result, taking into account the same name).

the error simply says that the formula contains an error, and to examine the formula and run it again.

Thank you!

[JR-BejeweledOne]

Instead of this:

Filter('Key Contacts'; Company_x0020_name in GalleryCustomer.Selected.'{Name}')

Can you try this:

Filter('Key Contacts'; Company_x0020_name in GalleryCustomer.Selected.Name)

[matteoseni]

"the name is invalid. unrecognized identifier".

I think he expects an ID, but unfortunately as I anticipated, it is not possible for me to equate them between the lists

[JR-BejeweledOne]

Ok, I have never seen that require {} around the identifier.

If you remove the Name at the end of the formula, do you get a dropdown with selections?   Is Name one of the selections?

[matteoseni]

Yes:

Or, would there be a different way to do what I need? exactly display all the lines of the Key Contacts list, whose "Company Name" field is the same as the one selected in the Costumers Screen?

Thank you

[JR-BejeweledOne]

Please excuse all the questions, different language versions of Power Apps work a little differently.

Can you try Filter('Key Contacts'; 'Company Name' in GalleryCustomer.Selected.'{Name}')