Have sharepoint sites that do not show up in power automate

(1) Share

Report

Posted on by Community Power Pla...

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

Categories:

General topics

I have the same question (0)

All responses (12)

Answers (1)

Verified answer

rsaikrishna

3,703 on at

Like (7)

Report

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

Was this reply helpful? Yes No

Community Power Pla... on at

Like (0)

Report

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.

Was this reply helpful? Yes No

rsaikrishna

3,703 on at

Like (0)

Report

@Anonymous

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

Regards

Krishna Rachakonda

Was this reply helpful? Yes No

ThomasRathCGIDK 54 on at

Like (20)

Report

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.

1 people found this reply helpful.

Was this reply helpful? Yes No
JulioUnB 4 on at

Like (0)

Report

This solution really helped me. Thank you!

Was this reply helpful? Yes No
bryanrubink 5 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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

Was this reply helpful? Yes No
drupalgirl 6 on at

Like (0)

Report

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

Was this reply helpful? Yes No
farmania 3 on at

Like (0)

Report

OMG! this worked. Thanks a ton Thomas!

Was this reply helpful? Yes No
JosephCyclone 3 on at

Like (0)

Report

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!

Was this reply helpful? Yes No