Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Microsoft Dataverse
Unanswered

Pass parameter to Odata filter

(0) ShareShare
ReportReport
Posted on by 820

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?

Categories:
  • julijazas Profile Picture
    820 on at
    Re: Pass parameter to Odata filter

    @AhmedSalih 

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

    jja_0-1660319093634.png

     

  • AhmedSalih Profile Picture
    6,678 Super User 2025 Season 1 on at
    Re: Pass parameter to Odata filter

    @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

  • julijazas Profile Picture
    820 on at
    Re: Pass parameter to Odata filter

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

  • AhmedSalih Profile Picture
    6,678 Super User 2025 Season 1 on at
    Re: Pass parameter to Odata filter

    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

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Apps - Microsoft Dataverse

#1
mmbr1606 Profile Picture

mmbr1606 22 Super User 2025 Season 1

#2
stampcoin Profile Picture

stampcoin 19

#3
Michael E. Gernaey Profile Picture

Michael E. Gernaey 15 Super User 2025 Season 1

Overall leaderboard

Featured topics