Hi,
I am trying to build an app, which receives the order from the customer (for multile items) and then send an approval email and once approved, update in sharepoint list.
I tried creating a list in sharepoint first, then used it to create app and then created a flow, everything seems working fine but, I can update only item to the sharepoint list at a time from the app.
Cusotmer will place order for multiple items at time. So is there a way to create ap, which can take multiple item orders and then send an approval email and then update the same in sharepoint list.
Thanks,
Hi SurendharV,
I guess you have a flow to send approval email when an item is created in SharePoint list.
However, as far as I know, currently the flow runs when an item is created, so it might be not possible to take multiple items at a time and send an approval email.
May I suggest you submit an idea at Flow Ideas Forum, hope PGs will take it into consideration in the future releases:
https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas
Best regards,
Mabel Mao
Thanks for the reply, I did raise the request.
One more thing, I checked out few tempaltes from Powerapps, One particular app ( Invoice Management) is similar to my expectaion, but then it uses Common Data Service to strore data. What I need is similar to that, but to do in Sharepoint list.
Hi,
Not sure if this will help you entirely, but I have had a similar scenario for creating multiple items for one order placed by a user, except that I didn't need Flow.
I have managed to achieve this by collecting each item at a time in a collection, and then using ForAll and Patch to submit the items to the SharePoint list.
Let me know if you need more details 🙂
Cheers,
MelindaK
Hi MelindaK,
That would work for me. Kindly let me know how to do it, as I am a novice here. Thanks.
So in my case I have created a screen where I have used dropdowns and text boxes to create a custom form (not the default form from Edit items from SharePoint list). Here I have an "Add to Order" button which collects the information from each control and puts it in a local Collection. I achieve this using the collect function on OnSelect:
Collect(Collection_Name, {item_name: item_value, ...}); - where I have an item for each column in the SharePoint list
Once the user is happy with the order, it will press next to go to the submit screen when I am displaying the items from the Collection using a Gallery so that they have a visual indication of what they have selected to order and once they are ready they press the submit button which uses the For All and Patch functions on OnSelect:
ForAll(Collection_Name, Patch(List_Name, Defaults('List_Name'), {column_name: item_name, column_name: item_name, ..}); - where the column_name is the SharePoint column internal name and item_name is the item name from the collection.
Once the items are created I call the Clear(Collection_Name) function to clear the collection.
Be aware that it does take some time to submit the items, for me it takes about 40-60 seconds to submit 4-5 items.
EDIT: I have remembered that I have also found the solution by asking the question on the forum, have a look at that as well:
Hope this helps 🙂
Hi,
Thanks.Was able to update the sharepoint list, with ur reply. But still trying to figure out a way to send approval email. If i send approval email each item an item is createdin sharepoint list,then it will be a lot of emails at once.
Hi,
I'm glad you have managed to do it. Unfortunatelly, I don't know any solution for sending your emails :(.
Maybe someone else around here will be able to help you.
Regards,
MelindaK
User | Count |
---|---|
142 | |
137 | |
78 | |
73 | |
70 |
User | Count |
---|---|
226 | |
137 | |
78 | |
61 | |
56 |