Creating PowerApp .Run command for button Onselect using data from a SharePoint list item input

(0) Share

Report

Posted on by CU02101932-0

I want to use a PowerApp button on a custom form to run an instant flow that uses a PowerAppV2 trigger where the PowerAppV2 input is text that is pulled from the PowerApps form submission. What is the run code I need so that when I complete the form data it triggers the flow. The rest of the flow is not complete, but it will eventually use items from another task list to create multiple lines from each item for the request FSR Name. I have been overthinking this for two days, so I hope the question makes sense.

Categories:

Using Apps Using Formulas

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

WarrenBelz 150,771 Most Valuable Professional on at

Like (0)

Report
Creating PowerApp .Run command for button Onselect using data from a SharePoint list item input

Hi @CU02101932-0,

There are a few things I see initally that need to be addressed before any further debugging on the Flow

Dates need to be sent to a Flow in UTC format "yyyy-mm-dd", not "mm/dd/yy" (I assume you are from USA as the rest of the world uses "dd/mm/yyyy")

You have two parameters expected by the Flow, FSR Name and Start Date but you have only sent one from Power Apps

However putting all this aside, why are you even using a Flow (I mentioned this in the last post) . Assuming that txtHireDate is a Date Picker and you want to create a new record in 'New Hire Onboarding Task List' for every record from your filter in Tasks (how are you sending this filter ?) then
With( { _Items: Filter( Tasks, YourFilterHere ) }, Patch( 'New Hire Onboarding Task List', ForAll( _Items, { 'Start Date': txtHireDate.SelectedDate, 'FSR Name': txtFSRName.Text, Title: _Items.Title, Priority: _Items.Priority, 'Responsible Department': _Items.'Responsible Department' } ) ) )

Please ✅ 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 answering Yes to Was this reply helpful?
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
CU02101932-0 4 on at

Like (0)

Report

Creating PowerApp .Run command for button Onselect using data from a SharePoint list item input

@WarrenBelz,

I hope this is enough. Thanks for the support. I was able to get everything working except the date field to complete the PowerApp confirm button to pass the date and complete the flow. I need to understand how to configure the flow variable for Hire Date to work with the Confirm button OnSelect command. I had to attach the images as files.

task flow image 1...

task flow image 2...

PowerApp Image.jpg

Was this reply helpful? Yes No
WarrenBelz 150,771 Most Valuable Professional on at

Like (0)

Report

Creating PowerApp .Run command for button Onselect using data from a SharePoint list item input

Hi @CU02101932-0,

Have you attempted the Flow with the parameters you mention - all I can see is a trigger and a Compose action. Also from what you describe, you probably do not need a Flow (you could Patch it all in Power Apps). Happy to help you with any code corrections, but I need to see your attempt at the basic structure.

Was this reply helpful? Yes No
CU02101932-0 4 on at

Like (0)

Report

Creating PowerApp .Run command for button Onselect using data from a SharePoint list item input

@WarrenBelz,

Thank you for the reply. I want to be able to add data into the FSR Name field and the Start Date field to populate the associated a New Hire Onboarding Task List and trigger a flow that pulls items from a Task List to create new unique line items for each task for the new hire. Basically, creating a predefined Onboarding List for each new hire Just by adding their name and start date in a Power App in SharePoint. Please ask for clarity if you need more.

Was this reply helpful? Yes No
WarrenBelz 150,771 Most Valuable Professional on at

Like (0)

Report

Creating PowerApp .Run command for button Onselect using data from a SharePoint list item input

Hi @CU02101932-0,

You might need to explain a bit more here - what if anything are your sending in the Flow parameters from Power Apps and what do you want to do with it in the Flow ?

Was this reply helpful? Yes No