How to keep flows remain on if the flows don't run for 90 days

-

This is a common requirement in power plat form world, flows turn off after 90 days if they don't run. We can address this issue by writing a scheduled flow and run every day. 

I will explain how to write this flow. 


Start with by selecting a schedule flow.




Select Power automate management connecter- List flows as admin(V2)




Once you select it will ask you to create a connection then Select your target Environment


Next we need to filter the flows which we want to turn it on, Here I am using a unique display name which you have common for all the flows you want to check. In my case I am using "-Production-" to filter down the flows. 

Select the value from the list flows




Select edit in advance mode and enter the below expression


@and(equals(item()?['properties/state'], 'Stopped'),contains(item()?['properties/displayname'],'-Production-'))



In the next action, select apply on each , Select the output value from the filter array, Select the same Power automate management connecter - Turn on flow. 



Select the Target Environment and put the flow name Custom value- select flow name from filter array.



Now all done, Run the flow and test it


Thank you for visiting this blog 🙏. 

Comments

Post a Comment

Popular posts from this blog

Create a grounded prompt in AI Builder - Dataverse(preview)- Use prompt in a cloud flow

-
Image
Creating a grounded prompt in AI Builder using Dataverse is an innovative way to enhance AI capabilities by connecting them to a structured data source. Grounding AI prompts involves linking them to specific knowledge, in this case, the data stored within Dataverse. This process allows for more contextually relevant and accurate responses from AI systems, as they can draw directly from the data available in Dataverse. You can use prompts in various scenarios, such as to: Generate summaries or reports from your data. Generate categories or reports from your data. Answer question s from your customers or employees. Extract named entities from text. Draft a reply to a request. AI Builder provides a prompt builder that allows makers to write, test, save, and use prompts to generate text. Lets go and build a prompt now! To create a prompt in AI Builder, follow these steps: Sign in to Power Apps or Power Automate. On the left pane, select the ellipsis ( ... ) to expand the  More  ...
Read more

How to update 100000(hundred thousand) records with power automate flow by using chunk expression, Split the list and pass onto child flows.

-
Image
The Dataverse connecter returns up to 5000 rows by default, We can increase this up to 100000. To get more than 5,000 rows, turn on the Pagination and set the threshold up to 100,000 in Settings If you have more than 100,000 rows to process? you can get more than 100,000 rows from Dataverse, use the skip token to send another request until the skip token returns empty When we have thousand of records to update instead of doing list down the records and apply on each, I have approached this slightly different here.  We will build one parent flow and 4 child flows. So that we can divide the whole list into 4 identical list and pass on to child flows. This approach significantly reduces the time to update the total records.  Lets jump in and build a flows! Based on your requirement you can choose the type of flow you want, for example purpose I am using Schedule flow.  Since I am using the current date to filter down the records, I am initialize and format the date. use the ...
Read more

The New Data Experience (ERD) in Power Apps-Simplifying Data Management - Complex Data Models

-
Image
Power Apps has introduced an exciting new data experience that streamlines how makers work with data sources and tables. This update brings significant improvements to data management, making it easier than ever to build powerful apps. To build meaningful business applications, data models consisting of multiple tables are almost always essential. The public preview of a brand-new data experience that simplifies working with complex data models in an Entity Relationship Diagram (ERD) view with the assistance of Copilot. This innovative feature allows you to seamlessly work with data from a variety of sources, including natural language inputs, Excel files, and SharePoint lists, all through a simple drag-and-drop interface akin to how you currently interact with app visuals. Accessing the ERD data experience Navigate to make.powerapps.com>Select the required environment>Enable the new data experience feature Once enabled, the new da...
Read more