Hello all,
I am trying to make a Concatenate() function work, but it doesn't seem to want to...
Basically, I have two databases. One with Orders, and one with Articles (within these orders).
Database Orders
| ID | Order Number | Seller | Buyer |
| 1 | 967HG | Bob G. | Jim P. |
| 2 | 8455KJ | Hanna C. | Tom P. |
| 3 | 847TY | Bob G. | Ella V. |
Database Items
| ID | Order ID (Title) | Article Number | Price |
| 1 | 1 | 3947GBD-99 | €65,- |
| 2 | 1 | 3947GBD-99 | €65,- |
| 3 | 1 | 34879UI-723 | €75,- |
These tables are connected in that the Title of Database Items is the ID number of the relevant order in the Database Orders.
Now, within the app there is a gallery with an overview of the Database Orders. However, for Sellers, it's very convenient to immediately see from within this view what Article Numbers are connected to the Orders. For this I want a text label that uses a Concatenate function:
Concatenate(
Filter('Database Items', Text(Title) = Text(ThisItem.ID)).'Article Number',
", "
)
Now, I have tested the Filter() function in this on a separate gallery, and it seems to work. However, for the rest of the function, it doesn't. It's expecting a 'Text'.
Does anyone know how to tackle this issue? Later on a would also like to add a Distinct() function to weed out duplicate Article Numbers, but I need to first get this to work.
