cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Getting specific rows from excel

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

3 REPLIES 3
Community Support
Community Support

Hi @Anonymous,

 

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:

Allow "For Each" to execute in sequence, not parallel

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:

Office365.SendEmail()

Reference: Office 365 Outlook connection in PowerApps

 

If I have any misunderstandings, please let me know.

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

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__?

 

So logically:

  • When new item updated from list
  • Get ID column from list
  • Get corresponding row from Excel where list_ID=Excel_ID

 

In the above, flow appears to only allow for 

  • Get corresponding row from Excel where __powerappsid__=?

 

At this point I'd be happy to send multiple emails and work on that problem, but I'm not even that far yet.

Anonymous
Not applicable

Hi @v-micsh-msft,

 

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?

 

Legacy-7369e6ec-faa6-42fa-bc0e-4f332da5b1db/flows/b2cb0742-c170-4af7-a733-5a34385ef740

 

Kind regards,


R

Helpful resources

Announcements
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (9,152)