Answered

Need help for Get files (properties only) Filter Query with two conditions

(1) Share

Report

Posted on by DonnaW

Hello!

I am trying to add a second condition to the Filter Query on a Get Files (properties Only) flow. I've tried using "and" in the formula based on other examples in this community, and no combination seems to work. I've tried adding conditions and other types of steps with no success. My current formula that works and provides all data is:
Modified gt '@{formatDateTime(adddays(utcNow(),-7),'yyyy-MM-dd')}'

I would like to add that the ImageTags field contains "academy"
Please help if you can. Here is a screen shot of my current flow. Thank you!

Categories:

Using flows

I have the same question (0)

All responses (6)

Answers (1)

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @DonnaW

Did you tried

substringof('academy',ImageTags)

Thanks

Was this reply helpful? Yes No
DonnaW 22 on at

Like (1)

Report

Hi @abm , thank you for your response! How do I incorporate that into my existing query of Modified gt '@{formatDateTime(adddays(utcNow(),-7),'yyyy-MM-dd')}'
When I try to add an "and" statement, the run fails. I've tried multiple ways to add it with no success.

Was this reply helpful? Yes No
Verified answer

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @DonnaW

Try the below and it did worked for me.

Created gt formatDateTime(adddays(utcNow(),-7),'yyyy-MM-dd') and substringof('academy',ImageTags)

Was this reply helpful? Yes No
DonnaW 22 on at

Like (1)

Report

I keep getting an error that the column ImageTags doesn't exist, even though it does. I tried ImageTags, Image_Tags, imagetags, Imagetags, and Image Tags. Any ideas on why it won't recognize my column name?

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi

Do the following:

1. Go to the settings of the list

2. Under the columns click the ImageTags

3. Check the browser URL and at the end it shows column=

4. That's the schema name you need to use in your filter query.

Thanks

Was this reply helpful? Yes No
DonnaW 22 on at

Like (1)

Report

Okay! I think I see the problem now, for some reason, the Image Tags field, even though it displays as a column in my library, is not in the list with the other fields in the settings. So very weird. Thank you for all of your help, I really appreciate it. I think this is a full on Support issue now.

Was this reply helpful? Yes No