Dear Flow Guru,
I was stuck in the step to retrieve data between 2 SP lists as below:
1. MasterData which has ID & name column:
2. DetailData which has a copy from MasterData ID value and other data value:
when complete a flow as see below, the value i received is duplicated as i knew because of the loop. But I couldnt find a better way to get data like:
Hi @huuthang ,
What trigger is in fact your trigger "SharePoint - When an item is requested" ? I'm not familiar with this one ...
Here is my thoughs:
after that you can use the results of Create an HTML action to the email body.
Hope it helps !
Hello @gabibalaban ,
Thanks for your input. However, I need to provide more detail for your understanding. I have 2 SP Lists named:
Ex: I create a new item in SP list Product_requisition_master:
After submit this request --> the 2nd SP list will be created detail values:
when an item is created which i trigger the SPlist Product_requisition_master
Get Items which i trigger SPlist Product_request_details
and the end of the flow what i want to get is the detail of each request:
request_by: trinh, thang
Prod_code | Prod_description | Quantity
1212 | qwww | 13
1212e |sshsjs | 13
My presumption was correct, the sample that I sent to you is what you need, BUT ...
I think you need to reconsider the scenario, because most probably your flow will be riggered before or during the new items creation in Product_requisition_details and the detail list might be incomplete (containing only the data written in the list at interogation time).
How you choose to create the detail items ? Using the SharePoint form ?
Dear @gabibalaban ,
I fixed my issue now as it is very simple technique as i dont need to create a loop for each item a new user create new item 🙂 .
To answer your question: I created a powerApps to create product details. Once user create item, data will Patch to the SP list "product detail".
By the way, I'm glad to discuss with you. Thank you
Check out new user group experience and if you are a leader please create your group
May the fourth be with you, join us online!
See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.
ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.