Answered

Filtering SharePoint document library by two parameters

(0) Share

Report

Posted on by Thommy

Hi - as above I am filtering a SharePoint document library and I am experiencing some variable outcomes when I toggle between using ALT in my Editing session and previewing the app (F5). Essentially I am changing some filtering code to include an extra parameter and it works fine to execute what I need in the edit session, but doesn't filter when previewing the app (F5). Here is the original code with one filter parameter (which works fine in edit and preview) :

<tr>" & "
 <td colspan=""7"" class=""content"">" & "Supporting information:" & "
 <ul>
 " & Concat(
 Filter(
 'KPI attachments',
 KPI_ID = 'Select a KPI'
 ),
 "
 <li><a target=""_blank"" href=""" & 'Link to item' & """>" & Description & "</a></li>" & Image & "
 "
 ) & "
 </ul>
 " & "</td>
 " & "</tr>

And here is my code with the extra filter parameter (only works in the ALT-edit session):-

<tr>" & "
 <td colspan=""7"" class=""content"">" & "Supporting information:" & "
 <ul>
 " & Concat(
 Filter(
 'KPI attachments',
 KPI_ID = 'Select a KPI',
 Text(
 Date,
 "yyyy"
 ) = Text(ddDateList.Selected.Value)
 ),
 "
 <li><a target=""_blank"" href=""" & 'Link to item' & """>" & Description & "</a></li>" & Image & "
 "
 ) & "
 </ul>
 " & "</td>
 " & "</tr>

I assume I need to tidy up the code, any suggestions are welcome. Cheers, Thom

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

iAm_ManCat 18,256 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Not sure exactly why it only works using ALT-hold, but, I do have a few suggestions:

Don't name your data columns with a name that conflicts with an existing Power Apps function - in this case, 'Date' as it will confuse the Editor when you try to filter by something that is the name of a function

I would also advise not running a conversion function against the datasource as that then requires calculations at the datasource end which will likely not be delegated and cause delegation issues - if at all possible, when you write data to the source, assuming its from this same app, write a column for each item called 'DateYearValue' that contains the output of that conversion function ie "2024" - that way you can filter in your gallery later by a single line text column or a number (depending on how you choose to store it) like this:

Filter( 'KPI attachments', KPI_ID = 'Select a KPI', DateYearValue = ddDateList.Selected.Value )

Lastly, don't use just the control name when referring to a control 'Select a KPI', be explicit and list the specific property you are looking for as sometimes it will try and be smart and match a different property

Filter( 'KPI attachments', KPI_ID = 'Select a KPI'.Selected.Value, DateYearValue = ddDateList.Selected.Value )

Hope this helps a bit!

Cheers,

Sancho

Was this reply helpful? Yes No
Thommy 8 on at

Like
a
(1)

Report
Copy link

Link copied!

Thanks for your suggestions. I was able to incorporate a single line of text column to achieve the filtering. Cheers

Was this reply helpful? Yes No