Hi,
Its been a while since ive played around with Flow and im stuck building a follow on flow
I have built a flow using a recurrence as a daily trigger to check if a Date column in a SharePoint Asset Register List is 90 days due from expiring and then create an item in a Work Order list with the Asset Register unique Asset ID text column and put 'Yes' in a InspectionDue choice column (This flow works)
Then i wish to have another flow also using a recurrence as a daily trigger to check if a Date column in a SharePoint Asset Register List is 30 days due from expiring and then check if there is already an item in the Work Order with this unique Asset ID text column and with the choice column called InspectionDue equal to 'Yes' and update the work order and if not then create a new work order,
This is my current flow,
If i put the update item in yes box in the last condition (condition 3) it updates the correct item,
however if i put the create item in the no it creates other several other incorrect items.
The first condition is
length(body('GetAsset')['Value'])
is equal to 0
I know i have all the right pieces here i just cant for the life of me remember how to do it, if i add another Odata filter query to the GetOpen such as Asset eq 'Asset' or in the first condition i get errors, i assume because there are several other Work Orders with the same AssetID and possible other assets 30 days due?
Im sure it has something to do with apply to eachs or the condition however i tried all my combos i could think of?
Could someone please have a look?
