Unanswered

Using Power Automate to create a Sharepoint item from a Power App

(0) Share

Report

Posted on by sloughcow Microsoft Employee

I think I should properly be using a Form in Power Apps for this function, but I struggle to format forms in the way I want. Right now, I've got a bunch of fields in a Power App that are either text-entry fields, or picklist fields populated by SharePoint lists to normalize the user input (like "newsletter category"). The Power App fields are intended to provide the input to create a new SharePoint list item (in a list called "Newsletter articles").

I've got everything working until the SharePoint item gets created. I have a Power App "submit" button, and can't figure out how to make it call my Power Automate flow.

My flow is constructed with

a PowerApps trigger ("No additional information is needed for this step. You will be able to use the outputs in subsequent steps.")
A flow step to respond to a PowerApp or flow: In this step, I've got a bunch of text outputs, each mapped to dynamic content "RespondtoaPowerApporflow_text"
A flow step to create a SharePoint item. I've identified the newsletter articles list, and mapped the Sharepoint fields to the "RespondtoaPowerApporflow_text" fields I identified in step 2

I feel like I'm 99% there... but don't know how to make my Power App call the Power Automate flow.

Am I as close as I think? Can you help me get all the way there? 🙂

Thanks in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

VaidasG 469 on at

Like (0)

Report
Copy link

Link copied!

Hi @sloughcow ,

Add your flow to the app, then start typing flow name to the OnSelect property of your button. Your flow name with .Run() function will get suggested. Fill your flow inputs with the brackets and of you GO...! 😀

Was this reply helpful? Yes No
sloughcow Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@VaidasG That's one of the places I'm struggling... I don't see how to add the flow to the app! Do you have any pointers?

Was this reply helpful? Yes No
VaidasG 469 on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
sloughcow Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@VaidasG You have blown my mind. How could I possibly have missed that?!
Thank you! I think you've gotten me SO close.

My button On Select property is 'PowerApp->RespondtoaPowerApporflow'.Run('PowerApp->RespondtoaPowerApporflow'.Topic) (and that's clearly not right). I'm trying to find documentation that fits for this scenario...

"Topic" is one of my field names. Am I on the right track? Trying to figure out how to get the syntax right, and string together multiple fields.

Was this reply helpful? Yes No
PowerRanger 3,458 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@sloughcow

Use this

Set(varFlowReturnValues,'PowerApp->RespondtoaPowerApporflow'.Run())

The variable varFlowReturnValue will now hold all values returned by the flow.

Was this reply helpful? Yes No
VaidasG 469 on at

Like (0)

Report
Copy link

Link copied!

@sloughcow ,

What you see is correct..!

As per screenshot above, if you place your mouse cursor just after the opening bracket, you should get the list of input parameters expected by your flow. They are named as "flow name"_"parameter name" (Underlined in the screenshot). If you have multiple input parameters, make sure you follow the order, as per requested list.

Hope this helps 🤓

Was this reply helpful? Yes No