Answered

List rows in present tabel - filter query issues

(0) Share

Report

Posted on by Scherodan

Hi community,

may I please ask for your help on the following issues. I try to filter a huge excel report to process only the requiered topics within a flow. So I try this filter in a 'list rows in present table' action but it don´t work - as bad request.

substringof('DE',CompanyCode) and LastModifiedDate gt '@{addDays(utcNow(),-2)}'

At least I need both filter to reduce the file much as possible.

Thx Martin

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Expiscornovus 33,970 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Scherodan,

As far as I am aware the List rows present in table action Filtering is a bit more limited.

That being said, have you tried a contains instead of a substringof function? Try something like below:

contains(CompanyCode,'DE')

From the Excel Online Business connector docs:

https://learn.microsoft.com/en-us/connectors/excelonlinebusiness/#known-issues-and-limitations-with-actions

The List rows present in table action supports basic filtering and sorting:
- Supports the following filter functions: eq, ne, contains, startswith, endswith.
- Only 1 filter function can be applied on a column.
- Only 1 column can be used for sorting.

Was this reply helpful? Yes No
Expiscornovus 33,970 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Edit: My browser decided to post my reply twice. Ignore this reply 😁

Was this reply helpful? Yes No
Scherodan on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Expiscornovus,

thx a lot for your response. Unfortunatly the expresson 'contains' give me another error. This expression only allow "ONE" filter criteria - but I need both.

Thx
Martin

Was this reply helpful? Yes No
Verified answer

Expiscornovus 33,970 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Scherodan,

You might be able to use a Filter Array after the first check for companycode. In that filter array you could filter for the LastModifiedDate value.

Was this reply helpful? Yes No
Scherodan on at

Like
a
(0)

Report
Copy link

Link copied!

Thx @Expiscornovus this might solved it!

Was this reply helpful? Yes No