Get row

(0) Share

Report

Posted on by JQ-09030645-0

Hi, Guys!

I have been working on a flow and I'm stuck with the get row function. I have been trying to make it to work but it seems that everytime I use a dynamic function as key value, it doesn't work. But when I type the value in the key value in get rows, the flow runs smoothly. Do you know what the problem might be? I tried all value and compose and nothing seems to be working. Your help is very much appreciated :(.

Screenshot 2026-0...

Your file is currently under scan for potential threats. Please wait while we review it for any viruses or malicious content.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Expiscornovus 33,891 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @JQ-09030645-0,

Have you tried to use a initialize variable of type string? And have you added the dynamic content field as a custom value?

Below is an example setup, to demonstrate that this should be possible in the Get a row action.

1. Workbook (Book15.xlsx) with Table (table1) and Key column (Title)

2. Flow setup

3. Test run

Happy to help out 😁

I share more #PowerAutomate and #SharePointOnline content on my Blog, LinkedIn, Bluesky profile or Youtube Channel

Was this reply helpful? Yes No
JQ-09030645-0 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, Expiscornovus.

Thank you for replying to my query. I tried using an initialised variable and set its type to string. But it seems it is not working. The scenario I have is that the key value changes based on the information provided, so I needed to make it dynamic rather than constant. Let me provide an example :). The info I need to extract is the name of the new hire who completed the course, and I'll use that value to search our database and retrieve his information from a spreadsheet or SharePoint. Every time I put the name into a variable and use that variable to search in our database, it can't find a match. But if I manually type the exact name in the key value, the way I receive it in an email, it works.

Manual Entry: It works.

If you put it in a variable or use a dynamic value referencing the name, It does not work. :(

hope I was able to provide a good example hehe..

Was this reply helpful? Yes No
Suggested answer

CU10030216-0 2 on at

Like
a
(0)

Report
Copy link

Link copied!

数据源是否有不可见字符,将变量用正则处理后再试试看。

Was this reply helpful? Yes No
JQ-09030645-0 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, CU10030216-0.

Not sure if I was able to translate it correctly bu the below is in the english text. :)

我试过修剪、转换成字符串、把变量放到组合框里，但好像都没用。唯一的办法是手动在注释里输入名字，然后把注释内容作为值放到一个变量里，这样就能用了。我不喜欢的就是必须手动操作。哈哈，我就是懒

I tried trimming, converting to a string, and putting the variable in a compose, but nothing seems to work.
The only workaround is to manually type the name in the comment, set the comment as the value, and put it in a variable; that works. What I don't like is I have to manually do it. Just being lazy, hehe.

Was this reply helpful? Yes No