Power Platform Community Forum Thread Details

Hi Community,

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?

Categories:

General topics

Hi,

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.