Power Platform Community Forum Thread Details

Hi,

I have questions on the "Get a row" action

image001 (1).png

I would like to know what is the meaning of Key Column and Key-Value in the simplest way as possible

As based on my understanding, Key Column and key-value used as a reference to retrieve the value that I need. For example. I would like to get the Approver's email so I set the key column as "Role" and Key-Value "Approver" so that I can get the approver email

I would need some explanation on Key Column and Key-Value

Thank You

Categories:

Building flows

Hi @Anonymous

For the Get a Row Action (and Update, Delete a Row actions), the Key Column (that you select from the dropdown) is the column that you want to search for in the table and the Key Value (the you provide an input for) is the value that you want to search for in that particular column in the table.

Example: Table 1 is my table with columns Vegetable and Color. There are two rows in the table with data as Tomato, Red and Carrot, Orange. So if I wanted to get the row that has Carrot in it, my Key Column would be Vegetable and the Key Value would be Orange.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!