You’re offline. This is a read only version of the page.
407
Is it possible to use a button on a gallery to "get items"? I have a regular workflow that functions when you are creating a new item but I'm hoping to add a button to a gallery so they can run it from there when they are ready to take care of that task.
I'd like it to look for 3 values (Dept, Center, Role) from another list that is connected to the powerapp and then send an email to the person working on the checklist the list of security groups they need to enter requests for.
I wasn't able to figure out using collections and trying to place on the form (larger form) and I may have someone at work that might know a way.
For anyone interested, I WAS able to get the button working to run the workflow from the gallery item. Note the quotes in front and back of the name of the workflow name and then it was just choosing those columns.
'UPTChecklistGetSecurityGroups'.Run(ThisItem.Department,ThisItem.Centers,ThisItem.Roles)
You would have to use a combo box if you wanted to make multiple selections... But that gets tricky. I would work on getting it to function one at a time first, then go from there.
To filter your queries and search specific things on your table do this:
On Start is a function under the three dots to the right of the "App" tree item.
All I am doing there is saying when the form starts up, I declared a collection name and chose what data source it is coming from (My SharePoint list)
Now make a data table. This is going to be where you'll preview your information.
The Text Input box works as my search bar. Check out the code and make it work in your form! It's super useful, and it's not as complicated as it seems.
Best of Luck!
Josh
yeah, have been using it for a few years but not yet intermediate to advanced. My customers aren't asking for any really crazy stuff.
They were asking for a button and so I'd like to accommodate that.
If i can figure out how to pull them in with another cascading dropdown, I'll work on that later. There is normally 1 or more security groups that would need to be pulled. I don't know how to do that with a cascading dropdown in PowerApps.
There is a way to do it, but I would've done it strictly through PowerApps... You can fetch data from all over on PowerApps. In my opinion, much easier to get working that Power Automate.
Set your two data sources within your App
Have two different Data Tables, one for each SharePoint list. (Or However you'd like to do it)
Connect the Fields to the tables accordingly, and you should have what you want.
PowerApps is a great tool.
I recommend getting familiar with it!
It's ok I'll keep playing with it and figure out it. All of the information is there and already filled out.
I still just want a button on the gallery to do the manual "Get Items" instead of forcing the Admin to go to the actual backend SharePoint list since that would be defeating the purpose of having them use the App.
I created a simple manual PowerAutomate workflow to "get items" for someone to use on the actual list so I would think there is way to get that to work through a button on PowerApps...but it's MS, so maybe maybe not. Sometimes it's the simple things we have issues with.
I was not aware there was anything else available than the run command. First time running a workflow from PowerApps.
They will not be submitting or updating anything. All of the information is already in the list item that the manager submitted. The admin later will come back to the list item on the gallery where I'm hoping they can just click on a button that says "get security groups" and it will look at the fields that the manager originally filled out, compare and look at the separate Security Groups list and send all of the groups associated with the "Department", "Center" and "Role" were chosen.
Get Items is looking at the secondary list with the actual security groups in it.
Can I see your whole flow? It seems you are using the Run command... are you submitting your form or updating the entries otherwise in your PowerApps?
If not insert a ";" semi-colon on the end of your Run command.
Start a new line that says:
SubmitForm("FormName")
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
Share
Report
All responses (
Answers (
