Have sharepoint sites that do not show up in power automate

[Anonymous]

I have sharepoint sites that are not appearing in the dropdown of site in power automate.

I am the owner of the sites and they are subsites

the address look like this

https://cjenkinsbell.sharepoint.com/apps/NBP

https://cjenkinsbell.sharepoint.com/apps/JDI

The sites that are listed are

any insite would be appreciated. i am new to flow and sharepoint

[rsaikrishna · Accepted solution]

@Anonymous 

There are multiple reasons for this. Sometimes, your SharePoint connection in the flow not refreshed.

If you think you have access, you can click on "Enter custom value" option and enter your site URL. It will take it. The connection will also refresh sites associated with this connection.

URLs:

https://cjenkinsbell.sharepoint.com/apps/NBP

https://cjenkinsbell.sharepoint.com/apps/JDI

Give a try and I am sure it will work.

Regards

Krishna Rachakonda

If this reply helped you to solve the issue, please mark the post as Accepted Solution. Marking this post as Accepted Solution, will help many other users to use this post to solve same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone.

[Anonymous]

Thanks for the reply. This worked to enter as custom value and i was able to select lists from the sites.

Thanks again for the help.

[rsaikrishna]

@Anonymous 

Great to see the reply helped you. Can you please mark the reply as Accepted Solution?

Regards

Krishna Rachakonda

If this reply helped you to solve the issue, please mark the post as Accepted Solution. Marking this post as Accepted Solution, will help many other users to use this post to solve same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone.

[ThomasRathCGIDK]

I was having the same issue with sites not being listet. I was not even able to enter it as a custom value. I still got the error message that the site coould not be found. I saw a posting that this list of sites are actually not a full list but just the recently used.

I tried navigating to the site which I did have access to. This made no impact on the list of sites in the trigger action.

I then tried uploading a file to the documents library on the site.

BANG! That solved the issue. I was now able to see the site in the list of sites and select it.

[JulioUnB]

This solution really helped me. Thank you!

[bryanrubink]

Uploading a file to the site and then recreating the connection got it to appear for me.   Genius!  Thanks so much for this, 1.x years later!

I have two accounts - my normal use account, and then a service account which is fairly new and almost unused.  It kind of makes sense that the list would be the sites you're actively participating in with that account.

[Anonymous]

Hi Krishna,

I was able to add my missing site using the custom add field, but the trigger gives an error when I try to save it that seems related to the site not being listed: Flow save failed with code 'DynamicOperationRequestClientFailure' and message 'The dynamic operation request to API 'sharepointonline' operation 'GetTable' failed with status code 'NotFound'. This may indicate invalid input parameters. Error response: { "status": 404, "message": "List View Not Found\r\nclientRequestId: 344c9956-6b5b-409a-8040-8e10b6ecc07b\r\nserviceRequestId: 344c9956-6b5b-409a-8040-8e10b6ecc07b" }'.

The error suggests the list on the site cannot be found, which seems like the site cannot be found. Do you have any suggestions for fixing this?

Thanks,

Gail

[drupalgirl]

Thanks Thomas! Your solution is what worked for me!  So weird but works! 🙂

[farmania]

OMG! this worked. Thanks a ton Thomas!

[JosephCyclone]

Had this same problem and literally 2 years later, almost to the day, this solution worked for me! If you're still monitoring this, thanks ThomasRath!

[ThomasRathCGIDK]

Happy to help 🙂

[mshoseini]

Thank you for sharing your solution. I think there is no need to upload any file in the missing site but you only need to open the missing site using your Flow connection account.

Best,