I'm looking to pull rows into a "temporary list" from 2 SharePoint lists based on a column's value within these two lists. Lets call list 1 the Current Tests and the 2nd list the Completed Tests, the Current Test list's column is a lookup column and the Completed Test list is a multiple lines of text column. These two columns both have similar values that are required to be pulled in cases where the value in these columns become unknown.
Ideally the value that we are searching for can be entered along with the date to then pull all the rows from the 2 lists that match the value along with it being in range of the date.
It would be a plus if this "temporary" list's rows can be edited and saved back into their lists
Im currently using SharePoint online and open to using flow or power apps.