Answered

Add items to a sharepoint list from SQL

(0) Share

Report

Posted on by Valerio

Good morning,

I am trying to update a sharepoint list, adding items contained in a SQL table.
I can't set the cycle with the correct values, can someone help me?

Thanks

Valerio

Categories:

Building flows

All responses (9)

Answers (1)

Sort by

Mira Ghaly 11,415 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@Valerio
What do you mean by cycle?
Can you share screenshots and elaborate more?
Valerio 12 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Mira,
I mean a for each.
I used a "get rows" and would like to create an element for each row retrieved from the SQL table.
Thank you
Mira Ghaly 11,415 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@Valerio
What you are placing in the screenshot is correct what is the issue you are facing?
Valerio 12 on at

Like
a
(0)

Report
Copy link

Link copied!

I don't know, now it works: D

but i have this problem:
The parameter with the value "" @items ('Apply_to_ each')? ['DATE_CONTRACT'] "'in path' item / DATE_x0020_CONTRACT 'with type / format' String / date-no-tz 'is not convertible to type / format" String / date-time ".".

could you help me?
Mira Ghaly 11,415 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@Valerio
Try to format the date as expression in place of setting the field directly.
formatdatetime(@items ('Apply_to_ each')? ['DATE_CONTRACT'] ,'dd/MM/yyyy')

If this post helps you with your problem, please mark your as Accepted solution.
If you like my response, please give it a Thumbs Up.
MG (Naturally Curious)
Verified answer

v-alzhan-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Valerio ,

Please add a Compose action before the create item action to save the DATE CONTRACT dynamic content from the SQL server and share the output of the compose with use so we could better understand the issue on the date.

Please make sure the date should be date time as below:

yyyy-MM-ddTHH:mm:ssZ

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Valerio 12 on at

Like
a
(0)

Report
Copy link

Link copied!

Good morning,
sorry for the delay, I solved it by simply entering the date in SQL as a string.
Now I'm updating the flow to update the list if there have been any changes and to add the new items

Can you see any errors?
The execution is successful, I do not get an error but the rows are not updated and or inserted
Thanks so much
Mira Ghaly 11,415 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@Valerio
HAve you opened the history run and followed it to check what might gone wrong?
Valerio 12 on at

Like
a
(0)

Report
Copy link

Link copied!

yes, I solved
Grazeie