Skip to main content

Questions tagged [power-platform]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
1 answer
3k views

PowerApps - How to write a "Contains" statement

I have a PowerApps form where I've added some checkboxes, and I want to reference a dropdown field's selection for those checkbox default values. The issue I'm having is that the choice field is ...
Chris's user avatar
  • 409
0 votes
1 answer
25 views

licensing requirements to use PREMIUM connector when calling workflow after adding SharePoint item

We want to create a workflow which use this Premium action: The workflow will run as an automated flow when a SharePoint custom list item is created >> where the workflow will create a document ...
microsoftdeveloperdesigner's user avatar
0 votes
1 answer
70 views

How i can dynamically build part of a string array inside Compose

I have this JSON array which I am passing as part of an http request body: Here is the string: "peoplePickerInput":"[ { \"Key\":\"@{items('Apply_to_each_-_Certificates_2'...
microsoftdeveloperdesigner's user avatar
0 votes
2 answers
444 views

Service account with MFA enabled , how to transfer the membership/ownership to the client after completing the project

I am working on a project for external client >> and I needed to create some SharePoint lists, solutions & Power automate flows. Now they gave me a service account username/password, and the ...
microsoftdeveloperdesigner's user avatar
0 votes
0 answers
49 views

why a user who have been assigned "Basic User" role on a production environment can not see the environment

I have created a new Environment of type production + which have a data verse data source. Then i went to Security role >> add a test user to the "Basic User" role as follow: - and ...
microsoftdeveloperdesigner's user avatar
0 votes
0 answers
68 views

Why a user can not see a production environment , even he is added to the environment security group

I created a new Power Platform environment of type Production >> and i added a security group named "Prod users" >> then I added a user named "Test User" to the ...
microsoftdeveloperdesigner's user avatar
0 votes
0 answers
21 views

I am totally confused, any user can delete my solution? can we prevent this?

I created a solution which contain 2 power apps + 2 workflows. and just for fun/testing >> i created a test office 365 user with no license on Power Platform >> this trail user was able to ...
microsoftdeveloperdesigner's user avatar
0 votes
1 answer
345 views

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

As an admin I created 2 flows inside a solution: Scheduled flow which runs on schedule basis. Instant flow which is called from the Scheduled flow Now the Schedule flow will call the instant flow ...
microsoftdeveloperdesigner's user avatar
0 votes
2 answers
698 views

How can I write an Expression to get an Item from an Array using an Array property value?

I have this flow : Where I am building an array which contain those properties: ID SharingLink Password then I am building an HTML table >> so how can I get the Array's SharingLink values ...
microsoftdeveloperdesigner's user avatar
0 votes
1 answer
1k views

Unable to create a Solution "Provision cannot be performed because there is no linked CDS instance or the CDS instance version is not supported."

I am working on a new Power Platform environment, and when I tried to create a new Solution >> I got this screen: and then I tried to create a new database, I got this error: Any advice?
microsoftdeveloperdesigner's user avatar
0 votes
1 answer
160 views

Power Automate - Slow performance - date formatting from excel , copying to list

I have this workflow where I have two apply to each and many compose fields. Is there a way to optimize this for faster execution? I am getting an error about slow running. The excel table has only ...
Jonnyboi's user avatar
0 votes
1 answer
1k views

Power automate concatenate different columns

I need to concatenate three columns, two of which are calculated when calculated. I cannot join them in a list validation way. I would need to know how to do it in power apps. Thanks.
tovans88's user avatar
0 votes
1 answer
1k views

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

My "Apply to Each" - "value" is coming from Get Tables, shouldnt it be coming from "List rows present in a table" but this option is not available in dropdown. If I do ...
Jonnyboi's user avatar
0 votes
1 answer
47 views

Get Items is not getting the latest items

I have a SharePoint list with around 100,000 items, and I have 5600++ items with a field named ExpiryDate = 7 June 2023 but when I defined the following Get_Items inside a manual flow (which get ...
microsoftdeveloperdesigner's user avatar
0 votes
0 answers
20 views

Group the Get_Items output by a single_line of text field

I have a SharePoint list with 3 columns:- And i am getting the items based on the ExpiryDate as follow inside a scheduled workflow:- now this will get the list items which have their expiry date ...
microsoftdeveloperdesigner's user avatar
0 votes
2 answers
195 views

Will Get Items be able to search all the records inside SharePoint list or it will only search the first 100,000 items

I have a large SharePoint list with around 2.5++ million items >> and I defined to only get the items with Status = "Active" and order the items by Modified data in descending order, ...
microsoftdeveloperdesigner's user avatar
0 votes
1 answer
466 views

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

I have a custom list named "Customer code", with those values: Now I define an automated workflow >> which runs when an item is deleted. but inside this workflow how I can get the ...
microsoftdeveloperdesigner's user avatar
0 votes
1 answer
30 views

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

I have a Get Item action to return list items. then I want to build a comma separated string for all the titles. I tried this: join(outputs('Get_items')?['body/value']?['Title'],';')' and this: join(...
microsoftdeveloperdesigner's user avatar
0 votes
1 answer
2k views

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

I'm working on a project I need to be able to: Scan through few lists(around 10) based on some criteria and then send a single email with some basic information Title and a link to the item. My ...
naijacoder's user avatar
  • 4,282
1 vote
2 answers
6k views

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

I am trying to use the output and conversion of my compose 2 into the create items. How can I do this? no outputs option - full flow - items('Apply_to_each')?[concat('Period Planned ','/',' Revised ...
Jonnyboi's user avatar
1 vote
1 answer
357 views

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

I have a service account with the following licenses: and we define a scheduled workflow that run on out list items each day at 12:00 am. the scheduled workflow has an action to get sharepoint items, ...
microsoftdeveloperdesigner's user avatar
0 votes
1 answer
660 views

Power Automate Flow - Trigger Condition

I have a list with a lot of flows doing certain things at different points. One flow I'm working on is to send an email notification when an item's Status equals Approved. The flow I have right now ...
Chris's user avatar
  • 409
0 votes
1 answer
352 views

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

How come my flow is only creating a certain amount of items? I am trying to copy from my table (online excel) to a list. Would there ever be a reason to only copying over 255 items? I have checked I ...
Jonnyboi's user avatar
0 votes
1 answer
2k views

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

I have a People/Group SharePoint field named "Person" which allow multiple selection >> and I am getting the related list items (which contain the "Person" field) using Get ...
John John's user avatar
0 votes
1 answer
177 views

Email notification when someone add a new member to a task in a Microsoft List

I'm a beginner in Power Automate and I need someone support in the following topic? I found this online, it's kind of similar with my topic but I don't know what to adjust https://www.office365notes....
user107467's user avatar
1 vote
1 answer
286 views

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

In Power Apps there is an option to automatically create environment variables when connecting to data source. So in Power automate is there similar option? if not, then how we can manually create ...
John John's user avatar
0 votes
1 answer
4k views

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

We have developed a solution which contain multiple apps and multiple flow inside our Dev environment. then we imported the solution and export it inside our PROD environment and define the PROD as ...
John John's user avatar
0 votes
1 answer
1k views

How to get the 3rd element after doing a split

I have this formula to concatenation and get the last element after doing a split:- concat(body('GetRootFolder')['d']['ServerRelativeUrl'], '/', 'Closed','/',last(split(items('Apply_to_each'),'#;'))) ...
John John's user avatar
0 votes
1 answer
1k views

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

How to get values from array with Composeaction? I will try Azure Cognitive Service - Extract information from invoices. There is an Array called keyValuePairs. How I can get to single values ? ...
Novice's user avatar
  • 139
0 votes
1 answer
2k views

How to extract ONLY numbers from string using Power Automate

I have free text column in Dataverse table where alphanumeric values are entered e.g. abc123, 123abc, 1abc23. (numbers can be anywhere in string - no fix pattern) I want to extract ONLY numbers and ...
Guy World's user avatar
0 votes
1 answer
329 views

Update Phone to Tablet Layout PowerApps

Hi we have completed an application Phone Layout and there is a request to have Desktop/Tablet layout for it. Should we creating a new copy and convert it manually to Tablet/Desktop or check and ...
BizApps's user avatar
  • 733
1 vote
1 answer
11 views

Take data from Multiple Line String and create multiple new Datasets

I have two lists: Bin Data: BinBarcode Tapes inside 12345678 MA0053L8/nMA0053L8/nMB0030M8 Tape Data Tape Barcode Bin I want to automate when a entery is put into Bin Data. It creates multiple ...
Rhys McQueen's user avatar
0 votes
1 answer
14 views

Nof replacements counter not working as expected

Update item Noofassignments field has below expression and its working as expected So when first time if for item modified with status active then Noofassignments counter will be 1 and ...
Bzl's user avatar
  • 39
0 votes
2 answers
2k views

Power Automate - Workflow to update properties of new file only

I have a SharePoint Library (modern) in which there are numerous files already uploaded, and more get uploaded every few days. I have a "Reminder Days" column (Date) that I'd like to add 30 ...
Chris's user avatar
  • 409
0 votes
2 answers
3k views

Power automate Flow, Do not create new records if they exist

How can I not create duplicates with my flow? I want to create records from List A into List B IF they don't already exist in B, if they already exit, DO NOT create them, as it is creating duplicates. ...
Jonnyboi's user avatar
0 votes
1 answer
464 views

When item modified with trigger condition it should trigger email

I have set below Trigger condition when item create or modified @and(equals(triggerOutputs()?['body/SRVolunteer/Value'],'Yes'),equals(triggerOutputs()?['body/SRroles/Value'],null)) Issue: It is ...
Bzl's user avatar
  • 39
1 vote
1 answer
289 views

Unable to reference a environment variable inside our Site Address property inside a cloud flow

We have a solution with 2 environment variables: One which reference a SharePoint site The other reference a SharePoint list Now when we created a new cloud flow inside our solution >> we are ...
John John's user avatar
0 votes
2 answers
528 views

Change the site URL for all the actions inside our imported Cloud Power automate Flow

We have created a SharePoint test site and and Power Automate cloud flow, where on most of the action we have define the site URL a follow: Now we will export this Flow and import it again then we ...
John John's user avatar
0 votes
1 answer
484 views

capture what have been changed inside Dataverse tables and update sharepoint lists accordingly using Power Automate flow

We have 2 data-verse tables named Invoices & Accounts + 2 SharePoint lists named Invoices_Logs & Accounts_logs. the dataverse tables will contain the actual values and the SharePoint lists ...
John John's user avatar
0 votes
2 answers
3k views

what we can do to create a copy of a Power Apps and its related Power Automate Flows without having to change the components names

We have a Power Apps Canvas App >> and it is connected to 10 SharePoint lists >> and it have 5 Power automate flows which get triggered from Power apps. Now we published this app to ...
John John's user avatar
1 vote
1 answer
1k views

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

We are planning to create a SharePoint online site and inside it we will create 50 document libraries. Now we need to have a single power automate flow which will trigger when uploading new documents ...
John John's user avatar
1 vote
1 answer
3k views

Get the browser url inside my Canvas app

I need to get the browser URL inside Power App canvas standalone app, is this possible? I do not want to get parameters, I want the whole URL.
John John's user avatar
0 votes
1 answer
292 views

Call a reusable flow from existing Automated Cloud flow

I have an automated cloud flow which create 10 items inside 10 different lists. now for each item i want to set unique permission. so can i create a reusable flow which accept 2 parameters: ItemID ...
John John's user avatar
0 votes
1 answer
401 views

Get the email address from SharePoint list and build Table inside Power Apps instead of hard-coding the values

We have the following Collection which contain a Type and Table of Email addresses inside Power App formula, with email addresses been hard coded, as follow: ClearCollect( varUserForContracts, ...
John John's user avatar
0 votes
1 answer
556 views

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

We are working on a new SharePoint project, where the customer does not have any SharePoint licenses yet, and they want to use SharePoint On-Premises. So I have the following questions, If can we use ...
John John's user avatar
0 votes
1 answer
1k views

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

I want to get a security group ID by name, so i tried this HTTP request action, by passing this uri (https://graph.microsoft.com/v1.0/groups?$filter=displayname eq 'SEC-Project Repository Hub-Visitors'...
John John's user avatar
1 vote
0 answers
353 views

How to secure the 2-stage approval application using SharePoint & Power Apps & Power Automate

We have a travel request application. where a user submit a request where it should go into 2 stages of approval process before it gets Final Approval. Now we did the following:- Create a SharePoint ...
John John's user avatar
1 vote
2 answers
777 views

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

We have 2 fields: one which is a free text and the other is a combo-box. we have 2 barcodes, so can we scan the 2 barcodes and add their values inside the text and the combo-box fields? As I were ...
John John's user avatar
0 votes
1 answer
931 views

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

We have a flow which create a new file as follow (this will create a new version of the file, by replacing existing file):- and we set the following setting for the create a new file action:- when ...
John John's user avatar
0 votes
1 answer
166 views

Dataverse Filter option missing

I am a bit lost with dataverse table. The last time I checked, I saw a filter that allows me to filter and show only custom columns. I checked today but it is gone. Are there any changes in design ...
love thakker's user avatar
  • 1,136