Multi-lookup fields not showing in PowerApps Modern Table

(0) Share

Report

Posted on by oyepanky

202

Hi Team,

I have a table named Table1_1 in PowerApps. It has 5 columns:

Service date – Date & Time
Amount – Number
Item – Lookup (Multi-Select)
Products – Lookup (Multi-Select)

Table Item Formula -

Sort(Filter(roservices, 'Mobile Number'.Value = Gallery3_1.Selected.'Mobile Number'.Value),ID,SortOrder.Descending)

The problem is that the Item and Products columns are not showing any data inside the table control in PowerApps. The other columns (Service date and Amount) display correctly, but lookup fields with multiple items remain blank. I tried different approaches but could not resolve this. Can anyone guide me on how to display multi-lookup (multi-select) values properly in a PowerApps table?

Thanks in advance.
Pankaj Jangid

I have the same question (0)

All responses (4)

Answers (1)

oyepanky 202 on at

Like (0)

Report

Multi-lookup fields not showing in PowerApps Modern Table

Thank you so much @WarrenBelz It's works

Was this reply helpful? Yes No
Verified answer

WarrenBelz 150,771 Most Valuable Professional on at

Like (1)

Report
Multi-lookup fields not showing in PowerApps Modern Table

Hi @oyepanky,

Same idea, but need a bit more code as Modern Tables field definition cannot be manipulated
With( { _Data: Sort( Filter( roservices, 'Mobile Number'.Value = Gallery3_1.Selected.'Mobile Number'.Value ), ID, SortOrder.Descending ) }, DropColumns( AddColumns( _Data, ItemV, Concat( Item, Value, ", " ), ProductsV, Concat( Products, Value, ", " ) ), Item, Products ) )

Your new columns will be ItemV and ProductsV in the example above.

Please ✅ Does this answer your question 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 answering Yes to Was this reply helpful?
Visit my blog Practical Power Apps LinkedIn

1 people found this reply helpful.

Was this reply helpful? Yes No
oyepanky 202 on at

Like (0)

Report

Multi-lookup fields not showing in PowerApps Modern Table

Hi @warrenBelz,

As I mentioned earlier, I’m using a Modern Table, not a gallery. I already tried this formula, but it doesn’t work in the Modern Table.

Please see the screenshot of the table below.

Was this reply helpful? Yes No
Suggested answer

WarrenBelz 150,771 Most Valuable Professional on at

Like (1)

Report
Multi-lookup fields not showing in PowerApps Modern Table

Hi @oyepanky,

To display multi-value fields in a Text Label in the Gallery (examples seperated by commas)
Concat( ThisItem.Item, Value, ", " ) Concat( ThisItem.Products, Value, ", " )

Please ✅ Does this answer your question 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 answering Yes to Was this reply helpful?
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No