Good morning, afternoon, or evening :) depending on your location! It seems like you're trying to use the formatted value field in a filter query within the "List Rows" action in Power Automate, but encountering a syntax error. Unfortunately, the @OData.Community.Display.V1.FormattedValue annotation cannot be directly used in filter queries. This annotation is meant for retrieving formatted values in the output, not for filtering data. To achieve what you're trying to do, you can follow these steps:
Retrieve the Data: Use the "List Rows" action without applying the filter query. This will fetch all the rows from the table.
Apply Filtering in Power Automate: After retrieving the data, use a "Filter Array" action to filter the rows based on the formatted value. You can access the formatted value using an expression like:
outputs('List_Rows')?['body']['fieldname@OData.Community.Display.V1.FormattedValue']
Replace fieldname with the actual field name you're working with.
Proceed with the Filtered Data: Once you've filtered the data using the "Filter Array" action, you can proceed with the filtered results in your flow.
This approach allows you to work with formatted values indirectly, as Power Automate does not support filtering directly on formatted values in the "List Rows" action. Hope this helps some!
1 people found this reply helpful.
Was this reply helpful?YesNo
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.
20
Share
Report
All responses (
Answers (
