Unanswered

Get a row - key value failing to create dynamically

(0) Share

Report

Posted on by sasscocerty

Below is my flow and it is failing at the "Get a row" step because the key value is dynamic and not static. It doesn't recognize my Key Value which I'm dynamically adding to the table anytime "Add a row into a table" from the previous is run.

Below is what I'm trying to accomplish.

Forward email received in a shared mail box to individual recipients whose email address are saved in another database

Step 1. When mail new email arrives

Step 2: Add a row into a table ==> I created a excel spreadsheet with those column. The "To" field shows as 12345@domain.com. So I used the 'split' function to strip the 12345 from the rest of the email and save that in the 'eeid' column. The 12345 is unique employee number that can be cross reference in another database to find the employee's actual email address.

Step3 : Run Script ==> - I run a office script which is a recorded XLOOKUP to query another worksheet where the user 12345 has their email address saved

Step 4: Get a row ==> Here I'm trying to get the row from my table but it keeps failing because of key value not being static. As you can see from my flow, my key value is set as "id" . I use the xlookup from the previous step to populate a random number into this column.

The issue is that I cannot add a static key value to the table in advance because then the "Add a row" from the 2nd step would would fail.

See error below

Categories:

Using flows

I have the same question (0)

All responses (6)

Answers (1)

Mira Ghaly 11,413 Moderator on at

Like (0)

Report

@sasscocerty

Just to understand you a bit more , does the run script populate this field?

I believe you need to yes the Key Column as the eeid because the id is not yet there on the and you are trying to reference it from the Add Row Action

Was this reply helpful? Yes No
sasscocerty 9 on at

Like (0)

Report

Hello @Mira_Ghaly Thanks for your response.

"Just to understand you a bit more , does the run script populate this field?"
Yes, the office script populate this "id" field.
This screenshot show the XLOOKUP I used to the column F (email) data
And this screenshot show the formula I used to get data in Column G (id).

Also you stated that
"I believe you need to yes the Key Column as the eeid because the id is not yet there on the and you are trying to reference it from the Add Row Action"

I think you're right on this one, probably that's why it is returning null data when I reference it. I have to research a little bit more on how to "yes' the key column or confirm this data. Do I need to "yes" the key value too ?

Was this reply helpful? Yes No
Verified answer

Mira Ghaly 11,413 Moderator on at

Like (1)

Report

@sasscocerty

If you just used the eeid as the key column and pass the split expression the same way you are passing it on the Add row this will work.

Was this reply helpful? Yes No
sasscocerty 9 on at

Like (0)

Report

I have tried this in the past and I got an error saying the data in the eeid cannot be found. But I will try again. Thanks for your thought though

Was this reply helpful? Yes No
Mira Ghaly 11,413 Moderator on at

Like (0)

Report

@sasscocerty

No do not use eeid .. But please using the same split expression you are passing to eeid

Was this reply helpful? Yes No
sasscocerty 9 on at

Like (0)

Report

I actually used the eeid before your next reply came in and that seems to be working. Thanks so much Mira. This great. Perhaps I will get a better and quicker response with split function than the eeid. But THANK YOU !!!!

Was this reply helpful? Yes No