You’re offline. This is a read only version of the page.
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.
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.
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.
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:
Share
Report
All responses (
Answers (
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!
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!
solutions for this?
I am trying to pass a JSON to a collection but the control-undefined is also showing.
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!
#1
WarrenBelz
791
Most Valuable Professional
#2
MS.Ragavendar
410
#3
mmbr1606
275
Super User 2025 Season 1
