Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Answered

How to make some flows to get data from people external from my organization into a sharepoint list

(0) ShareShare
ReportReport
Posted on by

Hello everyone, 

 

Im trying to make some flows that do similar things of "smartsheet", for example, I have a sharepoint list with some approvals and due date items that depends of people external. And I can't share the default "form" of the list because is only for the members of my organization, not externals.

so, I have a recurrence flow to identify the next due date and modify a boolean item in the sharepoint list.

Diegohan23_0-1657561315514.png

After that, I have another flow to triggered when the list is modify and send an email to people external of my org as a remider of the due date. But here is the first problem, my wish is that in the same email, could send a form with some columns of the list to the external people for could update the info of the list and attach files. For the MS restrictions it's impossible. 

Diegohan23_1-1657561589016.png

So I tried to send a OneDrive link to replace this, and made a flow that triggered when a file is upload to the OneDrive and update the list, and at the same time send an email to me to notify that someone upload files of the specific item of the list close to the due date. But it doesnt work because I don't know how vinculate a OneDrive Path to a list item.

 

Is it possible to make some flows like this? exist an easiest way to make that? is sharepoint list te best way to make some of that? because I don't want to buy a smartsheet subscription for make that.  

 

I'll appreciate all your comments and advices for that.

 

Thanks!

 

 

 

  

  • v-jefferni Profile Picture
    on at
    Re: How to make some flows to get data from people external from my organization into a sharepoint list

    Hi @Diegohan23 ,

     

    Have you solved this problem?

     

    Best regards,

  • Verified answer
    v-jefferni Profile Picture
    on at
    Re: How to make some flows to get data from people external from my organization into a sharepoint list

    Hi @Diegohan23 ,

     

    You can leverage MS Forms to create a Form, attach the link in the Email for external users to fill up and submit, and then create another flow which is trigged by form response.

    https://forms.office.com

     

    Best regards,

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1