Wondering if someone can help. My brain is too frazzled having tried to solve this myself. Apologies if it's too easy or I am trying something that is just not possible! 🙂
My Data source is an Excel import file with 5 names. This works fine.
I have a Dropdown1 menu which is populated by the data source. This populates fine.
I also have Gallery0 which is populated by the data source. This populates fine too.
The APP has both the Dropdown1 and the Gallery0 as a Name selection choice.
I want to send either the Dropdown1 or Gallery0 value to another gallery called Gallery1.
On Gallery1, in Items I have "Filter(Office365Users.SearchUser({searchTerm:Dropdown1.Selected.Name}),AccountEnabled=true)". This works fine.
If I change Gallery1 Items to ""Filter(Office365Users.SearchUser({searchTerm:Gallery0.Selected.Name}),AccountEnabled=true)". This works fine.
Any ideas what formula I need to use to allow Gallery1 to accept a searchTerm from either Dropdown1 or Gallery0? (both use Name)
Thanks!
