How to add a new row to a Microsoft 365 worksheet saved in Sharepoint

How To
1

Hi there Make community,

I have a survey 123 set up and want to add a new row to a Microsoft 365 spreadsheet every time a record is submitted. This was easy enough to set up with Google Sheets. I used the template. I have also started using the S123 and Microsoft 365 add a row to a worksheet spreadsheet, but then got stuck because the spreadsheet is in Sharepoint.

I’ve got a Microsoft 365 business login. I can see the excel document I have in My Drive, but I can’t figure out how to save/access it in Sharepoint.

Some questions I have:

  1. Should I be using Microsoft 365 Excel or Sharepoint to access/write into the spreadsheet or both?

  2. In the Microsoft 365 Excel app what is Site’s Drive and Group Drive?
    image

  3. Where do I find my Group or Site ID?

    image
    image560×673 37.9 KB

  4. Why am I getting this error?

    image
    image514×648 36.1 KB

Some extra info.

The Excel spreadsheet is in a secure channel which I have access to. That secure channel sits within a team.
image

Can Make only write into Microsoft 365 Excel spreadsheets that are created in Microsoft 365? Not in desktop excel? Does it have to be a certain file format?

Thanks in advance for your help!

3

Hi @Lindsay ,

As far as I know, this limitation seems to be coming from “Sharepoint” since Microsoft does not allow files stored in SharePoint to be accessed by external services, which is what is happening here.
​
I’d suggest having the file on a cloud service like Dropbox or OneDrive.

2 Likes