Unanswered

Forms response ID Formatting

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I'm trying to use the Forms response ID to go back into the submitted responses table following an approval to update the row.

It worked a few weeks back just using the forms response dynamic value directly as the Key Value. However, they've been failing because the format of the dynamic content when used as an Excel row ID comes out as '504'. with 504 being the response number. No idea why the additional characters are there.

"No row was found with Id '504'."

Shouldn't have to do any kind of reformatting of the Response ID to turn it into a usable number surely?

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (0)

Sort by

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
v-bacao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

You could try to use int() function to format id to number. Like:

Hope this helps.

Best Regards,

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi there, Sorry to report back that, that does not work putting it into an integer.
I've put together a test flow/form to save meddling with what is currently a used flow/form

It's really bizarre because I'm only using the value given by the forms response which it itself has populated in the table.

What's more weird is that it the Excel update row function can see the number, 1 in this case, but is then unable to find that row?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

What's even more weird is that, removing the integer AND the response ID completely and just replacing it with the number, 1, it still doesn't find the row

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Now this is getting even more weird.
I've just setup a flow with just a manual button and an excel row update.

If I use Key Column "ID" and just enter 1 as the Key Value, it doesn't update and fails. If I use Key Column "test" it works.

Bearing in mind, column "ID" is the column that Forms populates with the response ID.

So, for whatever reason the Excel Business Online connector can now longer read ID columns created by Microsoft Forms

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

So, I think I've found a solution as terrible as it is.

By renaming the original forms ID column to something else like "Old ID" and inserting another column as ID which just duplicates the value from the Old ID column, the Excel update row function can then use the newly created ID column instead without having to update the flow.

I've had to come up with a work around because I've got over 500 update approvals, some are a month old which are being worked through which update the table when they've been completed with comments and links and so it's not practical to have to re-run all these runs.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Scratch that.

Was this reply helpful? Yes No
v-bacao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Check if the type of ID field in the Excel table is Number or text.

Best Regards,

Was this reply helpful? Yes No