I think you need to transform the stored data in your multi-line text field into a usable table format in Power Apps. This can be done by parsing the raw text, splitting it into rows, and then further splitting each row into columns.
Please find below my solution:
1. I created a multi-line text field in a SharePoint Online list. Field name is TestMLOT (item ID is 9), as shown below.
2. In Power Apps, I added a button and set some variable and finally created a Collection (ParsedData)
OnSelect property of Button:
Set(RawData,LookUp('App Sharing',ID=9).TestMLOT);
Set(RowCollection,Split(Text(RawData),Char(10)));
Set(SingleRow, First(RowCollection).Value);
Set(SplitResult, Split(SingleRow, ","));
Set(PatchStatus, Trim(First(SplitResult).Value));
Set(MachineName, Trim(Last(SplitResult).Value));
ClearCollect(
ParsedData,
ForAll(
RowCollection,
{
PatchStatus: If(
Trim(First(Split(Value, ",")).Value) = "true",
true,
false
),
MachineName: Trim(Last(Split(Value, ",")).Value)
}
)
);
Split function to create a collection of rows based on line breaks.
I splitted each row into two parts (PatchStatus and MachineName).
3. This collection (ParsedData)I used in Items property of the Gallery. Added a checkbox in the gallery and set its Default property to ThisItem.PatchStatus.
Summary:
1. Step 1: Split the raw data into individual rows (RowCollection)
2. Step 2: Split each row into two parts (PatchStatus and MachineName).
3. Step 3: Trim the parts and map them to PatchStatus and MachineName
-------------------------------------------------------------------------------------------------
If this reply helped you, please mark this reply as suggested answer ✔️ and give it a like 👍to help others in the community find the answer too!
Thanks,
Vipul