Update DataTable inside DataCard to Sharepoint List

(0) Share

Report

Posted on by praeclarus

I am displaying data in a Data Table, and this Data Table is inside a Data Card.

Is it possible to update multiple rows in the Data Table into Column A with a bullet point?

If so, how should the code be written?

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

VASANTH KUMAR BALMADI 266 on at

Like (1)

Report
Yes, you can update multiple rows in a Data Table's column (e.g., "ColumnA") by concatenating values with bullet points. However, since a Data Table in PowerApps is read-only when inside a Data Card (like in a form), you need a workaround to modify the data before displaying it.

Solution: Using a Collection for Displaying Data with Bullet Points

Load Data into a Collection

If your Data Table is showing data from a Dataverse table (or another source), store the data in a collection first:

ClearCollect(colData, YourDataSource)

Modify ColumnA by Concatenating Multiple Rows

To display "ColumnA" with bullet points, create a new collection with formatted text:

ClearCollect( colUpdatedData, AddColumns(colData, "UpdatedColumnA", "• " & ColumnA) )

Bind the Updated Collection to the Data Table

Set Items of the Data Table to colUpdatedData

Change the displayed column in the Data Table to "UpdatedColumnA"

Alternative: If Using a Gallery Instead of a Data Table

If a Data Table inside a Data Card doesn't support modifications, you can use a Gallery instead:

Set Items of the Gallery to:
ForAll(colData, "• " & ColumnA)

Use a Label inside the Gallery to display the formatted text.

Was this reply helpful? Yes No
praeclarus 34 on at

Like (0)

Report

VASANTH KUMAR BALMADI Thank you for your kindness but another question.

If i woud like to update multiple rows from data table in sharepoint list, how can i do that?

Was this reply helpful? Yes No