Good day,
I would like to use the search and replace function for data tables in Power Automate Desktop.
I used the function to create tables out of a PDF file (Extract PDF Tables)
The variable of the extracted file now contains several entries with the pages that contain different tables.
What I want to do is Power Automate to search through the whole pdf tables stored in the variable and list me the row of a special entry that I want to look up.
I tried to create a for each function that iterates through the different pages/tables created in the value.
However if I enter the search function inside the for each function and using the %CurrentItem.DataTable% variable as data table source Power Automate tells me tha the parameter %CurrentItem.DataTable% may not have a space at the end...
How could I easily search through my entire ExtractedPdfTable variable for a certain value and get the row (and of course) page to where the value is standing?
Thanks for your help! That's kind of how it looks (I will improve naming later):
