Search a Text within all completed flows

Like (0) Share

Report

Posted on 19 Sep 2022 03:14:12 by HN-04060819-0

Hi there,

I have lots of flow instances run on each day, but instead of opening each flow to check the values of the Action, is there a better way that I could search a text/string among all action outputs of completed flows?

Currently, I have to do the following:

[My Flow] > Run History > Open each flow > check the output of the action I am looking for

I have the same question (0)

All responses (3)

Answers (0)

Sundeep_Malik 6,484 on 19 Sep 2022 at 06:33:03

Like (1)

Report

Re: Search a Text within all completed flows

@hifni
Unfortunately, I don't think that's possible.

Was this reply helpful? Yes No
HN-04060819-0 46 on 19 Sep 2022 at 06:06:04

Like (0)

Report

Re: Search a Text within all completed flows

Thank You very much @Sundeep_Malik

Although its not what I looking into yet it paved the way to solve another issue I had.

My apologies for not exactly writing what I need or not making myself clear. I wasn't expecting a dynamic solution (with actions and expressions) however, I was expecting something I can do in the, Power Automate Run History.

Basically I need to search from Run History by searching any flows in which the outputs of actions in that flow match the text/string I gave. Essentially, I will be needing to go into detail about those flows to review the flow. The search result will show only the flows that ran with the text/string I intended to search for.

i.e. let's say I need to search all flows in the run history which had its actions' output having the text "Hello" (it can be in any attribute). So essentially I need to know any place in Power Automate UI of that particular flow where I can place the search text and search for any flows which satisfy the criteria and then go into detail instead of going through all the flows.

Was this reply helpful? Yes No
Sundeep_Malik 6,484 on 19 Sep 2022 at 05:18:07

Like (1)

Report

Re: Search a Text within all completed flows

Hey @hifni
You can use the result function for this. Take out the output field from result function and store it in a SP List or an excel or any database of your own choice. And search for that text in your database.

So at the end of the flow. The action that contains your answer or text, add it to a scope. After that add a compose action and inside it write result('Scope_Name'). [Scope_Name=Name you have kept for the scope, default would be Scope only]
After this you can use parse json on the above compose.
After this just store the output field in another compose. And send it to the database you want to store to.

So result function is mostly used for logging. You can get other fields like name of the action, inputs and outputs for it. The final result of that action, was it successful or failed.

Heres how the flow looks like:

As I had taken 5 in the scope's compose, here in output I am getting 5. This you can store in the database everytime. Final Output:

I hope this helps.

Was this reply helpful? Yes No