Hi All,
So I am using PowerApps for the first time. I want to build an app that uses combobox & checklist selections to extract data from an excel database source into a new table with the output from those selections. I have attached some pics below to explain the process.
1. Make selections: In this step, I made the following selections.
2. Once I press submit, the app will filter out the excel table I have and "spit" out the result. So in this case, based on this selection, it should filter out the items in red in the next pic. It should not show me the items in yellow because these are "Holding locations" that I have no selected.
3. What I want to do is the following: (1) Make selections (2) Have the app filter the selections (3) Transition into a new screen on microsoft powerapps where a new table is displayed with the selections and relevant output information (in red).
I am having trouble doing this - could someone please help out? I am relatively new to PowerApps so apologies in advance.
H @Joliefallouh ,
You can do them as below.
ClearCollect(colResult,Filter(Datasource,columnname=ddl1.selected.columnname,columnname2=ddl2.seected.columnname))
if this answers your question mark it as verified and give thumbsup
Regards,
pavan Kumar Garlapati
Thank you so much! I did this and created a table on the screen screen. I have a couple more questions:
1) Some of the text in the table cells is too long so it gets cut off and I cant see it, is there a way I can fix it? (maybe like a scroll bar for height and width of the cell in addition to the one for the table?)
2) I am trying to export my output and used the collect function but i need to export it to an excel sheet / powerpoint slide, is that possible??
Thanks!
Hi @Joliefallouh ,
you can adjust the cell size of the table please check and adjust the properties until you are satisfied 🙂
At the moment we can't export files from powerapps however if required we can email it using Flows.
if this answers your question mark it as verified and give thumbsup
Regards,
Pavan Kumar Garlapati
Hi Pavan!
Thanks for your response.
I am trying to do that but it is not working. What my app currently does is based on selections, it filters a data table from my data source and displays it on a new screen. I can't seem to understand how the collect / patch function works so i can link it with flows (which i already set up). There is several dependecies in my selection list, and a few checkboxes. The dependencies filter the table and if you click a check box, it shows additional columns in the table..
Hi,
If you want to collect or store certain records then we use Collect or ClearCollect functions.
Patch is to Create/Update records in database.
In your case since you want to show the records basedupon the filter criteria you must go with ClearCollect.
ClearCollect(colItems,Filter(yourdatasource,column1=dropdown1.selected.value/columnname,column2=dropdown2.selected.value/columnname));
Now you will have collection ready on click of next button.
To see the values collected in the collection in Edit mode. Go to File--> collection --> your collection name.
If you just want to send the datatable as an email. Following link helps you may not need a flow:
if this answers your question mark it as verified and give a thumbsup
Regards,
Pavan Kumar Garlapati
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
205 | |
183 | |
71 | |
37 | |
33 |
User | Count |
---|---|
344 | |
274 | |
118 | |
76 | |
58 |