Hello everyone,
I am designing a flow that will take input from two different MS forms and update the SharePoint list. First form will create the record in the list and fill half of the information in the list. The second form will only update the records in the list if there is a relevant field or already created item.
For the purpose mentioned above, I am using the 'Issue Tracking' app, which creates a unique identifier, ID. I am using this ID column to filter the item, to update the corresponding columns in the list.
I have prefilled the list with the first form and the current list has more than 10 records in it. Now I am trying to enter the data from the second form and I am having trouble to:
1- Filter the items from the array. The Filter is comparing each 'ID' from the list/ from the array to the user input- 'Accurate_ID' that user inputs from the form. I tested and it showed that filter is giving '[]' or empty result when it's comparing, ID=4 with 'Accurate_ID=4'.
2- Once before some tweaks, my loop ran and updated all the rows in the lists weather ID matched with Accurate_ID or not.
I would really appreciate if you can tell me what I am doing wrong and how I can fix it.
Thanks
