Unanswered

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

Like (0) Share

Report

Posted on 27 Aug 2022 17:49:07 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:

Connectors

General Questions

All responses (6)

Answers (0)

VaidasG 469 on 27 Aug 2022 at 19:50:54

Like (0)

Report

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

@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 🤓
PowerRanger 3,458 Super User 2024 Season 1 on 27 Aug 2022 at 19:40:23

Like (0)

Report

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

@sloughcow

Use this

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

The variable varFlowReturnValue will now hold all values returned by the flow.
sloughcow Microsoft Employee on 27 Aug 2022 at 18:52:37

Like (0)

Report

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

@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.
VaidasG 469 on 27 Aug 2022 at 18:23:03

Like (0)

Report

Re: Using Power Automate to create a Sharepoint item from a Power App
sloughcow Microsoft Employee on 27 Aug 2022 at 18:10:18

Like (0)

Report

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

@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?
VaidasG 469 on 27 Aug 2022 at 18:00:44

Like (0)

Report

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

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...! 😀