You’re offline. This is a read only version of the page.
22
I have three sharepoint lists;
1. customer - key column = uniqueFactoryNumber*
2. machine - 2 key columns = uniqueFactoryNumber* + uniqueMachineNumber**
3. machinePart - key column = uniqueMachineNumber**
The items in the sharepoint lists are filtered/mached with the key columns
Now i am trying to create a word document whenever a new machinePart is created or when an existing machinePart is edited.
My flow looks as follows;
Step1: When an item is created or modified in Sharepoint
List: machinePart
Step2: Get Items
List: machine
Step3: Filter Array
uniqueMachineNumber from List: machine = (equal to) uniqueMachineNumber from list: machinePart
Step4: Get Items
List: customer
Step5: Apply to each: Filter Array2
uniqueFactoryNumber form list customer = (equal to) uniqueFactoryNumber from list machine
Step5: Apply to each:
Populate Word Template --> Has data from all three lists.
Create file --> File name: ID.docx / File Content: Word document/Body --> Word file has been created and is working!
Result: When i create a new machinePart in PowerApps, a new item is patched in Sharepoint. For the new machinePart, a Word document is created for all existing customers for that newly created machinePart. Example:
Customer1 : machinePart55
Customer2: machinePart55
Customer3: machinePart55
Customer4: machinePart55
Customer5: machinePart55
And so on.
However the required result, has to be.
For customer4, machinePart55 has been created / end!
What am i missing to achieve this?
I have an extra question. My sharepoint lists have been changed a few weeks ago.
Old name Customer details (changed to) Customer
Old name Device location (changed to) machine
Old name Device detailed points (changed to) machinePart
In PowerApps flows in all steps only list names Customer details, Device location and Device detailed points. This is particularly strange, because the old names do not exists any longer. Where can i change this?
Share
Report
All responses (
Answers (
