Hi
I have a flow that works fine.
It gets user data from O365 and inserts it into a SPO list.
I have an SPO Document library with images.
I want to change my flow so that it checks if an image exists in the SPO Document Library.
If the image exists then I wan to put a "Yes" in a column in the list, if the image doesn't exist I want to put a "No" in the column in the list.
I get the error on my "Get Files"
"The field 'LinkFilename' of type 'Computed' cannot be used in the query filter expression."
Thanks
P
Unfortunately, you can't use Calculated Columns in your Filter Query on Get files.
I would suggest you use Get files before your Apply to each, so you get the full list of files and are only calling Get files once (more efficient).
Then in place of your Get files in the Apply to each, use a Filter query using the value from Get files as your input. You can use Calculated Columns in a Filter query.
Tomac
986
Moderator
stampcoin
699
Super User 2025 Season 2
Riyaz_riz11
577
Super User 2025 Season 2