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

How to Submit the same form multiple times

Hello friends!

 

I need to submit the same information from a form, that have two fields that I have to change, for example:

Date - Value - Obs.

01/01/2018 - $ 50.00 - Part 01/10

01/02/2018 - $ 50.00 - Part 02/10

01/03/2018 - $ 50.00 - Part 03/10

01/04/2018 - $ 50.00 - Part 04/10

01/05/2018 - $ 50.00 - Part 05/10

01/06/2018 - $ 50.00 - Part 06/10

01/07/2018 - $ 50.00 - Part 07/10

01/08/2018 - $ 50.00 - Part 08/10

01/09/2018 - $ 50.00 - Part 09/10

01/10/2018 - $ 50.00 - Part 10/10

 

Does anyone have an idea to submit this information junt one time, and changing only the fields Date and Obs, instead of submit one by one?

 

Thank you.

 

49 REPLIES 49

@Anonymous

"I do think, in some cases, being able to use a loop would be better. My implementation is limited in the sense that there would be always 10 records added and changing that number would require change the source code."

Yeah that is what I meant with limited and tricky.

"But PA is determined to be no-code so having loops looks very unlikely."

Who said that? Was he drunk or high?? I don't even think that this is even possible. I'm ain't no IT guy or programmer but to make something without code is simply impossible unless they will want us to make only "calculators" in powerapps. I think the timer was meant to be a loop function from beginning but problem with the timer is that it is an item therefore it has a lot of properties in it which are absolutely useless for looping so what I used to do was to set the timer invisible and triggered it with the button but I still ended up with 10 useless items on my screen therefore the loop function would be much more better in every cases

"The only issue I can think of right now is when OnTimerStart doesn't increment its iterator before the next loop runs."

You can adjust the number of repeating very easily in timer and as far as I know it worked perfectly but I didn't try that with Patch function yet because the Patch hasn't been in siena before but I'm 100% sure it will work. I used to have 10 timers in my app with seriously massive code in it (2 A4 pages when I pasted it to word) and it was definitely waiting (sometimes too long) and updating the iterator without any problem. Try it and let me know

@rgparisoto

You got two options mentioned here so you can chose which one you want to use and amend them to your needs. But from your post 

"(It's like when someone buy me something and want to pay for me in 10 months (or more))"

I would use timer. Reasons are mentioned above. In that case you can't use limited SubmitForm with limited Form item and use Patch function and pick the values from each item instead

Anonymous
Not applicable

@Sienna --

About the no-code thing? It's on their homepage / feature page or whatever.

https://powerapps.microsoft.com/en-us/

image.png

I even remember the team rejecting one of the suggested ideas on the premise that PA is supposed to be no-code. (I'd link it but I have no motivation to dig right now. Lol)

 

And the each loop waiting to finish before repeating... That's good to know. I'd experiment with it but frankly, I really don't have the time right now. Maybe I will in the future. In any case, I've had problems with PA not making sense before. I believe there was this one time (I don't know if they fixed it or not) where if you have a ClearCollect() call before Navigate()Navigate() might execute before the ClearCollect() is finished. 

 

@rgparisoto --

Definitely agree with Sienna here. Use a Timer object to simulate a loop and use Patch() instead of SubmitForm() to do the submissions. My method only allows loops with a defined number of iterations.

 

P.S. This syntax-changing-for-each-locale is tripping me up. lol. Is this unique to PA?

 

Edit: Minor typos.

Anonymous
Not applicable

@rgparisoto --

Here's my suggestion for setting it up. A few points though beforehand.

  • Be aware, though, that I'm doing PA at a different locale. Syntax will vary. I'll do my best to adhere to yours but take the code with a grain of salt.
  • I don't know what your object names are so I'm going to make some up. I'll do my best to make it have sense though.
  • This field -- Observações. I'm assuming this is just to note which repetition this is. In that case, you don't need a form to do it. We can just build it with our loop. However, I don't want to just ignore the field that's already there so I'm just going to append that to our screen.
  • I'm assuming you don't want your layout / stuff to change. I'm going to work with that arrangement.
  • I'm also assuming the field, Repetições, will not be saved in the table and is just in the form as a control. If not, just add that in the patch function.

 

Set-up:

  1. Create a Timer object, let's call it TimerObject, with the following properties:
    OnTimerStart: // The submission code to be added later.
    Repeat: iterator < RepetitionsControl.Value
    OnSelect: UpdateContext({ iterator: 0 })
    Visible: false
  2. You already have a Check Icon. Set it to have the ff. OnSelect code.
    Select( TimerObject )
  3. TimerObject.OnSelect. Base the code you're going to use with the one below.
    Patch( YourDataSource, Defaults( YourDataSource ), {
        DataMovimento: DateAdd( DataMovimentoControl.SelectedDate, Iterator - 1, Months ),
    // Add the following fields:
    // Número, Conta, Fornecedor, Categoria, Subcategoria, Valor and Compensado
    ,
    Observações: Text(Value, "[$-en-US]00") & "/" & Text( Last(Numbers).Value ) & " " &
    ObservaçõesControl.Text });
    UpdateContext({ iterator: iterator + 1 })
    Note that if you're saving your list in Sharepoint, then you will need some tweaks in the code. However, I won't be able to help you with it. Sharepoint Lists don't like me and the feeling is mutual.

 

@Sienna -- Assuming you want to help this guy, any thoughts?

@Anonymous

"About the no-code thing? It's on their homepage"

Yeahh I kinda lost the trust with Microsoft since all the "ditching" they have done so far. I'm still trying to get over it. If the powerapps will be "no coding thing" it means it will be so limited that no one will work with it. I just think (hope) it is another their unsuccessful idiotic add to get more users to powerapps and mostly O365. As far as I can see nothing has changed since they starded PA with Sienna. They added few more codes(functions) instead of less codes which telling me that the add is just another bull****t (hopefully). BTW why not to make Excel "No Coding Thing" .... Microsoft!!!!

 

"I've had problems with PA not making sense before. I believe there was this one time (I don't know if they fixed it or not) where if you have a ClearCollect() call before Navigate()Navigate() might execute before the ClearCollect() is finished"

 

I haven't try that but if you really need to trigger ClearCollect before Navigate then use Timer too.. I know it sounds really crazy but you can be 100% sure it will be executed correctly every time and in every circumstances 

Anonymous
Not applicable

@Sienna --

I actually thought my feelings regarding PA and Microsoft were known in this community. I've ranted a lot of times about PA, especially when a major update is rolled in and it's not backwards compatible. And one of my posts is a Featured Post! Nevertheless, I feel you. I'm just thankful I'm moving jobs in a few weeks and will have nothing serious to do with PA anymore. Good luck, man!

 

And about the ClearCollect() and Navigate()? We already fixed the issue (by refactoring everything I've written so far. it was not fun.) but I do appreciate the tip. Thanks!

@Anonymous

"About the no-code thing? It's on their homepage"

I was thinking about the "no coding thing" over the night and here is my another thought. For programmer (proper programmer (geek as you wish)) coding means coding in C++, C#, Java and so on, however coding in powerapps isn't really coding. It is just a bunch of functions glued together and powerapps simply takes care of proper coding (in this case I'm sure it is Java). It is something like advanced Excel. I haven't met anyone what would say "I was coding in excel" but only "I made a table"... However for us as no programmers this is the only way to create an app and those functions are like a codes to us. I think the add should say something like this

"No programming skills required but you can't be dump"

But I don't think that would sell the product

Hopefully I'm right here

Anonymous
Not applicable

@Sienna --

I believe we have succeeded in derailing this thread... but what the heck. I'll go on if you want to.

 

Yeah, I do agree. There is coding and there is programming (...and there's probably a better way of saying that but you get the context). But it's still code. Even if you discount the code similar to what Excel has, I believe PA still counts as having code because not all code is Excel-like. We have imperative functions we often need to perform tasks such as Navigate(), Collect(), Back(), UpdateContext() and so forth. We have variables. We even use programming-esque terminology. In a sense, that's like basic programming -- the stuff people first learn when start to learn "actual" programming. (And what I'm learning right now. Basic level stuff. Yay for college.) To say that PA is no code is pretty much a lie. I'll accept the label of low-code. PA can claim it would handle all the high level programming we usually need to make an app (event handlers, hosting, actual query code, etc.) but it can't claim that the users would never need to code. 

 

And +1 for your suggested ad! If only. lol. 😄

@Anonymous

I believe we have succeeded in derailing this thread... but what the heck. I'll go on if you want to.

Yeah what the heck Smiley LOL

Back in Sienna time we could actually post the app into the windows store. You could download a script which transfer your app into the java code and from visual sudio you could just simply post it to the store. Whish the times are back and microsoft didn't ditch that idea. The sienna was not implemented into the O365 and the apps were stand-alone so in your case even if you would change the job you could still be able to work on your apps.

Anonymous
Not applicable


@Sienna wrote:

 

Yeah what the heck Smiley LOL

Back in Sienna time we could actually post the app into the windows store. You could download a script which transfer your app into the java code and from visual sudio you could just simply post it to the store. Whish the times are back and microsoft didn't ditch that idea. The sienna was not implemented into the O365 and the apps were stand-alone so in your case even if you would change the job you could still be able to work on your apps.


 

That's actually seems like a better idea. More complexity for users but more control. Less abstraction though so greater chances for faulty and leaky apps. Ultimately, it's a matter of thresholds. Where does Microsoft want to set their limits at? What costs are they willing to take?

 

Although the fact that they're ditching Project Siena doesn't seem well for PowerApps. And the fact that I can't seem to find a good description page of it in Google also seems worrying. This started when? 2013? And Microsoft's letting it go in about 2 months? If PA continues this trend of simply sucking, then... I don't know. Then again, it won't be my problem.

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 | Winners will be 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

Users online (1,082)