cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

Can more than one argument be passed to a Flow from PowerApps?  If so, of course, how?

So I am plowing along, pretty successfully using what I learned in in this post  (https://powerapps.microsoft.com/en-us/blog/return-an-array-from-flow-to-powerapps-response-method/) to call an SQL stored procedure from a Flow and then call that Flow in turn from a PowerApp but I have encountered a roadblock and am not coming up with the right strategy to solve it.  Here is a step-by-step of where I am and I would be extremely appreciative of any direction someone could point me in.   I have been browsing those sites to answer the question ("Can I pass more than one argument from a PowerApp to a Flow that needs four).  While I have seen some similar posts (https://powerusers.microsoft.com/t5/Building-Power-Apps/PowerApp-Button-pass-2-seperate-parameters-t...), nothing that directly addresses this problem, which I suspect others are encountering from the variety of different posted questions.

 

I have created a SQL Server stored procedure that takes 4 string arguments that works successfully.

ALTER PROCEDURE [dbo].[FlexQueryProductInventory]
       @Salesperson varchar(50) = '',
       @Crop varchar(50) = '',
       @Variety varchar(50) = '',
       @WarehouseName varchar(50) = ''
AS
BEGIN
      SET NOCOUNT ON;
      SELECT [Company Number]
      ,[Company Name]
      ,[Bus Unit]
      ,[Bus Unit Desc]
      ,[LOCATION]
      ,[Item Nbr Short]
      ,[Item Number]
      ,[Item Desc01]
      ,[Item Desc02]
      ,[Unit of Measure]
     ,[Qty On Hand]
      ,[Qty In Transit]
      ,[Qty On PO]
      ,[Qty Commit]
      ,[Qty On Backorder]
      ,[Qty Available]
  FROM [BI_Mart].[dbo].[RT_Product_Inventory]
  WHERE
       [LOCATION] LIKE '%' + @Salesperson + '%' AND
       [Item Desc02] LIKE '%' + @Crop + '%' AND
       [Item Desc01] LIKE '%' + @Variety + '%' AND
       [Bus Unit Desc] LIKE '%' + @WarehouseName + '%'
  ORDER BY [LOCATION], [Item Desc02], [Item Desc01], [Bus Unit]
END

I have created a Flow to execute this.  I have not gotten this to execute completely correctly yet in test mode since it is only prompting me for a single variable instead of four.  If I enter a string during a test, it placed that into each variable and while it ran successfully, it didn’t return any rows (because of course the search criteria didn’t result in any matches).  I then created a simpler stored procedure with a single WHERE test that did test out successfully (which is where I got the JSON payload to feed to the Response step to generate the schema).  So I have not successfully executed this Flow with proper strings being fed to each of the four variables  which was perhaps a foreshadowing of the problem I am encountering.  I have fiddled around a little with the configuration of the Initialize Variable step but to no avail so far.

Flow with multiple parameter variablesFlow with multiple parameter variables

 

I then went into my PowerApps and started to configure the Button to call the Flow and there is where I have encountered the block. Notice the Invalid number of arguments: received 4, expected 1 error message.  This seemed eerily similar to my inability to test my Flow with more than one string entry (one for each variable).

 

(the screen shots are showing up in line so I have attached them as files to the bottom)

PowerApps calling Flow Error Message.png

 

Now we get to my question.  Can more than one argument be passed to a Flow from PowerApps?  If so, of course, how?  I am beginning to believe based on reading the posts that I might have to pass a concatenated CSV string to the Flow in one argument. Then I will have to make the Flow parse the single input string and populate each of the four variables, perhaps with the Split function which I don’t know how to do yet so I need to better understand that process too (as I suspect that will also be useful in the future).  But I am wondering if perhaps there is a different way to write the Flow from scratch to accept more than the one argument.  This seems like it should be straightforward but as we know very little is straightforward in PowerApps and Flow😉.

 

For just a little more context, here is the whole PowerApps app where I will populate the Data Table in the middle with the results of this stored procedure based on the search parameters passed and the lower Gallery with the results of the second stored procedure which fortunately only requires one variable to be passed after an item is selected from the Data Table.

OverallPowerAppsScreen.jpg

 
1 ACCEPTED SOLUTION

Accepted Solutions

I finally solved this little mystery and the short answer is "Yes, you can pass more than one argument to a Flow from PowerApps but it doesn't seem to be documented anywhere".  Here is the short description:

 

I was on the right track in that you just put in an Initialize Variable step for each argument (variable) you want to pass and make certain that you select "Ask in PowerApps" from the Dynamics Content for each Value when prompted.  This is where it gets a little squirrely because while the "Ask in PowerApps" comes up initially in the Dynamic Content box on the first variable, it "disappears" for some reason in subsequent Initialize Variable steps.  It is there but hidden for some reason and you need to either query for it with an "Ask" or just hit the show more button.  When you do that, all is good and things work more or less as one might expect.

 

Now here are all of the "gotchas" that made this difficult to solve and generated an enormous amount of frustration.

This argument passing issue was really, really annoying because it pointed up

  1. the continued lack of documentation and inability to find a quick answer to what design pattern and syntax to use for something so straightforward that many people likely will need somewhere along the line.  All of the references come from people trying to solve their specific problem (like passing and parsing multiple email addresses) rather than the more general question of passing multiple arguments. There is a great white paper out there on standards and guidelines that has helped me a lot but it really needs to be expanded to include lots of really standard design patterns out there like this one (as well as clear documentation on how to use certain functions like split()).
  2. real deficiencies in the Power Automate and PowerApp  Studios and again a lack of a basic documentation including known issues. 
    1. In Power Automate, initialized variables are not taking on the names of steps in the Dynamics Content window that are renamed (or the variables that are being set) so it is completely impossible, after doing the renaming to real steps, to tell which step the data is being requested for during Test runs of the Flow
    2. Even worse, when I deleted Flow steps because I had bolluxed up the syntax so badly I wanted to start fresh on them, the “deleted” Initialized value remained somewhere in the Power Automate cache and I couldn’t find any documentation on how to clear them (I tried everything I could think of).  In addition, they continued to accumulate as you add and delete steps so the test went from prompting me for just one variable (out of the 4 I was looking for) to prompting me for 5 and then 9 and then 10, 11, 12 as I deleted steps to try to get back to a good starting point before re-adding them.  In addition, as I said earlier in this post, the “Ask from PowerApp” Dynamic Content showed up nicely for the first Initialize Variable step but then for unknown reasons went invisible on subsequent Initialize Variable steps.  It was there and I just had to hit “show more” or query for it but I only found it because I stumbled on it out of sheer frustration rather than having it clearly documented somewhere. 
      1. BTW, it turns out that happened to be my initial mistake.  Because I couldn’t find that option in the Dynamics Content window, I had tried something else when I initialized variables 2-4 the first time around and since I hadn’t used “Ask in PowerApps” on them then, guess what, it wasn’t asking for them😉.
    3. Finally, out of sheer desperation because I couldn’t clear out the old detritus variables, I had to completely start over with a fresh Flow from scratch determined not to make any mistakes now that I knew about this little variable caching issue.  Now, as a musician, I know that it was good for me to get the practice doing it over and over but as a person who actually wants a product to work in a reasonable manner and get to bed on time, that was definitely not what happened last night😉
  3. Then, just to top it all off, late in the evening, after I solved the Flow issue and just wanted to connect it up to my PowerApp to test, I discovered a major problem in the PowerApps Studio trying to invoke the Flow.  When I used the Action>Power Automate button, it repeatedly, completely erased and then garbled what I had entered into the function line initially (the ClearCollect function template).  Then when I redid I added the ClearCollect function back in, it deleted the Power Automate call.  I had to piece the function line text together with a series of “cuts and pastes” from Notepad (I mean like 5, I was ready to put my fist through the screen before I got it all assembled).  While I had gotten a little used to this type of strange Studio behavior 3 years ago, I was really not expecting this kind of thing to still be in the product now.  I really thought I was going crazy there for a few minutes until I stepped through it very, very slowly watching every single keystroke to see when it broke.

So as Willie the Shake would say "all's well that ends well".  And, had I needed to, I now know how I could have used the other strategy to solve the problem by passing a string with multiple values concatenated together as a CSV and then parse them out and assign them to Flow variables using the split() function which I couldn’t do before (and yet again, the documentation on how to do that was fragmented and found all over the place in different blog posts and messages).

 

I will try to come back into the post and add a few screenshots later if I have some time.

 

 

View solution in original post

8 REPLIES 8

@markslosberg 

Did you try removing the Flow from PowerApps and then re-adding it?

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

I did but not in a very controlled setting.  I really would like to know that I am on the correct structural track to solve this and then go back and execute the changes in carefully scripted setting to ensure that I am not flopping around (a technical term) and wasting a lot of time trying things willy-nilly.

I finally solved this little mystery and the short answer is "Yes, you can pass more than one argument to a Flow from PowerApps but it doesn't seem to be documented anywhere".  Here is the short description:

 

I was on the right track in that you just put in an Initialize Variable step for each argument (variable) you want to pass and make certain that you select "Ask in PowerApps" from the Dynamics Content for each Value when prompted.  This is where it gets a little squirrely because while the "Ask in PowerApps" comes up initially in the Dynamic Content box on the first variable, it "disappears" for some reason in subsequent Initialize Variable steps.  It is there but hidden for some reason and you need to either query for it with an "Ask" or just hit the show more button.  When you do that, all is good and things work more or less as one might expect.

 

Now here are all of the "gotchas" that made this difficult to solve and generated an enormous amount of frustration.

This argument passing issue was really, really annoying because it pointed up

  1. the continued lack of documentation and inability to find a quick answer to what design pattern and syntax to use for something so straightforward that many people likely will need somewhere along the line.  All of the references come from people trying to solve their specific problem (like passing and parsing multiple email addresses) rather than the more general question of passing multiple arguments. There is a great white paper out there on standards and guidelines that has helped me a lot but it really needs to be expanded to include lots of really standard design patterns out there like this one (as well as clear documentation on how to use certain functions like split()).
  2. real deficiencies in the Power Automate and PowerApp  Studios and again a lack of a basic documentation including known issues. 
    1. In Power Automate, initialized variables are not taking on the names of steps in the Dynamics Content window that are renamed (or the variables that are being set) so it is completely impossible, after doing the renaming to real steps, to tell which step the data is being requested for during Test runs of the Flow
    2. Even worse, when I deleted Flow steps because I had bolluxed up the syntax so badly I wanted to start fresh on them, the “deleted” Initialized value remained somewhere in the Power Automate cache and I couldn’t find any documentation on how to clear them (I tried everything I could think of).  In addition, they continued to accumulate as you add and delete steps so the test went from prompting me for just one variable (out of the 4 I was looking for) to prompting me for 5 and then 9 and then 10, 11, 12 as I deleted steps to try to get back to a good starting point before re-adding them.  In addition, as I said earlier in this post, the “Ask from PowerApp” Dynamic Content showed up nicely for the first Initialize Variable step but then for unknown reasons went invisible on subsequent Initialize Variable steps.  It was there and I just had to hit “show more” or query for it but I only found it because I stumbled on it out of sheer frustration rather than having it clearly documented somewhere. 
      1. BTW, it turns out that happened to be my initial mistake.  Because I couldn’t find that option in the Dynamics Content window, I had tried something else when I initialized variables 2-4 the first time around and since I hadn’t used “Ask in PowerApps” on them then, guess what, it wasn’t asking for them😉.
    3. Finally, out of sheer desperation because I couldn’t clear out the old detritus variables, I had to completely start over with a fresh Flow from scratch determined not to make any mistakes now that I knew about this little variable caching issue.  Now, as a musician, I know that it was good for me to get the practice doing it over and over but as a person who actually wants a product to work in a reasonable manner and get to bed on time, that was definitely not what happened last night😉
  3. Then, just to top it all off, late in the evening, after I solved the Flow issue and just wanted to connect it up to my PowerApp to test, I discovered a major problem in the PowerApps Studio trying to invoke the Flow.  When I used the Action>Power Automate button, it repeatedly, completely erased and then garbled what I had entered into the function line initially (the ClearCollect function template).  Then when I redid I added the ClearCollect function back in, it deleted the Power Automate call.  I had to piece the function line text together with a series of “cuts and pastes” from Notepad (I mean like 5, I was ready to put my fist through the screen before I got it all assembled).  While I had gotten a little used to this type of strange Studio behavior 3 years ago, I was really not expecting this kind of thing to still be in the product now.  I really thought I was going crazy there for a few minutes until I stepped through it very, very slowly watching every single keystroke to see when it broke.

So as Willie the Shake would say "all's well that ends well".  And, had I needed to, I now know how I could have used the other strategy to solve the problem by passing a string with multiple values concatenated together as a CSV and then parse them out and assign them to Flow variables using the split() function which I couldn’t do before (and yet again, the documentation on how to do that was fragmented and found all over the place in different blog posts and messages).

 

I will try to come back into the post and add a few screenshots later if I have some time.

 

 

Thank you!


I needed to create a pdf, save it to sharepoint and also send that pdf as an attachment back to the user. (with one button in powerapps)

So I needed more than one argument from powerapps to Flow.

"It is there but hidden for some reason and you need to either query for it with an "Ask" or just hit the show more button."

 

K.

lakosked
Frequent Visitor

Hi, Im running into a similar issue.  But your post does not show the syntax for the power app button.

PowerAppName.Run(FieldName.Text)

Is as far as I have gotten.  Can you post an example of the syntax for multiple fields?  Thanks.

You are on the right track. This is one of the most poorly documented areas as well as the most tedious and weird. First of all, it appears that you can pass as many variables to Flow as needed but the Flow itself drives this process. When you set up the Flow, just do an Init Variable for each parameter and when prompted, use the “Ask in PowerApps” Dynamic content for it. The real painful part is inserting the Flow run command into the PowerApp. The best thing is to just create a standalone button initially and then use the Action/PowerAutomate command to insert it the first time. Once you do this, then you can just type it into another command that is more complicated like placing the results into a ClearCollect function. You can delete the initial button after that. The syntax is as you have it <Flowname>.Run(var1, var2, var3,...) and the syntax checker will ensure the the number of variables in the parentheses matches the number of variables that the Flow is looking for. 

 

I have not been successful passing anything but strings so far (so no numbers or Booleans or arrays yet - it might be possible but I haven’t gotten it to work yet). I just do the type conversions in the flow or downstream (e.g. the SQL Stored Proc). 

one more thing. G-d forbid you have to change the number of arguments passed, you kind of have to start over so try to plan carefully. There are a lot of other vagaries here that are too much for this post but these are the essentials. 

I will say that if you stay within the mysterious, undocumented railings, I have found this to be very stable in operation but I have wasted a lot of time getting to this point. 

Hi Mark,

Thanks for the bit of Syntax. 

Seeing you have commas between the values did the trick.

I thought I had tried commas as a separator earlier today, then tried semi colons, then something else, etc etc.

It was a circular exercise in frustration.

I'm successfully bringing over 3 parameters from one power app to the other via the flow now.

 

Next is to dig into the weeds further by trying to bring over a fourth.

This fourth one is from a sharepoint list drop down but the weird thing is the name that appears in the flow.

In SharePoint it is ClientID

But in the flow it is listed as ClientID id

I've looked through sharepoint and for the life of cannot figure out why the flow is seeing it as ClientID id

So Im not sure if it isn't working because of the name or because of the dropdown or what.

Either way.  I appreciated your assistance with the commas syntax.   3 fields of the 4 is better than what I had this morning with only one field.

 

This is all I had to do. Had the same issue as OP and I just removed the flow and the re-added it. Works a treat!

Helpful resources

Announcements

Community will be READ ONLY July 16th, 5p PDT -July 22nd

Dear Community Members,   We'd like to let you know of an upcoming change to the community platform: starting July 16th, the platform will transition to a READ ONLY mode until July 22nd.   During this period, members will not be able to Kudo, Comment, or Reply to any posts.   On July 22nd, please be on the lookout for a message sent to the email address registered on your community profile. This email is crucial as it will contain your unique code and link to register for the new platform encompassing all of the communities.   What to Expect in the New Community: A more unified experience where all products, including Power Apps, Power Automate, Copilot Studio, and Power Pages, will be accessible from one community.Community Blogs that you can syndicate and link to for automatic updates. We appreciate your understanding and cooperation during this transition. Stay tuned for the exciting new features and a seamless community experience ahead!

Summer of Solutions | Week 4 Results | Results posted on July 24th

We are excited to announce the Summer of Solutions Challenge!   This challenge is kicking off on Monday, June 17th and will run for (4) weeks.  The challenge is open to all Power Platform (Power Apps, Power Automate, Copilot Studio & Power Pages) community members. We invite you to participate in a quest to provide solutions in the Forums to as many questions as you can. Answers can be provided in all the communities.    Entry Period: This Challenge will consist of four weekly Entry Periods as follows (each an “Entry Period”)   - 12:00 a.m. PT on June 17, 2024 – 11:59 p.m. PT on June 23, 2024 - 12:00 a.m. PT on June 24, 2024 – 11:59 p.m. PT on June 30, 2024 - 12:00 a.m. PT on July 1, 2024 – 11:59 p.m. PT on July 7, 2024 - 12:00 a.m. PT on July 8, 2024 – 11:59 p.m. PT on July 14, 2024   Entries will be eligible for the Entry Period in which they are received and will not carryover to subsequent weekly entry periods.  You must enter into each weekly Entry Period separately.   How to Enter: We invite you to participate in a quest to provide "Accepted Solutions" to as many questions as you can. Answers can be provided in all the communities. Users must provide a solution which can be an “Accepted Solution” in the Forums in all of the communities and there are no limits to the number of “Accepted Solutions” that a member can provide for entries in this challenge, but each entry must be substantially unique and different.    Winner Selection and Prizes: At the end of each week, we will list the top ten (10) Community users which will consist of: 5 Community Members & 5 Super Users and they will advance to the final drawing. We will post each week in the News & Announcements the top 10 Solution providers.  At the end of the challenge, we will add all of the top 10 weekly names and enter them into a random drawing.  Then we will randomly select ten (10) winners (5 Community Members & 5 Super Users) from among all eligible entrants received across all weekly Entry Periods to receive the prize listed below. If a winner declines, we will draw again at random for the next winner.  A user will only be able to win once overall. If they are drawn multiple times, another user will be drawn at random.  Individuals will be contacted before the announcement with the opportunity to claim or deny the prize.  Once all of the winners have been notified, we will post in the News & Announcements of each community with the list of winners.   Each winner will receive one (1) Pass to the Power Platform Conference in Las Vegas, Sep. 18-20, 2024 ($1800 value). NOTE: Prize is for conference attendance only and any other costs such as airfare, lodging, transportation, and food are the sole responsibility of the winner. Tickets are not transferable to any other party or to next year’s event.   ** PLEASE SEE THE ATTACHED RULES for this CHALLENGE**   Week 1 Results: Congratulations to the Week 1 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Community MembersNumber of SolutionsSuper UsersNumber of Solutions @anandm08  23 @WarrenBelz  31 @DBO_DV  10 @Amik  19 AmínAA 6 @mmbr1606  12 @rzuber  4 @happyume  7 @Giraldoj  3@ANB 6 (tie)   @SpongYe  6 (tie)     Week 2 Results: Congratulations to the Week 2 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Community MembersSolutionsSuper UsersSolutions @anandm08  10@WarrenBelz 25 @DBO_DV  6@mmbr1606 14 @AmínAA 4 @Amik  12 @royg  3 @ANB  10 @AllanDeCastro  2 @SunilPashikanti  5 @Michaelfp  2 @FLMike  5 @eduardo_izzo  2   Meekou 2   @rzuber  2   @Velegandla  2     @PowerPlatform-P  2   @Micaiah  2     Week 3 Results: Congratulations to the Week 3 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge.   Week 3:Community MembersSolutionsSuper UsersSolutionsPower Apps anandm0861WarrenBelz86DBO_DV25Amik66Michaelfp13mmbr160647Giraldoj13FLMike31AmínAA13SpongYe27     Week 4 Results: Congratulations to the Week 4 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge.   Week 4:Community MembersSolutionsSuper UsersSolutionsPower Apps DBO-DV21WarranBelz26Giraldoj7mmbr160618Muzammmil_0695067Amik14samfawzi_acml6FLMike12tzuber6ANB8   SunilPashikanti8

Check Out | 2024 Release Wave 2 Plans for Microsoft Dynamics 365 and Microsoft Power Platform

On July 16, 2024, we published the 2024 release wave 2 plans for Microsoft Dynamics 365 and Microsoft Power Platform. These plans are a compilation of the new capabilities planned to be released between October 2024 to March 2025. This release introduces a wealth of new features designed to enhance customer understanding and improve overall user experience, showcasing our dedication to driving digital transformation for our customers and partners.    The upcoming wave is centered around utilizing advanced AI and Microsoft Copilot technologies to enhance user productivity and streamline operations across diverse business applications. These enhancements include intelligent automation, AI-powered insights, and immersive user experiences that are designed to break down barriers between data, insights, and individuals. Watch a summary of the release highlights.    Discover the latest features that empower organizations to operate more efficiently and adaptively. From AI-driven sales insights and customer service enhancements to predictive analytics in supply chain management and autonomous financial processes, the new capabilities enable businesses to proactively address challenges and capitalize on opportunities.    

Updates to Transitions in the Power Platform Communities

We're embarking on a journey to enhance your experience by transitioning to a new community platform. Our team has been diligently working to create a fresh community site, leveraging the very Dynamics 365 and Power Platform tools our community advocates for.  We started this journey with transitioning Copilot Studio forums and blogs in June. The move marks the beginning of a new chapter, and we're eager for you to be a part of it. The rest of the Power Platform product sites will be moving over this summer.   Stay tuned for more updates as we get closer to the launch. We can't wait to welcome you to our new community space, designed with you in mind. Let's connect, learn, and grow together.   Here's to new beginnings and endless possibilities!   If you have any questions, observations or concerns throughout this process please go to https://aka.ms/PPCommSupport.   To stay up to date on the latest details of this migration and other important Community updates subscribe to our News and Announcements forums: Copilot Studio, Power Apps, Power Automate, Power Pages

Top Solution Authors
Top Kudoed Authors
Users online (4,132)