Dear fellow builders and experts,
I have been trying to update our workflow by getting our orders into Forms instead of emails. Right now we have our orders send by email, which triggers a flow that collects the attachments and creates a task with the attachments as files, not as a link and we like that very much. However, we still need to edit and update every order by hand.
Now, in the ideal situation, this is what I want:
The order is made through Forms. That information is stored in Sharepoint, and then a task is created with attachments as files, the due date and a single label all from information gathered from the forms input.
Right now I have 3 different flows that each can do part of it, but I can't seem to be able to connect it or gather it into one or two flows.
Flow 1:
From Forms input an item on Sharepointlist is created.
Flow 2:
The Sharepoint item triggers an email being send with the attachments, the information on the list in the body of the e-mail and then from there creates a task on our planner with the attachments as files and the body text in the description on the task. However, here I can't use the Sharepoint input to update the task with the given due date (forms input) and a label.
Flow 3:
When I create the task from the Sharepoint input, I can automatically add due date, priority and one label through conditions. (please replace the sharepoint trigger here with the original created information - I have a screenshot from another which is working but didn't get other results I wanted).
Is there any way to combine this into one or two following flows that create the desired outcome?
I hope anyone can help me out.
Kind regards,
D.