Add multiple formulas to gallery

(0) Share

Report

Posted on by MHSPDev

Hello everyone,

I'm currently building an app for a Risk Register using a SharePoint list.

I posted yesterday as I was struggling to figure out how to get two combo boxes to work for filtering my gallery but that was sorted.

However I have now realised that fixing the combo boxes has broken the Search Input, which I now need help with.

Here is my current formula in the gallery:

Filter(
'Risk Register',
(IsBlank(ComboBox1.SelectedItems) || IsEmpty(ComboBox1.SelectedItems) ||
RiskOwner.DisplayName in ComboBox1.SelectedItems.DisplayName) &&
(IsBlank(ComboBox2.SelectedItems) || IsEmpty(ComboBox2.SelectedItems) ||
RiskStatus.Value in ComboBox2.SelectedItems.Value)
)

That formula allows me to filter my gallery using two combo boxes either independently of each other or simultaneously.

I now need to incorporate this formula but cannot figure out how to do it:

Search([@'Risk Register'], SearchInput1.Text, "RiskDescription", "RiskDescription")

Any help is greatly appreciated!

All responses (3)

Answers (1)

SpongYe 5,580 Super User 2025 Season 1 on at

Like (1)

Report

Re: Add multiple formulas to gallery

Hi @MHSPDev

I don't mind 😊
Good luck further!

If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻
MHSPDev 65 on at

Like (1)

Report

Re: Add multiple formulas to gallery

SpongYe this is twice now you've saved me after hours of googling.

I'll have to start paying you soon!

Thank you very much, all working now.
Verified answer

SpongYe 5,580 Super User 2025 Season 1 on at

Like (1)

Report
Re: Add multiple formulas to gallery

Hi @MHSPDev

You can combine both formulas:
Search( Filter( 'Risk Register', (IsBlank(ComboBox1.SelectedItems) || IsEmpty(ComboBox1.SelectedItems) || RiskOwner.DisplayName in ComboBox1.SelectedItems.DisplayName) && (IsBlank(ComboBox2.SelectedItems) || IsEmpty(ComboBox2.SelectedItems) || RiskStatus.Value in ComboBox2.SelectedItems.Value) ), SearchInput1.Text, "RiskDescription" )
If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻