Updating lists on multiple Sharepoint lists

[roland-daane]

Hi,

I'm trying to loop through our Sharepoint sites, and update a list in each site.

When use the "add a row to Sharepoint List", I can't parametarize the URL: https://company-name.sharepoint.com/sites/XYZ

So I'll need a custom http action, but I can't seem to get it working.

Does anyone maybe have an example of creating a row in a sharepoint list with a custom http action?

I've tried to take the output of the action, and generate an input Json body, but that doesn't wotk.

{

"Title": "Test of Location Issue",

"Created_at": "2021-08-03T17:33:34.436000+00:00",

"Synced_at": "2021-08-03T17:33:34.440000+00:00",

"Updated_at": "2021-08-03T17:33:34.438000+00:00",

"Close_version": "",

"Closed_at": "",

"Closed_by": "",

"Created_by": "6KT9RN9BEN8H",

"Opened_at": "2021-08-03T17:33:34.425000+00:00",

"Opened_by": "6KT9RN9BEN8H",

"Updated_by": "6KT9RN9BEN8H",

"Starting_version": "",

"Issue_Description": "",

"Location_Description": "",

"Markup_Metadata": "",

"Tags": "",

"Due_date": "",

"Identifier": "3",

"Status": "open",

"Assigned_to": "YYRFPBLNZFA5",

"Assigned_to_type": "user",

"Answer": "",

"Answered_at": "",

"Answered_by": "",

"Project": "DoES Test Area",

"Issue_ID": "fc219cdd-7ee2-4bfb-8399-03ba1bcbe37a",

"Site name": "025556",

"List": "cf2a2f04-30e4-4c7e-9833-ae84ad89fa41"

}

[soumya-ghosh]

Looks like its just expects a HTTP post. I would just use a HTTP connector instead of using the sharepoint module. Not sure what is happening under the hood for the sharepoint connector.

[roland-daane]

That's what I'm trying.
If you use the Sharepoint Create List item, you can"t parametarize the site address.

Therefor I want to do an http post action, but can't get it to work.

Example provided is how to do this in Power Automate