Answered

Get Files (Properties only) Filter Query Issues

(1) Share

Report

Posted on by trstrean

181

I'm trying to delete some files from a SharePoint document library as part of a Power App. I'm using the Power App V2 connector to get the GUID from the parent record and pass that to the flow (GUID is one of the columns within the document library). When I use the Get Files (property only) connector, I cannot set the filter query to filter the files. Usually, when working with a SharePoint List, the available columns show for selection, but for some reason, I do not see anything. I've also tried just using an expression but comes back with an expression error. Here is what I see for the filter query drop-down:

Here is what I tried for the expression: DataverseGUID eq 'triggerBody()?['text']' (where the trigger is the Power Apps field and DataverseGUID is the internal name of the column within the document library)

Is there a different way to filter the files? I'm trying to get a filtered list of the documents that belong to the parent ID so that I can pass the ID(s) to the delete file step. Often, multiple files are linked to the parent when deleted and it isn't possible to pass the SharePoint file ID from Power Apps based on how the parent is deleted. Thanks in advance for any assistance!

I have the same question (0)

All responses (5)

Answers (1)

abm abm 32,600 Most Valuable Professional on at

Like (0)

Report

Re: Get Files (Properties only) Filter Query Issues

Hi @trstrean

Turn the experimental features off and try the query again

If you get an error post the error details.

Thanks

Was this reply helpful? Yes No
trstrean 181 on at

Like (1)

Report

Re: Get Files (Properties only) Filter Query Issues

I had tried that before posting. It's the same issue. If I use the expression builder, it just says the expression is not valid. I tried using the expression I originally posted as well as using dynamic content. It's acting like none of the columns are present or usable for the filter. When I test the get files without the filter, all of the columns are available. I even tried just using the ID field and directly filtering for the ID I'm looking for but I still get the expression isn't valid error. Hopefully, some of that helps with people's thought process on the issue. I should also include that I'm in a GCC tenant, so most things do work a little differently. Below is the specific error if I try typing in the expression (expression builder doesn't allow getting past "Ok" to commit it.

The expression "DataverseGUID eq 'triggerBody()?['text']'" is not valid. Creating query failed.

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

Like (0)

Report

Re: Get Files (Properties only) Filter Query Issues

Hi @trstrean

Two thing to check.

(1)

SharePoint Site Settings > Click column DataverseGUID > check the browser url at the end it says Field=xxxx

Make sure exact name you are using in your filter query

(2) Add a compose action step before the Get Items. Then set the expression triggerBody()?['text']. Run the flow an check the value?

Was this reply helpful? Yes No
trstrean 181 on at

Like (0)

Report

Re: Get Files (Properties only) Filter Query Issues

I checked, and both came back with the expected value. I tried a couple of other approaches just to validate things are getting pulled correctly. Here is part of the output from a filter array (to filter the Get Files by column since that did work):
Here we can see the column names and the correct ID for what is trying to get deleted. Keep in mind, I couldn't even add the "ID" column to Get Files filter which is a reliable test column as it is system generated. My assessment of the Get Files in this environment is that it isn't working correctly.

I think a solution that might work, is to go from the filter array to deleting the file, but I'm not sure what the steps for that would be. I tried going directly to apply to each of delete file using the filter array, but the filter array doesn't provide me the column information to add to the identifier, or ID.

Was this reply helpful? Yes No
Verified answer

trstrean 181 on at

Like (1)

Report

Re: Get Files (Properties only) Filter Query Issues

I found a strange solution to this particular issue when demonstrating how it should work for the SharePoint List equivalent connector. When I brought that connector in, the Get files (properties only) connector started working the way it should. If anyone else is having this issue, that might resolve the problem for you.

I've tried creating new flows and the Get files (properties only) connector works right away now.

I hope it helps anyone else with the same issue!

Was this reply helpful? Yes No