I need a bit of general knowledge and avice here please;
I'm using SharePoint to hold items in a list.
I'm using Excel and OneDrive to hold an images spreadsheet and the images themselves.
The PowerApp creates the list item, updates the images spreadsheet and saves the images.
From what I've read, Flow uses the __powerappsid__ field to identify excel rows.
The Images and the Item are linked by the common ID field, which lets me group multiple images for each item and the __powerappsid__ is automatically generated uniquely for each image.
I want to create a flow that sends an email with the images attached whenever an item is created on the SharePoint list.
I'm pretty sure someone must have done this, but I can't seem to get anything useful on Google.
My initial thought was to trigger Flow off the sharepoint "new item", and then lookup all the images with the same ID field as the item ID field in SharePoint - but I can't filter Excel, and it seems to be looking only for the __powerappsid__ field to identify rows.
Now I'm stumped.
Am I thinking about this all wrong? Should me trigger be something else?
Thanks in advance
I think I understand your scenario.
The scenario is to send the Email through Microsoft Flow, with all the images associated with the same item ID field attached, right?
If you would like to filter the Excel row, we may take a try with the Excel-Get Rows action, then filter the result with a condition.
But if you would like to send One Email with all the images, I am afraid currently that is not available.
I will try to explain this.
As you already know, Microsoft Flow uses the "_PowerAppsId" to mark the Rows in Excel, and in your scenario, each row with a single image.
For multiple images with the same item ID, the result when query from Microsoft Flow should be an array.
And currently under Microsoft Flow, there is an Apply to Each available to work with each items listed in the array in parallel, but there is no feature available(that easy to use) to add all the items in one.
An idea already submitted on this:
So if we add an send an email action here, it will fire for each item within the array.
If only for one specific item (row), then we could take use of some condition to identify it, and use it in the folloiwng flow action (such as send an email).
In addition, as you save this all from PowerApps, would it be available for the app to send the email directly?
with the function below:
Reference: Office 365 Outlook connection in PowerApps
If I have any misunderstandings, please let me know.
Thanks Michael, that does explain a lot, but I still have a few gaps, like;
If I'm running from Flow, how would I get the Excel rows I'm looking for without knowing the __powerappsid__?
In the above, flow appears to only allow for
At this point I'd be happy to send multiple emails and work on that problem, but I'm not even that far yet.
I see the ability to run For Each in series has been completed - but I don't seem to be getting this flow working correctly.
Could you please assist?
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
Check out the community blog page where you can find valuable learning material from community and product team members!