Unanswered

How to filter excel table with an array?

(0) Share

Report

Posted on by eienkisu

How to filter excel table with an array of strings?

Below is just a sample, I know we can use and() and equal() to filter the items but ideally I will have an automated flow, send myself an email and split the email subject to set the PNarr array variable.

My excel table before filter:

i want the final result to look like after filtering:

My flow:

Categories:

Building flows

sample.xlsx

I have the same question (0)

All responses (2)

Answers (1)

eienkisu 11 on at

Like (0)

Report

filter array and create html shows nothing.

Was this reply helpful? Yes No

Verified answer

eienkisu

11 on at

Like (0)

Report

Found the solution

initialise an array variable then loop through it.

final output:

@OData.context @OData.etag ItemInternalId Protocol No_x002e_ PI Name

https://excelonline-sea.azconn-sea-001.p.azurewebsites.net/$metadata#drives('b%21TAHF_VeXO0iv6CmjvG7Akpui3tDnl5xHuAN_7fEjCh5L6cMN5JQFTpg-ZZVA2Sng')/Files('01WEYISVJDW3LBDCXHLZGLQCDFGSB4SPI6')/Tables('%7BD2CCF980-1B8A-4974-9862-08336C13BA37%7D')/items/$entity	test-111	test-111	Amy
https://excelonline-sea.azconn-sea-001.p.azurewebsites.net/$metadata#drives('b%21TAHF_VeXO0iv6CmjvG7Akpui3tDnl5xHuAN_7fEjCh5L6cMN5JQFTpg-ZZVA2Sng')/Files('01WEYISVJDW3LBDCXHLZGLQCDFGSB4SPI6')/Tables('%7BD2CCF980-1B8A-4974-9862-08336C13BA37%7D')/items/$entity	test-222	test-222	Ben
https://excelonline-sea.azconn-sea-001.p.azurewebsites.net/$metadata#drives('b%21TAHF_VeXO0iv6CmjvG7Akpui3tDnl5xHuAN_7fEjCh5L6cMN5JQFTpg-ZZVA2Sng')/Files('01WEYISVJDW3LBDCXHLZGLQCDFGSB4SPI6')/Tables('%7BD2CCF980-1B8A-4974-9862-08336C13BA37%7D')/items/$entity	test-333	test-333	Charles