Fluent UI Details List: Display Comma Delimited Values in a Field (Cell)

(0) Share

Report

Posted on by hnathan

Hello- Not much info out there yet but, I am trying to display multiple values in a Details List field.

First a little background into my project:

The data for the Details List is located in three SharePoint lists.

List 1: Accounts

List 2: Products

List 3: Bridge Table called AccountProducts (Columns include ID, Title, AccountID plus the default list columns)

Accounts can have more than one Product assigned to them.

The Details List is attached to a Collection called colAccounts. I added a Products column to colAccounts that filters the AccountProducts list by Account ID and returns only the Title column. This creates a Table Value in the Products column of colAccounts containing the names of the products associated with an Account.

Here are my column settings for the Products column...

{
ColName: "Products",
ColDisplayName: "Products",
ColWidth: 250,
ColResizable: true,
ColFirstMultiValueBold: true,
ColMultiValueDelimiter: ", "
}

All other columns of the colAccounts display as expected in the Details List. I also get the requisite number of delimiting commas appearing in the Product column. Just no data.

Any ideas? I feel like I'm sooo close...

Categories:

Building Power Apps

All responses (7)

Answers (0)

Sort by

narayan225 2,547 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@hnathan

Can you also include the formula that you are using to populate the products column when loading the data?

There could be something that might not be working from there.

Cheers!
hnathan 52 on at

Like
a
(0)

Report
Copy link

Link copied!
Here is my code in the Items property of the Details List. I have a Search Bar in play. I think this is what you are referring to...
SortByColumns(Filter(colAccounts, txt_ManageAccounts_Search.Text in Title), ctxSortCol, If(ctxSortAsc,'PowerCAT.FluentDetailsList.CurrentSortDirection'.Ascending, 'PowerCAT.FluentDetailsList.CurrentSortDirection'.Descending))
hnathan 52 on at

Like
a
(0)

Report
Copy link

Link copied!

I replied to the main post. Sorry!
hnathan 52 on at

Like
a
(0)

Report
Copy link

Link copied!

I can see the data correctly displayed in the Product column of the collection. It is a one-column table with Title as the header. Can't figure out how to get to it, though. It knows how many records based on the correct number of commas displayed...
narayan225 2,547 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@hnathan
As far as I understand your concern, you are trying to add a column to your collection to store product information, is that correct?
But after running the query, you are only getting commas and no product information. Is tha correct?

If that is the case, I was looking for the formula you are using to create a collection that includes product column with the relevant information.

Cheers!
hnathan 52 on at

Like
a
(0)

Report
Copy link

Link copied!
Here is the Products portion of the AddColumns function. As you can see I am only pulling in one column from the AccountProducts table...Title. Is this what you were looking for?
// Products code filters AccountProducts by AccountID and returns only the Title column
"Products",
Filter(
AccountProducts,
AccountID = colTempAccounts[@ID]
).Title,
Also, I start with a preliminary collection (colTempAccounts) that is just the Accounts Table. I then add columns to that. Like to keep my code as flat as possible while working through things.
hnathan 52 on at

Like
a
(0)

Report
Copy link

Link copied!

Reading your post once again...

@narayan225 wrote:
@hnathan
As far as I understand your concern, you are trying to add a column to your collection to store product information, is that correct? Actually, I am able to collect the Product data as I understand it needs to be presented to the Details List, a single column table. The values do not appear in the Details List, however.
But after running the query, you are only getting commas and no product information. Is tha correct? The commas are applied in the Details List per the Column_Items code in my original post.

If that is the case, I was looking for the formula you are using to create a collection that includes product column with the relevant information.

Cheers!