cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
LaLiLu124
Frequent Visitor

how to use @OData.Community.Display.V1.FormattedValue in "list rows"

I would like to use the dataverse value @OData.Community.Display.V1.FormattedValue in the "List Row" action in "Filter row". However, I do not know how. For example, this is relevant for me if my values in dataverse are of type "choice.
 
Bildschirmfoto 2022-04-04 um 18.41.24.png
1 ACCEPTED SOLUTION

Accepted Solutions
abm
Super User
Super User

Hi @LaLiLu124 

 

You cannot use the direct filter query by text name for choice fields. It has to be the numeric value. Once you retrieved the values then use the Select to filter against the choice text. 

 

Please follow the below steps:

 

image.png

 

Above under the Filter array action step I have placed an item() filter and the syntax is as follows:

 

item()?['ajb_type@OData.Community.Display.V1.FormattedValue']
 
Here ajb_type is my choice column name.
 
Thanks


Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

View solution in original post

2 REPLIES 2
abm
Super User
Super User

Hi @LaLiLu124 

 

You cannot use the direct filter query by text name for choice fields. It has to be the numeric value. Once you retrieved the values then use the Select to filter against the choice text. 

 

Please follow the below steps:

 

image.png

 

Above under the Filter array action step I have placed an item() filter and the syntax is as follows:

 

item()?['ajb_type@OData.Community.Display.V1.FormattedValue']
 
Here ajb_type is my choice column name.
 
Thanks


Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials
abm
Super User
Super User

Hi @LaLiLu124 

 

I have made a tutorial video about this. Please have a look.

 

https://youtu.be/KeZnMUGtBSA

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (2,926)