Unanswered

SharePoint list to update SQL Table

(0) Share

Report

Posted on by stekum Microsoft Employee

I want to update a SQL table with list items in a SharePoint list. Getting the follwowing error in SQL update row step:

"Invalid Mashup Expression using supplied values.\r\n inner exception: We couldn't convert to Number

I did populate the exacte same table with the same sharepoint data before with a different flow w/o issues. Anyone can provide further guidance how to trouble shoot this...?

thxs,

Stefan

Categories:

Using connectors

I have the same question (0)

All responses (5)

Answers (0)

Sort by

v-monli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi stekum,

May I know the detailed information of your flow? Did you use the template "When an existing list item is modified, update a SQL row"?
Mona

Was this reply helpful? Yes No
stekum Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Mona,

did not use the template, but it is exactly the same two step flow i was putting together ...

Thxs

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

Like
a
(0)

Report
Copy link

Link copied!

Hi stekum,

Have you tried to create a new flow to test?

Mona

Was this reply helpful? Yes No
stekum Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Yes i have tried this

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

Like
a
(0)

Report
Copy link

Link copied!

@v-monli-msft Hi Mona, what would be the best process to be able to successfully run that suggested flow? I have a SharePoint List that I imported into SQL server. However, the flow is asking for a Row ID for the SQL Server. The Row ID's of the imported data are 1,2,3,4..etc while my SharePoint ID numbers are 175,176,177, etc. When I update my SharePoint list, I was assuming that the ID from SP and the ID field from SQL would be used to update the SQL row. How can I fulfill the Row ID requirement?

Was this reply helpful? Yes No