I'm new to Power Automate. I am wanting to create a flow that is triggered when a new email arrives, then uses the email address of the new email to look up an excel table of email addresses (and other data) and return the row that has that email address so I can use this later in the flow. I can't seem to get this to work, I've tried 'get a row' (pic below of the settings) and 'list a row' with a filter query using "From" (triggerOutputs()?['body/from']) but neither seems to work. I would really appreciate any suggestions or recommendations
Ensure that the Key Value does not have any training or leading spaces. The case should match as well.
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.