Use Power Automate with Survey123 and SharePoint

[BenBlowers2]

Hello,

I am trying to use Power Automate to create a report when a survey is submitted and upload it to a SharePoint document library. I have got it working with OneDrive, but it would be better if the documents could be uploaded to SharePoint instead - because SharePoint is business central whereas OneDrive for business is personal to each staff member.

I am stuck on the last step, uploading the file to SharePoint. I am choosing the "Create file" action (the second one in the dynamic content list, as the 1st only seems to be able to upload to SharePoint lists and not document libraries):

Site Address - fine no problem (just choose from the list)

Folder Path - fine no problem (just choose from the list)

File Name - fine no problem (name of the first result file)

File Content - help! What should I choose here? I have tried many of the dynamic content options, but they just end up in an unreadable PDF when I test the flow.

Thanks all,

Ben

@IsmaelChivite - do you have any idea?

[IsmaelChivite]

Sorry @BenBlowers2  I struggle quite a bit with the Sharepoint bits in Office 365. I have not tried this myself, so I am not sure, but I think this could work:

• Upload the file to OneDrive
• Use the get content from path operation. Here is more info: https://manueltgomes.com/reference/power-automate-action-reference/get-file-content-using-path-actio... 
• Pass the content of the file to the Sharepoint Create File action
• Delete the file from OneDrive

Yes, it looks ugly. I am not sure this is the right way to do it. Some digging in the Power Automate forums should give a better answer.

[BenBlowers2]

Thank you for your reply @IsmaelChivite - I will check that out but if anyone else spots this and has a more direct route to SharePoint - I would be forever grateful!

[CharlesRobbins1]

Working the same process and please let us know if you made any progress.

[santamariaa]

We still see this issue and the work around @IsmaelChivite described does work.

[DustyJordan]

I also currently have my feature reports dumping to OneDrive, but would prefer Sharepoint. Has anyone else figured this out, or is the S123>OneDrive>Sharepoint work-around still the way to go? 

[CarlisleHaworth1]

Hi Ben,

You may have moved on from this task, but in case others are following there is now a way to send a feature report directly to Sharepoint, bypassing the use of OneDrive, however it requires the use of the HTTP connector which is a premium connector. This is used it to grab the contents of the feature report from the url generated then you dump the contents of the url directly into sharepoint:

Here's how to setup the HTTP action, just point to the resulting url of the Create Report output, and be sure to use the GET method

And the Sharepoint Create File action is setup as follows, pointing the File Content to the Body of the HTTP GET action:

hope this helps, it's unfortunate it requires a premium license as this took me 2 or 3 years of groveling to obtain.

[jzibbell_boise]

@CarlisleHaworth1 I too had to grovel for premium access! I followed your instructions but am ending up with an odd file type. Any suggestions 

[CarlisleHaworth1]

Hi @jzibbell_boise. What file type are you seeing? Can you provide the suffix of it? Is the report being created correctly in AGOL? And also can you also show how your HTTP action is set up? 

[jzibbell_boise]

I ended up using this hack. Yes the report is being created in AGOL. I had set it up exactly as you did with "GET" populated but nothing else. I have it deleted now, not sure what the extension showed.