A brief description. I have a Flow that is triggered by an incoming email on a shared mailbox. In the subject line is some identifying inoforation related to the attachment but also to a SharePoint list. The Flow should accomplish two things:
No problem on the first item, but I am stumped at how to locate the appropriate item in the ShaerPoint list so I can get its ID to do the update. I tried Get Items and for ODATA in the advanced section, I tried Title Eq varTitle where Title is in the SharePoint list and varTitie is created in earlier Flow steps from the parsed information in the subject line. I get a failure on this Get Items step.
I was unsure of how this might work when I created the step as Title is not yet a "known" dynamic field since the list isn't yet accessed; I just manualy typed it as an expression in the filter field.
I just need the ID of the item in the list to update the record. ANy suggestions, I HOPE!!!!
Solved! Go to Solution.
You could save the parsed information in the subject line of the email in the Compose firstly, and the you could get all items of the list which reflects if the attachment was received with a ODATA in the advanced section as screenshot below:
Note:The output dynamic content in the Filter Query field is the output dynamic content of the Compose.
Have you had an opportunity to apply @v-yuazh-msft‘s recommendation to adapt your Flow? If yes, and you find that solution to be satisfactory, please go ahead and click “Accept as Solution” so that this thread will be marked for other users to easily identify!
Thank you for being an active member of the Flow Community!
Flow Community Manager
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!
We've given our badges an overhaul and also added some brand new ones!
Learn how to build the business apps that you need.
Find out where you can attend!
Watch & learn from the Power Automate Community Video Gallery!