Hi
I am trying to create a populate a microsoft word template flow when user press a button on custom page in my model driven app.
What i want to do is to pass order number which user has selected inside combobox so then further on list rows only the rows where order number is found are returned?
The otther question how in this case in flow dataverse handles relationships? The other data that i want to add to template is stored in another table relateds with same order number. How do i reach that data?
it passes me empty values in side my text variable in PowerAppsV2 trigger. What might be the issue?
@jja, if your gallery in a Canvas App which I assume the to be the case, you can use a collection to hold whatever columns you need from the gallery. Then you pass the collection as a parameter to the flow.
You would basicly use the ClearCollect function right before your run the flow in the Canvas App to get the Gallery.AllItems. You can then pass the created collection using DropColumns, to remove the unwanted columns. Something like this:
ClearCollect(colToPassToFlow, Gallery1.AllItems);
YourFlow.Run(JSON(DropColumns(colToPassToFLow,ColumnName1 [, ColumnName2, ... ]),IgnoreBinaryData))
Regards,
Ahmed
If my reply helped you, please give a 👍. And if it has solved your issue, please consider a 👍 & Accepting it as the Solution to help other members of the community find it more.
My Blog: www.powerplatformplace.com
Your proposed sollution works just fine.
Maybe you also know how to pass multiple gallery items to flow? LEts say i have a 5 column gallery and want to pass column1 that is combobox also GUID. How do i do that?
Hello, @jja, I can answer your second question: "The otther question how in this case in flow dataverse handles relationships? The other data that i want to add to template is stored in another table relateds with same order number. How do i reach that data?"
You will filter the related table using the Lookup Column. The Syntax in the Filter rows of the List Rows Action is something like this: _SolutionPrefix_RelatedTableLookupColumnLogicalName_value=GUID Value of Related record in the Parent Table.
Regards,
Ahmed
If my reply helped you, please give a 👍. And if it has solved your issue, please consider a 👍 & Accepting it as the Solution to help other members of the community find it more.
My Blog: www.powerplatformplace.com
mmbr1606
22
Super User 2025 Season 1
stampcoin
19
Michael E. Gernaey
15
Super User 2025 Season 1