Skip to main content
2 votes
Accepted

Can we create a single Power Automate flow which trigger when uploading documents inside 50 document libraries

Consider below approaches for your requirements: A. Using Premium Connector: You can use HTTP action to trigger flow from multiple document libraries/lists in SharePoint. Follow below articles for ...
Ganesh Sanap - MVP's user avatar
2 votes
Accepted

Allow a user to run an instant flow without the ability to modify it

You can grant Run only users permissions to Project manager so that they can run the instant flow manually. Follow below steps: Go to flow details page Click on Edit next to Run only users section: ...
Ganesh Sanap - MVP's user avatar
2 votes
Accepted

PowerApps - How to write a "Contains" statement

Try using formula in below format: If("Advisory" in DatacardValue37.Selected.Value, true, false) Microsoft official documentation: Power Apps in Operator
Ganesh Sanap - MVP's user avatar
2 votes
Accepted

Power Apps Premium License Vs Power Automate Premium License? is there any overlap between them

Power Apps Premium license is the new name for Power Apps per user license (Power Apps per app is still an option). Similary, Power Automate Premium is the new name of Power Automate per user. Power ...
jleture's user avatar
  • 1,091
2 votes
Accepted

"Component Library" link is missing

It looks like Microsoft changed that page quite a bit. The Component Library can now be found clicking the options on the left hand-side panel. "...More" -> "Discover all"
Murilo Santana's user avatar
2 votes
Accepted

Create subfolders when a new folder is created

Here is the working flow I just created and tested: Run history output: Document library output - created folders: Flow Details: Trigger conditions: I have added similar trigger conditions you have ...
Ganesh Sanap - MVP's user avatar
1 vote

Get the browser url inside my Canvas app

You cannot read the complete browser URL using the default functions available in Power Apps. However, you can get the app details like GUID, app name, description, etc. using Power Apps for Makers ...
Ganesh Sanap - MVP's user avatar
1 vote
Accepted

Call a reusable flow from existing Automated Cloud flow

Yes, you can call reusable power automate flow from your automated cloud flow. You need to create/add both flows in single solution. Refer this Microsoft official documentation related to child flows: ...
Ganesh Sanap - MVP's user avatar
1 vote

Can we have Power Apps and Power Automate inside SharePoint On-premises

You can use on-premises data gateway to connect with SharePoint on-premises sites/lists in Power Apps and Power Automate. Check below documentations for more information: What is an on-premises data ...
Ganesh Sanap - MVP's user avatar
1 vote
Accepted

Unable to get a security group ID by name using Graph API. Error "URI path is not a valid Graph endpoint," inside our power automate flow

There's a "quirk" with both the Send an HTTP request and the Send an HTTP request actions. If you have a query string, you need to include a forward slash before the query string starts. ...
Rob Windsor's user avatar
  • 12.7k
1 vote

Can we scan barcodes when we are using the power apps on the web

As per Microsoft official documentations: Barcode scanner control in Power Apps Limitations of controls in canvas apps When using desktop browsers, the barcode scanner isn't supported. Use the Power ...
Ganesh Sanap - MVP's user avatar
1 vote
Accepted

can we force unlock the file before creating a new version of it inside Power Automate

I don't think you can force unlock the file. What I have done in these situations is to put the action in a Do Until loop and use Run After checking to see if the action failed. The setup goes like ...
teylyn's user avatar
  • 9,044
1 vote
Accepted

Dataverse Filter option missing

Yes, this is missing/have been removed. Alternatively you can filter on column "Name" to filter all custom columns. Example in my case , Filter applied on "Name" column to get all ...
Saira's user avatar
  • 608
1 vote
Accepted

External API compatibility with Custom connectors

Implicit Grant and Client Credentials Grant flows cannot be used to authenticate Custom Connectors. "Note that only Authorization Code Grant flows and On-Behalf-Of flows support refresh tokens (...
Callum Crowley's user avatar
1 vote

External API compatibility with Custom connectors

I asked the same questions months ago, and i found that the article of Wael Kdouh is very useful and detailed. You will find all the required details you need in order to build your custom connector ...
AIMEN BOULAHIA's user avatar
1 vote
Accepted

Is there a way to export then import custom connector from one environment to another

You can add your custom connector in a solution in power platform environment. Then you can export the solution and import it in another environment/tenant. Check the documentation of Power platform ...
Ganesh Sanap - MVP's user avatar
1 vote
Accepted

Power automate flow - Cannot use 'list rows in present table' in apply to each

Use your "Apply to each" action inside "Apply to each 2" action, after "List rows present in a table" action. Then you will be able to use the value array from "List ...
Ganesh Sanap - MVP's user avatar
1 vote

Get Items is not getting the latest items

Try generating and using SharePoint REST API endpoint in Get Items action in Power automate flow like this: https://****.sharepoint.com/sites/test/_api/web/lists/getbytitle('ListData')/items?$filter=(...
Ganesh Sanap - MVP's user avatar
1 vote
Accepted

How i can get a custom column value for a deleted item inside my "When an item is Delete" flow

This is a known issue/limitation with When an item is deleted trigger in Power automate flows. When the flow runs, item is already deleted from SharePoint list so it only returns basic properties like ...
Ganesh Sanap - MVP's user avatar
1 vote
Accepted

How I can build a string from the Title values return from Get Items action?

Use flow like this: Expression in compose action: join(body('Select'), ';') Output:
Ganesh Sanap - MVP's user avatar
1 vote
Accepted

Getting items from multiple lists power automate and send in a single email

Use flow like this: Expression used in compose action: item()?['Title']
Ganesh Sanap - MVP's user avatar
1 vote

Power Automate - How to use output of compose to create item?

Follow below steps to use output of compose action inside inputs to create item action: Go to create item action and click inside the textbox against your targeted column where you want to use the ...
Ganesh Sanap - MVP's user avatar
1 vote

Set the Pagination for SharePoint Get Items to be more than 100,000 inside our Power Automate flow

I don't think it is possible using Power automate flow to get more than 100,000 items using single Get items action. 100,000 items is the most you can get with High performance profile. Here's is ...
Ganesh Sanap - MVP's user avatar
1 vote
Accepted

Power Automate Flow - Trigger Condition

Use trigger condition in below format: @equals(triggerOutputs()?['body/PMOFinalApproval/Value'], 'Approved') OR: @equals(triggerBody()?['PMOFinalApproval']?['Value'], 'Approved') Use correct ...
Ganesh Sanap - MVP's user avatar
1 vote
Accepted

Power automate, copy items from online excel to list, only a certain amount of items

By default List rows action in excel connector only returns 256 items. You can get more rows returned by setting a higher value for the pagination settings. Go to "List rows present in table&...
Ganesh Sanap - MVP's user avatar
1 vote
Accepted

Get the email addresses of a People/Group field which allow multiple selection inside my Select

Try this: Select Person in From property of Select action Use expression like below in Map property of Select action item()['Email'] Action: Output: You can also check my answer on this thread ...
Ganesh Sanap - MVP's user avatar
1 vote
Accepted

Is there an option to automatically create environment variables when connecting to data source

You can create new environment variable from solution. Follow below steps: Sign in to Power Apps portal (make.powerapps.com), and then on the left pane select Solutions. Open the solution where you ...
Ganesh Sanap - MVP's user avatar
1 vote
Accepted

How we can move a Power App from DEV to PROD using exsisting solution

You have redeploy whole solution, follow below steps: Go to solutions menu in DEV Select your solution > select Export Solution option from top menu Publish your changes Export solution as managed ...
Ganesh Sanap - MVP's user avatar
1 vote

How to get the 3rd element after doing a split

You can access a specific numbered element in an array using JSON notation. For example the following would return the 3rd element in the zero based array: split(items('Apply_to_each'),'#;')[2] So as ...
Ganesh Sanap - MVP's user avatar
1 vote
Accepted

Power automate Flow - Extract information from invoices - get value from keyValuePairs

If you want to get value from first object in array output, use: For key: first(variables('varArray'))?['key'] For value: first(variables('varArray'))?['value'] Or you can use Apply to each action ...
Ganesh Sanap - MVP's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible