web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Filter a row in an Exc...
Power Automate
Unanswered

Filter a row in an Excel table with 2 conditions and update that row

(0) ShareShare
ReportReport
Posted on by

Hello everyone,

I am trying to filter a row in an excel spreadsheet using 2 conditions. However I am have difficulty with filtering and I would like to update this row with specific data. Let me show what I have current:

Error: I am getting an error when trying to filter the table to a specific Hch ID 

sophiatheresa74_0-1717700846215.png

For testing purpose I entered the Hch ID to be equal to 585-4 and getting the error above

sophiatheresa74_1-1717700933687.png

I would like to filter this excel using the Hch ID (selected at 585-4) with Column1 data at 0 the update this row with data eg: update traydt with "abcd"

sophiatheresa74_2-1717701163555.png

 

 

 

Categories:
I have the same question (0)
  • v-yueyun-msft Profile Picture
    on at

    Hi , @sophiatheresa74 

    Unfortunately, the Filter Query in List rows present in a table action does not support the use of fields with spaces in the field name as filter parameters.

    You can use the "Filter array" in the Advanced mode to filter your data.

    vyueyunmsft_0-1717722176103.png

     

    @and( equals( item()?['Hch ID'] , '585-4') ,equals( item()?['Column1'] , '0') )

     

    For the similar case , you can refer to :
    Solved: Simple Question: Filter Query Where Excel Column N... - Power Platform Community (microsoft.com)

     

    If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance! 

     

    Best Regards,

    Yueyun Zhang

     

     

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 506 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 425 Moderator

#3
abm abm Profile Picture

abm abm 245 Most Valuable Professional

Last 30 days Overall leaderboard