inner exception: We couldn't convert to Number.

(0) Share

Report

Posted on by SachinG31

422

Hello All,

I want to create one flow which pic file from one file folder location and copy to another location. Here i want when file copy from one location to another the name on destination folder should change as per the value stored in one SQL table. So i used get row SQL.

but i am not sure what to mention in the Row ID column , the file name of source folder and fileID of SQL table column is common.

For Example file name in folder is ABC , and in SQL table column stores in FileID column is ABC

when when i am mentioning File name or display file name or file id , it gives error.

"We couldn't convert to Number.
inner exception: We couldn't convert to Number."

Here is my flow. Error comes in get row V2, what should i mention in Row ID, please advise

Categories:

Building flows

I have the same question (0)

All responses (9)

Answers (0)

eliotcole 4,363 Moderator on at

Like (1)

Report
This is a long shot, and I'm not sure I can commit to helping with a full flow analysis here, but could you try using this expression in the Row id field instead?

int(items('Apply to each')?['List of Files Id'])

What would really help is placing a Compose action in that Apply to each action that shows the 'List of Files Id' value away from the Get row (V2) action. Could you also try with that?

Was this reply helpful? Yes No
SachinG31 422 on at

Like (1)

Report

hello @eliotcole , Thanks for looking into this , i tried expression in row id , i am getting this error.
My File names which is copying from source are like this.

Was this reply helpful? Yes No
eliotcole 4,363 Moderator on at

Like (1)

Report

Thanks, can you place a Compose action **before** the Get row (V2) action, and put this value in there, so that we can see the results?

Was this reply helpful? Yes No
SachinG31 422 on at

Like (0)

Report

@eliotcole Thanks , some weird value is coming in file ID , please see the screen shot below.

Was this reply helpful? Yes No
eliotcole 4,363 Moderator on at

Like (1)

Report

That is your issue right there.

You are trying to find a Row ID based on that string of text.

The Row id I would assume needs to be an integer (1, 2, 3, 4, etc), I think you need to work out how you're picking your row data from the database. I probably can't help much more based on that, though. However it's definitely what's causing the error.

Was this reply helpful? Yes No
SachinG31 422 on at

Like (1)

Report

All right @eliotcole , let me work on this , i will update you accordingly , Thanks for all the help

Was this reply helpful? Yes No
eliotcole 4,363 Moderator on at

Like (0)

Report

No wuckas, mate ... hope that you get things sorted. 👍

Was this reply helpful? Yes No
SachinG31 422 on at

Like (0)

Report

Hello @eliotcole , here instead of GetRow V2 i am trying using GetRows V2 , which requires O Data query , i have no idea what to write in filter query and select query statement , can you advise. My FileID column in SQL table is equal to List of file display name

Was this reply helpful? Yes No
eliotcole 4,363 Moderator on at

Like (0)

Report
Again, I can't talk to how the SQL connector works, I'm afraid. 😞

That said, maybe these few of notes on the ODATA might help:
Change "Eq" into "eq"
Put a space after "eq" and before your flow value.
Usually you should put any value you are filtering or sorting/ordering by in single ( ' ) quotes.
Your flow value appears to be (again?) a value that is an array. You're not going to get results from that.

If you are filtering an array of something (which is what I assume the SQL connector is) then you need to filter by a single string or number. Most often that string or number should also be place inside single quotes, like 'string' or '123' if you follow me.

Try to find a better value to sort by.

Otherwise, like I say, this one might be beyond me as I've not got experience with the connectors at hand, I am just offering you some general advice.

Was this reply helpful? Yes No