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

I have the same question (0)

All responses (9)

Answers (1)

Mira Ghaly 11,409 Moderator on at

Like (0)

Report

Re: Add items to a sharepoint list from SQL

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

Was this reply helpful? Yes No
Valerio 12 on at

Like (0)

Report

Re: Add items to a sharepoint list from SQL

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

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

Like (0)

Report

Re: Add items to a sharepoint list from SQL

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

Was this reply helpful? Yes No
Valerio 12 on at

Like (0)

Report

Re: Add items to a sharepoint list from SQL

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?

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

Like (0)

Report

Re: Add items to a sharepoint list from SQL

@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)

Was this reply helpful? Yes No
Verified answer

v-alzhan-msft on at

Like (0)

Report

Re: Add items to a sharepoint list from SQL

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.

Was this reply helpful? Yes No
Valerio 12 on at

Like (0)

Report

Re: Add items to a sharepoint list from SQL

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

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

Like (0)

Report

Re: Add items to a sharepoint list from SQL

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

Was this reply helpful? Yes No
Valerio 12 on at

Like (0)

Report

Re: Add items to a sharepoint list from SQL

yes, I solved
Grazeie

Was this reply helpful? Yes No