Announcements
Hi,
I have extracted a value from an email when received and now want to search a spreadsheet for that value and then once found, return the corresponding value from the same row in a different column, any advice would be great.
Thanks,
@scodyWF Assuming your Excel data is in a table, you can use "List all rows" to get the data of the table into Power Automate and then use "Filter Array" to find the array object corresponding to that row.
That's great, thanks for the help.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Vish WR 796
Valantis 568
Haque 538