Hello,
I am trying to Lookup other files that will have random patients names and only focus on the files that have "Sharepoint list" which is my data source in their file name. I though the way to do this is by naming the files and say in Power Query the "PatientName".
where patientdetails is my sharepoint list name
LookUp(
PatientDetail,
PatientContact= DataCardValue54.Text
).PatientName
