Unanswered

Group missing from list of locations (Excel)

(0) Share

Report

Posted on by Hyzerberg

I'm trying to "Add a row into a table" in my Flow. The Flow is triggered by a response being submitted to a Form. I need to add parts of the response to a spreadsheet in one of my Teams. When I click on 'Location' only 6 of my 17 Teams are in the list showing as "Group - {Team name}". I'm an Owner in all of these Teams.

What do I have to do to ensure my Teams will show up in this list?

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

efialttes 14,756 on at

Like (2)

Report
Hi @Hyzerberg !
Not even displayed as a Sharepoint Site, right?
As a workaround, I guess you can open any channel in your target Teams, select 'Files', next 'Open in Sharepoint'...
...so your browser will open the related Sharepoint site. Now inspect its URL. As I am doing this, since my target Teams name is MSFT, the URL looks like this:

https://myTestTenant.sharepoint.com/sites/MSFT/Shared%20Documents/Forms/AllItems.aspx?RootFolder=%2Fsites%2FMSFT%2FShared%20Documents%2FGeneral&FolderCTID=0x0veryLongId

Next, locate your TEams name and shorten the URL by removing the rest of the caracters onwards, ie.

https://myTestTenant.sharepoint.com/sites/MSFT/

Now back to Power Automete. Scroll down the options displayed in Flow 'Location input', select the very last one 'Enter custom value', paste the sohrtened site URL and press enter
Now you will be able to navigate through your site and find your target file:
Hope this helps!

Was this reply helpful? Yes No
wskinnermctc 6,519 Moderator on at

Like (1)

Report

If you scroll down the list, do you have more options.

So something like

OneDrive for Business

Group - {Team name1}

Group - {Team name2}

SharePoint Site - {SiteName1}

SharePoint Site - {SiteName2}

Are they in one of the sharepoint sites?

Was this reply helpful? Yes No
Hyzerberg 45 on at

Like (1)

Report

Thanks so much! That worked great!

Was this reply helpful? Yes No