Filter & Search SharePoint List Fast - Power Automate

[@alessandramacedo5486]

Excellent video! Trying to reset searchinput (modern text input), with your refresh formula, but gallery not show all items again, how to reset search input and gallery to show all items again?

[@tylerkolota]

Hello, You will need to clear all the filter & search inputs & then click Filter & Search again. Alternatively you could write some expression in Power Apps to automatically on selection, clear those inputs & select that Filter & Search button.

[@alessandramacedo5486]

Works great, thanks. Is that possible to use ExpandColumns to create a column of another sharepoint list, with Ref Colum (same). This column will concat all values from this new list that match criteria (RefColum). I don't know how to include this in your code@@tylerkolota

[@arianemedeirossantos4903]

Thank you very much, this is really fantastic. If I had an additional Value column and wanted to see a total label at the end, how would I sum all the items that appear in the gallery?

[@tylerkolota]

Are you talking about a Gallery in Power Apps? There is a way to reference AllItems for a gallery column & use the Sum( ) expression on it. www.crmonce.com/how-to-calculate-gallery-items-in-power-apps/

[@birtukangizachew2792]

Super helpful!!! Will it work for a document library with multi-select choice fields?

[@tylerkolota]

It looks like multiple choice fields can be updated through HTTP calls with the following format: { "__metadata": { "type": "Collection(Edm.String)" }, "results": ["Choice1", "Choice2", "Choice3"] // Your choice values } So in the GenerateSPData Select action you would specify your multiple choice field name on the left side of the mapping, then on the right-side of the mapping for the value you would need to write a dynamic expression to output something like the above json. So you would likely form the above as a string in a concat( ) expression & then surround that concat with a json( ) expression, json(concat('{ "__metadata": { "type": "Collection(Edm.String)" }, "results":' **Insert expression to output a string-ified array of the multi-choice values for each item**, '}'))

[@birtukangizachew2792]

Thank you so much! I will try this.

[@cat-si1et]

I heard you can also use microsoft graph api to perform search. Would that approach be simpler compared to using power automate?

[@tylerkolota]

You can try that, but I believe it will be limited to search, as in you won't be able to combine searches with filters. And it uses the Office365Groups connector which at least in Power Automate is being replaces by a V2 which does not allow broader graph api queries. So I don't know how long it will be available for. kzbin.info/www/bejne/hHvEeXZriJ52oNEsi=nMdsc1QRJ5pEqVpY

[@cat-si1et]

@@tylerkolota I see, the graph api is not really a sustainable way as of now. Thank you for the info! Love your work :)