I have this search box in my power app and when I input the data and click on search button power automate flow triggers.
That's my flow:
The output is actually a link to a SharePoint file which contains my input value (in our case 2017)
Issue: When I do the search for the 1st time and the flow triggers the output SP file is empty, (no data), but when I click on the search button again it works perfectly fine with a SP file with the correct data.
Lets say now I change my input to 2018 and run the flow, the flow runs but the output file generated shows the results of previous input i.e 2017. And when I run the flow again with 2018 as input it shows correct output.
Why is that happening? why it is not showing me correct output in the 1st run?
Since we do not know what the create does and I dont see you looping through the Rows you got from SQL, I have no idea what your stuff is doing, but I can say that i am skeptical.
The flows are dumb, they do what you tell them.
Also, since you are creating the File there, you may need to put a Delay Action, before you return it to the user. But what you should do, is go to the Flow RUNS, where you explained it didn't work or it duplicated the previous one, and validate visually what data was passed in, what data was used etc.
The flow itself, as much as I can say, looks fine but you are missing ALL the details since the actions themselves dont mean squat to us, its the data (inputs and outputs) and how you use them that does.
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
2
Share
Report
All responses (
Answers (
