You’re offline. This is a read only version of the page.
22
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!
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.
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
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?
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.
#1
WarrenBelz
146,660
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,004
Most Valuable Professional
Share
Report
All responses (
Answers (
