web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Finding a value in a S...

Power Apps

Answered

Finding a value in a Sharepoint Table when both the column and row are determined by a label's value filled in by the user

(0) Share

Report

Report

Posted on by Tomato1

3

I am trying to find a value in a SharePoint table where the user inputs both the column and row. For example, if a user inputs 1 for the first label and 119 into the second label it would output 0.3. I am aware that variable names cannot be column names, but what is a way I can accomplish this if there are over 100 rows and columns? (All labels are restricted to taking numbers)

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Tomato1 ,

You're correct in that unfortunately, you cannot leverage data fields as variables. You would need a fairly lengthy Switch condition to identify which column to use. Fortunately, you can use the Index function to reference the row.

For example:

Switch( TextInput_Column.Text, "Column 1", Index( 'Your Data', Value(TextInput_Row.Text) ).'Your number field', "Column 2", Index( 'Your Data', Value(TextInput_Row.Text) ).'Your number field' )

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No

Join the conversation