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
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.
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
Edit: My browser decided to post my reply twice. Ignore this reply 😁
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:
Share
Report
All responses (
Answers (
contains(CompanyCode,'DE')
From the Excel Online Business connector docs:
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.
#1
Michael E. Gernaey
566
Super User 2025 Season 1
#2
David_MA
516
Super User 2025 Season 1
#3
stampcoin
492
