Unanswered

Get a row Error - Key Value

(0) Share

Report

Posted on by Kingfisher1

I have created a workflow. An excel with data. User submits data of each row values (T-ID) in excel through MS form. Flow checks the submitted ID is equal to value in T-ID column, if yes, then takes other corresponding values as well and send an email.

Issue is with get a row function. Key column given as T-ID, Key value given using trim function to eliminate space error,

trim(outputs('Get_response_details')?['body/r3d39b6e83fee43c0a2c6f94b8ed978ff'])]. Flow checks T-ID column, but Key value taken is date value submitted in MS Forms, not ID and returns no value found error.

Please help resolve this

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

rzaneti 4,491 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Kingfisher1 ,

The MS Forms connector can be tricky sometimes, as the answers references are using these GUID values (in your case, r3d39b6e83fee43c0a2c6f94b8ed978ff) instead of the question labels. Could you please share an image of the raw outputs of your 'Get response details' action, so we can see if the values assigned to r3d39b6e83fee43c0a2c6f94b8ed978ff really match to the expected ID?

To access the raw outputs, you just need to go to your flow run, navigate until the action an click in "Show raw outputs":

If you need more instructions about how to access the raw outputs, refer to this article: http://digitalmill.net/2023/06/29/how-to-access-the-raw-outputs-in-power-automate/.

And make sure to remove any sensitive data before sharing the image with the outputs 🙂

Was this reply helpful? Yes No
Kingfisher1 78 on at

Like (0)

Report
Copy link

Link copied!

Fortunately, get a row issue is resolved. now it is stuck with parse Json step. Documents uploaded in MS Form for the ID value has to be attached in send an email step. Do this to be stored in sharepoint before applying json

Was this reply helpful? Yes No
Kingfisher1 78 on at

Like (0)

Report
Copy link

Link copied!

this also got resolved. now in the last step where multiple attachments from forms to be attached in send an email flow. it goes as single file.

Was this reply helpful? Yes No