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:

Business Process Flows

All responses (3)

Answers (0)

Kingfisher1 78 on at

Like (0)

Report

Re: Get a row Error - Key Value

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.
Kingfisher1 78 on at

Like (0)

Report

Re: Get a row Error - Key Value

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
rzaneti 4,096 Super User 2025 Season 1 on at

Like (0)

Report

Re: Get a row Error - Key Value

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 🙂