web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Power Apps to Automate...
Power Automate
Suggested Answer

Power Apps to Automate create a new Excel file.

(1) ShareShare
ReportReport
Posted on by 8
hello, 
 
Im trying to achive teh followingHello,

Im trying to achieve the following;
 
  1. Trigger - Button in power apps.
 
  1. Gets items- Gets information from a Sharepoint list.
 
  1. Filter- Filters information based on the Task name currently selected in a Combi Box or the items displayed in the gallery.
 
  1. Gets content- Gets the table format etc from an existing excel spreadsheet, basically uses it as a template.
 
  1.  Create file – Creates a new excel spreadsheet with only the rows of information for all items related to that Task name and saves in a document library
 
  1. Send – Emails that off to email list.

I have no idea of how to do the filter. What I’ve done is ;
 
  1. When the button runs it patches a column called “Collection” with a true value.
 
  1. The condition then looks for that true value in “Collection” and a false value in a column called “Sent”
     
  2. Then when I do the send email part I’ll run an update SharePoint list, and it will add a false value into “Sent”
This isn’t what I really want it to do I just want it to run and check for all lines in the Sharepoint list that contain the Task Name selected in the power app.

Either way I’m having issues with excel part actually creating an Excel file that can be read.

Please understand I am Novice so have no clue unless it’s simple like get an item add row etc in power automate.

If needs a JSON or a Variable I wouldn’t know what I need to write and where it goes in the flow.

i have tried doing a collection in the gallery then doing a flow based on collection but because i have filters on my gallery comes up with an error. (Collection video-
https://www.youtube.com/watch?v=hIDRup4LcHE - Automate video -https://www.youtube.com/watch?v=ciskd4ryWUQ
Categories:
I have the same question (0)
  • Suggested answer
    Michael E. Gernaey Profile Picture
    53,429 Super User 2025 Season 2 on at
     
    Let's back up just a little. You said good stuff at first (described wonderfully) then you said
     
    I have no idea of how to do the filter. What I’ve done is ;
     
    I am going to skip everything else you said because it gets confusing and detracts from what I think you want.
     
    You want to filter your Get Items to only grab all lines in the Sharepoint list that contain the Task Name selected in the power app
     
    what I do not know is what is the name of the column, or the data type of the column that has this task name.
     
    But what you want to do is this
     
    1. Make sure your Trigger is the V2 power app trigger NOT the V1 (which I think you used)
    2. In the trigger add a Property (string) and call it TaskName
    3. in your Get Items, click on Advanced so you can see the filter section
     
    What you will notice is the following
     
    I typed FieldName, this is because I do not know what you called the Column in SharePoint
    If its TRULY called Task Name then put [Task Name] since there is a space
    then type eq (for equal)
    then put '' single quotes
    Click in between the single quotes so the popup window appears
    You will see the TaskName property I had you create
    Click it
    and not in between the two ''
     
    and done
     
    Now it will fitler properly Assuming you put the right FieldName in
     
    :-)
     
    If this helps please Mark my answer as such and maybe a like.
     
    P.S. But what if you aren't sure of the name.
    Go to your list in SharePoint
    Click the COG (to right) and go to List Settings
    Scroll down to the fields
    Click on the Field name Task whatever
    This will open the Properties page for that Field
    LOOK at the URL (yes the URL) at the end of the URL will be the ACTUAL name of the field.. make sure you use that.
     
  • SA-22041514-0 Profile Picture
    8 on at
    Afternoon @Michael E. Gernaey so ive done the below and this is what im getting back an error. 
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 501 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 323 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard