Flow Error at Get Attachments

[SMiller3]

I'm a bit of a newbie to power automate.  I've created a flow that is supposed to send an email with attachments whenever a new item is added to a sharepoint list using power apps.  I used the Integrate - Power Automate - Create a flow from my Sharepoint list and then edited the resulting flow.  (As an aside and a different issue, when I tried to create the flow from within power automate, it did not automatically list the list name and I had to add URL with custom value.  But then dynamic content would not appear).

Today, I am asking for assistance with getting attachments to send with email.

Flow steps:

My flow fails at this point:

Key: 

Cache-Control

no-store, no-cache

Pragma

no-cache

Set-Cookie

ARRAffinity=f9874cfcec5b209c3abef41406e1b5ce057493cc5d949e7c78aaa4e7d5a7ddf1;Path=/;HttpOnly;Secure;Domain=sharepointonline-eus2.azconn-eus2-004.p.azurewebsites.net,ARRAffinitySameSite=f9874cfcec5b209c3abef41406e1b5ce057493cc5d949e7c78aaa4e7d5a7ddf1;Path=/;HttpOnly;SameSite=None;Secure;Domain=sharepointonline-eus2.azconn-eus2-004.p.azurewebsites.net

x-ms-request-id

275fc1a0-604e-3000-b18e-1a57df011c93

Strict-Transport-Security

max-age=31536000; includeSubDomains

X-Content-Type-Options

nosniff

X-Frame-Options

DENY

Timing-Allow-Origin

*

x-ms-apihub-cached-response

true

x-ms-apihub-obo

false

Date

Wed, 28 Jun 2023 20:50:29 GMT

Content-Length

716

Content-Type

application/json

Expires

-1

Body:

{

  "status": 400,

  "message": "The expression \"web/lists/GetByTitle('https:/natpub-my.sharepoint.com/personal/xxxxx_xxxxxxxxxxxx_com/Lists/Domestic Damages Log/AllItems.aspx\" is not valid.\r\nclientRequestId: 042f4375-0757-4cfc-9478-9e38b3c706ab\r\nserviceRequestId: 275fc1a0-604e-3000-b18e-1a57df011c93",

  "source": "https://xxxxxxxx.sharepoint.com/sites/xxxxxxxxxxxxxxxxx/_api/web/lists/GetByTitle('https://xxxxxxx-m...",

  "errors": [

    "-1",

    "Microsoft.SharePoint.Client.InvalidClientQueryException"

  ]

}

And the error details:

I have tested this flow many times and works without attachments.  When I add steps to add attachments to email, it fails.

Any help or hints would be greatly appreciated.

TYIA

[developerAJ · Accepted solution]

your list name is wrong

https:/natpub-my.sharepoint.com/personal/xxxxx_xxxxxxxxxxxx_com/Lists/Domestic Damages Log/AllItems.aspx

you will be able to select Domestic Damages Log

if you are giving the cutsom value. go to list settings check the url at the end you will have a guid value use it .

Please click Accept as solution and give it Thumbs Up if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

You can connect with me on LinkedIn

[SMiller3]

Thank you for responding.

I went to list settings and see the URL by web address at the beginning.  It is the same as what I had before.  

I'm sorry, but I'm really new at this and not clear on what I should do.  Could you provide steps.

[SMiller3]

Also, I did try copy paste the web address from settings into custom value and the result was the same.

[SMiller3]

It worked!  It was actually the site address that was incorrect.  It was pointing to my employer's environment instead of my private environment where the list is stored.  

However, that revealed another problem at a further step, which I will post separately if needed.

Thank you!!

[developerAJ]

Glad you figured out the solution