Unanswered

Pass parameter to Odata filter

(0) Share

Report

Posted on by julijazas

820

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?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (0)

AhmedSalih 6,678 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No
julijazas 820 on at

Like (0)

Report

@AhmedSalih
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?

Was this reply helpful? Yes No
AhmedSalih 6,678 Moderator on at

Like (0)

Report

@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

Was this reply helpful? Yes No
julijazas 820 on at

Like (0)

Report

@AhmedSalih
it passes me empty values in side my text variable in PowerAppsV2 trigger. What might be the issue?

Was this reply helpful? Yes No