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.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

narayan225 2,547 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@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!

Was this reply helpful? Yes No
Hmaldonado 21 on at

Like
a
(0)

Report
Copy link

Link copied!

solutions for this?

I am trying to pass a JSON to a collection but the control-undefined is also showing.

Was this reply helpful? Yes No
narayan225 2,547 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@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!

Was this reply helpful? Yes No
gcmfaizan 1,022 on at

Like
a
(1)

Report
Copy link

Link copied!
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!

Was this reply helpful? Yes No
Zaid-Aboobaker on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

Zaid-Aboobaker on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No