You’re offline. This is a read only version of the page.
Announcements
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
For testing purpose I entered the Hch ID to be equal to 585-4 and getting the error above
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"
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.
@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
Share
Report
All responses (
Answers (
506
