Power app - to excel template

(0) Share

Report

Posted on by SA-22041514-0

I currently trying to acheive the following:

Step 1 - User selects a task.

Step 2 - User inputs all information in a form.

Step 3 - Information is put into sharepoint list.

Step 4 - they repeat this as many times as required for that task.

Step 5 - User checks all the information in the gallery to the right of the form is correct(edit where required)

Step 6 - User clicks send button.

Step 7 - Button starts a automated flow.

Step 8 - Flow/App filters gets only the the lines with the current selected task in the power app.

Step 9 - it finds the excel template
Step 10 - It puts the lines into excel document
Step 11 - It saves the document in a document library.

Step 12 - It emails that document off to an email address.

Steps 1-5 I have completed, i'm struggling with how to filter the flow to only get the lines with the current selected task or lines from the gallery to go into my excel document.

I have attached images in a word document. Please also understand I am novice user I'm learning as I go.

Any help would greatly be appraciated.

Categories:

Connector development

20250424-Power ap...

I have the same question (0)

All responses (3)

Answers (0)

WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report

Hi @SA-22041514-0,

Probably the easiest would be to Patch a flag of some description to the selected record (a Text field with a Y or similar) and then filter on that in the Flow. After the Excel sheet is written, select the same records and clear the flag.

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
stampcoin 5,058 Super User 2025 Season 2 on at

Like (0)

Report

@SA-22041514-0 Hi,

What you need for passing your flow, is the ID of the Gallery1.Selected.ID ( for example), it has to be the same one from your sharepoint.

then you :

myFlow.Run( Gallery1.Selected.ID).

then you flow get the ID and use that to fetch your item from sharepoint.

there are other options, since you already did some in your flow. it might be quick for you.

Enjoy Power Platform and have a great day 🚀 | My LinkedIn

If the answer helps, please consider 👍, Thanks.

Was this reply helpful? Yes No
SA-22041514-0 10 on at

Like (0)

Report

@stampcoin so ive put in

Bidform.Run(Gallery1.Selected.ID) but shows as red line(Invalid number of arguments: received 1, expected 0.). Is there something else I need to do. As to me that is looking for a selected value in the gallery which there isn't its just what is displayed in the gallery.

Was this reply helpful? Yes No