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