Hi all,
I'm looking for a steer in the right direction if someone can help. I'm new to the power automate desktop software but am learning fast.
I have a data table with extracted PDF text which is parsed down to matches. I'm then looking to find the contents of a cell BELOW a cell with fixed information.
So essentially I have a cell that reads "Equipment type" and the cell directly below is what I need. This cell data is never the same.
I think the find and replace function is what I need to use but can't quite workout how to use it to store the cell below the header as a variable for the use I have in mind further down the flow. I think a regular expression is needed but I'm not good with them.
Here how my flow is currently:
I've googled this mercilessly but haven't come across a solution to this.
This is the closest thing I can find and it's not even that close to what I need.
Any help at all would be appreciated.
15
Share
Report
All responses (
Answers (
