Power Platform Community Forum Thread Details

Hi guys,

I have a flow that interacts with a button within a PowerApp. Essentially it triggers with the push of a button and all it is supposed to do is to get items from an sp list, insert these to an excel file in onedrive and then send this as an attached file in an email.

I sort does work fine, however it only sends some of the entries within the excel file??

Here is a picture of the entries within the excel file as it is when opened in onedrive:

Faktisk liste i onedrive.PNG

And here is a picture of the entries within the excel file that i receive on email:

Mail modtaget.PNG

So the issue at hand is that it chooses to send the excel file in a incomplete manner, and only attach the first entry.

Does anyone know a way of resolving this rather weird issue?

Here is a picture of the flow, just for reference:

Flow for print.PNG

Thanks in advance.
- Tobi 🙂

Categories:

General topics

HI @Anonymous

If I understand your screenshot correctly, you're fetching information from 2 SharePoint lists (can be the same list I can't tell by the screenshot) and cycling through the items. Then you fetch the Excel's metadata and list the rows and then send it.

The issue must be in one of the "For Each." Are you doing two on purpose? You only mention 1 SharePoint list in your question. That's why I'm asking. In the "For Each," you're doing an "Add row" or doing something else?

Another possibility is that a different file is being appended in the email. Since you don't create any file, you're probably using the same file always to send the information. If this is the case, you can also send a link to the file and avoid issues altogether since the file will always be up to date. To do that, use the "Create share link by path" and you're good to go.

Makes sense?

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel