Power Platform Community Forum Thread Details

Dear PowerApp users,
I have found much help in this forum but now struggling with a hard nut to crack and not sure if it is the best way to follow.

1. PowerApp send/patch a collection(coll_Items) in JSON format to PowerAutomateFlow. The collection has fixed columns numbers/names but various number of rows. I trigger Flow like below:

PowerAutomateFlow_wrajer.Run(
varUserEmail,
varUserName,
JSON(coll_Items),
);

2. PowerAutomate Flow Parse JSON properly. I use "Apply to each" to create HTML table, create a confirmation Email with items list etc.

[ {
 "Dostawca": "asd",
 "FV": "123",
 "Kategoria": "Inne",
 "Nazwa": "aparat fotograficzny",
 "Nr": 6,
 "TempIlosc": 1,
 "Title": "6 aparat fotograficzny Inne",
 "Uwagi": "asdasd",
 "WarNetto": 123
 }]

Spoiler (Highlight to read)

3. I want to save each process/flow input information to SharePoint list that can be used back in PowerApps. My SP list has columns [ UserEmail, UserName, Date, JSON (Multi Line Text)] etc.]

SP record looks like (just text)

so using simple ClearCollect in PowerApps have following (Text) but want to have a Records Table like "Editor" Column. It will be only to view this record as a table (ex.Gallery)