cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Chenhui
Helper I
Helper I

calling for a specific cell in excel sheet

Hello!

 

I was wondering if there is any way for me to create a function similar to the Search function that allows me to search for both the row and the specific column heading (aka to call out a cell). Such that users of the app will be able to select the row heading of their choice as well as the column heading of their choice.

 

example of data I have in my excel

 

country        region       population 

 

A                      2                  1234

B                      1                  5678 

C                      2                  9012

 

 

is it possible for the user to type into a search bar something like "C population" to retrieve the 9012 value? Or is there any other alternative way/ suggestions?

 

Thank you so much! 

1 ACCEPTED SOLUTION

Accepted Solutions
CNT
Community Champion
Community Champion

@Chenhui Typing the column name into a text field would not be ideal. Instead, you can use a dropdown with all the Column Names listed and search based on the user selection. Use a Textinput for the row value.

Your query will look like,

Switch(yourDropDown.SelectedText,

   "column1", Filter(yourDataSource, column1=yourSearchTextinput.Text),

   "column2", Filter(yourDataSource, column2=yourSearchTextinput.Text),

   // add more...

)

View solution in original post

5 REPLIES 5
CNT
Community Champion
Community Champion

@Chenhui Typing the column name into a text field would not be ideal. Instead, you can use a dropdown with all the Column Names listed and search based on the user selection. Use a Textinput for the row value.

Your query will look like,

Switch(yourDropDown.SelectedText,

   "column1", Filter(yourDataSource, column1=yourSearchTextinput.Text),

   "column2", Filter(yourDataSource, column2=yourSearchTextinput.Text),

   // add more...

)

View solution in original post

Hello @CNT thank you so much for the help! I am a little new to power apps so I am having a bit of difficulty with coming up with the drop down list with column headers. May I know if the query is to be put into the dropdown box or is that for my gallery or the textinput? I have keyed in the in the dropdown box ["column 1", " column 2", "column 3"] to get the drop down box. I am assuming the query is for the gallery, but when I input the code it has highlighted my dropdown name in the code saying that there is an error. How should I go about it? thank you so much really appreciate the help!!

CNT
Community Champion
Community Champion

@Chenhui You are right, the query is for the Items property of the Gallery. Could you send a screen shot of the formula in the Items property of the gallery along with the error message.

@CNT Thank you so much for the help! Sorry for the delay in response but i have figured it out with your explanation!! Really appreciate the help so much!! 

CNT
Community Champion
Community Champion

@Chenhui Glad to help!

 

Please remember to give a 👍 and accept the solution as it will help others in the future.

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Users online (1,407)