Hello,
I have this database, the 'Welder ID' has a choice column type
I want to grab data from 'Welder ID' based on 'Joint No' which has the same value. This is my apps:
I write this formula in my ComboBox (Welder ID), items properties:
ForAll('WELDER REPORT'.'Welder ID', Filter('WELDER REPORT', 'Joint No' = DataCardValue19.Text))
For example, if Joint No has the value "2", so my ComboBox can grab "A.21" and "K.21".
But it can't work, can anyone help me to fix it? Thank you in advance.
HI @firda59 ,
Assuming you want this as a Text output - this should put commas between them
With(
{
wData:
Filter(
WELDER REPORT',
'Joint No' = DataCardValue19.Text
)
},
Concat(
wData,
'Welder ID',
","
)
)
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
MVP (Business Applications) Visit my blog Practical Power Apps
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.