I have a workflow that works perfectly creates the records in PDF and does what it is supposed to do but Fails every time because it is looping and see that the record is already created.
How can I make it so when I click the button in the PowerApp it just tries to run the one request. I have everything in an applied to each because of the two append variables.
I am up for any suggestion. In the first Compose it is pulling the email address of the one record I am requesting so I am assuming I can simplify this process. Just not sure how or where to change it.
Thanks in advance.
You can avoid the loop , if you use following expression wherever you are referring to "Get Items -Load Chair" action:
You wouldn't change Get Items-Load Chair. Instead use what Deepak has indicated where you want to get the data from Load Chair List. Example: Award Summary (I am assuming, Award Summary is a column in Load Chair List).
Hope this helps
Where did you get on that? If you've not applied that suggestion, then do so and see if that resolves your issue.
Thats the problem I do not know how to apply that suggestion. This is the issue, is it a compose, variable or something different. I am not a Power Automate person so I am struggling.
What is being suggested is to get rid of the Apply to Each and move the action blocks that are in it, out of it. Then change the input to the formula provided by @DeepakS so that it only works with one record and not all of them from the Get-Items.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Did you know that you could restore a deleted flow? Check out this helpful article.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
At the monthly call, connect with other leaders and find out how community makes your experience even better.