Answered

Exporting Collection to powerautomate

(0) Share

Report

Posted on by Zaid-Aboobaker

Hi Fam

I have 2 sharepoint lists. One master list of meeting decisions - DecisionGrid. The 2nd list - DecisionGridProgress has items/ feedback linked to DecisionGrid by the ID. I am viewing the grid through a gallery and am able to show the feedback items from DecisionGridfeedback in one text field using Concat and nesting the Progress gallery.

Nested Gallery item :

AddColumns(Filter(DecisionGridProgress;Text(ThisItem.ID)= DecisionID);
"Branch&Progress";Concatenate("<i>";"(";Text(ThisItem.Created;"dd-mmm-yyyy");")";"</i>"; Branch;" : ";DecisionProgress))

I can running a concat to join all fields into don't HTML text field as follows:

Concat(Galprog.AllItems;'Branch&Progress';"<br>")

Through an export button, I am creating a collection as follows:

ClearCollect(
colDecisionGridExport;GalViewDecisions.AllItems);;
PowerappsExportDecisionGridV2.Run(JSON(colDecisionGridExport;JSONFormat.IgnoreBinaryData & JSONFormat.IgnoreUnsupportedTypes);
User().Email)

When i view the collection, i cant see the data for the added column. The label is there but the column data shows "Control-Undefined". When i view the JSON of the export, i also dont see the column in powerautomate.

Any ideas will be appreciated.

All responses (6)

Answers (1)

Verified answer

Zaid-Aboobaker on at

Like (0)

Report

Re: Exporting Collection to powerautomate

Hi All. I have bypassed the problem as follows:

I created a progress column in the primary list and patched progress to the existing column as well as the linked list. this way there is no need for gymnastics to get the data from the linked/related list. i can then get the un-complex columns into the collection and export it to powerautomate.
Zaid-Aboobaker on at

Like (0)

Report

Re: Exporting Collection to powerautomate

Hi...thank you for replying.

So ive used your idea to do this:

Concat(Filter(DecisionGridProgress;ThisItem.ID= DecID);DecisionProgress;"<br>")

i.e. filter the 2nd sharepoint list by the ID, and return all the progress items. That works, but how do I get additional columns from the 2nd sharepoint list into this concat. I want to show something like this.

"Created date" - "branch name1" - Progress
"Created date" - "branch name2" - Progress
"Created date" - "branch name3" - Progress

Not using the nested galleries has still not sorted out the "Control-Undefined" problem in the collection for exporting.
gcmfaizan 1,022 on at

Like (1)

Report
Re: Exporting Collection to powerautomate

Hi @Zaid-Aboobaker

Instead of using nested galleries, try using a single gallery to display the data. You can use the LookUp function within the Concat function to gather the related data. For example:

Concat(Galprog.AllItems, Concatenate("", "(", Text(LookUp(DecisionGridProgress, ID = ThisItem.ID).Created, "dd-mmm-yyyy"), ")", "", Branch, " : ", DecisionProgress), " ")

Accept it as solution if my post helps you.

Cheers!
narayan225 2,449 Super User 2025 Season 1 on at

Like (0)

Report

Re: Exporting Collection to powerautomate

@Hmaldonado
You can try checking the flow run history to see what is being sent to the flow and check if that is formatted correctly.

Also check what the flow returns as well. If the returned data is not formatted correctly. It will not display properly in your collection.

Cheers!
Hmaldonado 21 on at

Like (0)

Report

Re: Exporting Collection to powerautomate

solutions for this?

I am trying to pass a JSON to a collection but the control-undefined is also showing.
narayan225 2,449 Super User 2025 Season 1 on at

Like (0)

Report

Re: Exporting Collection to powerautomate

@Zaid-Aboobaker

Have you tried checking the power automate run history? This tells you the data that is being sent from the canvas app to the flow.

Cheers!