New answers tagged

0 votes

SharePoint list - How to limit items in list with formula

You cannot achieve this using calculate formula in SharePoint. You can try below to achieve your requirements: Create a power automate flow on item creation (and/or item update - as per you ...
0 votes

Create item with Person or Group column with HTTP request in Power Automate

To add items use AddValidateUpdateItemUsingPath instead of ValidateUpdateListItem. You should use the following formats for the FieldValue property for People or Group fields. The Key property value ...
  • 11.9k
1 vote
Accepted

Add flow expression to update item

Use power automate flow like below to get the last highest value in reference_number column and then update newly created item: Use correct "internal name" of your reference number column ...
1 vote
Accepted

auto generate column value whenever a new row is added

It depends a bit on your setup. If this expression is within an apply to each loop you could use: add(item()?['ReferenceNumber'],1) Otherwise it would probably be something like: add(outputs('...
1 vote
Accepted

What format do Microsoft Lists require date/time column values to be in when adding them from Power Automate?

SharePoint always stores the date & time values in UTC format and displays the date & time values in lists based on regional settings of site. You can pass values to date & time column in ...
0 votes

Send HTTP Request CopyTo File to different document library - Power Automate

Existing file path URL in getFileByServerRelativeUrl() endpoint should be in below format: /sites/siteName/libraryName/folderName/fileName.pdf Use correct path in "Send an HTTP request to ...
0 votes

When executing a flow from a button in a list column, how do you hide the button when more than one item is selected?

Unfortunately, JSON column formatting does not provide us the number of items selected in list view. So, you cannot conditionally show/hide the button when more than one item is selected in list view. ...
0 votes

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: ...
1 vote
Accepted

Users with contribute permission can call REST API to Break Role Inheritance , but can not make a REST API call to get all role assignments

I just tried the same scenario to get the role assignments of list items using power automate flow: Here are my findings: User Permissions Flow works/Error Contribute Error Edit Error Design ...
1 vote

Sending an email via SMTP connection in Power Automate

Please follow the below steps. Click ... three dots in email connector. Create new connection and use here generic service account that you are using usually for your connectors. You should not use ...
  • 543
1 vote

Does the Pagination Threshold setting in the Get Items action relate to how many items can be returned or how many items can be searched?

To confirm, the Get items action you are describing is "filtering" a data set rather than "searching". Searching implies it is using the SharePoint Search service which it is not. ...
0 votes

Any way to change "From" Text in Power Automate?

You could use send an email(V2) action ,click “show advanced option” Click ‘From (Send as)’, enter email address. So that you can set email sender.
0 votes

How to ask multiple questions with multiple choices in an E-Mail in Microsoft Power-Automate

You can use Adaptive Card where you can ask multiple input in email. Reference Links https://www.youtube.com/watch?v=ZiQ6tHGwNVg https://www.c-sharpcorner.com/article/power-automate-to-collect-...
0 votes

How to compare two columns in two different Sharepoint lists

How to compare items in two SharePoint lists in Power Automate Define the synchronized columns. The flow begins with the definition of the columns that are synchronized. Get items from both lists. To ...
2 votes

What is the default number of items that are retrieved in the Get Items action and what options are there for getting more than 5,000 items?

By default the Get items action retrieves only 100 items from a SharePoint list. If you want to retrieve more items from a SharePoint list, you can enable Pagination via the settings of the Get items ...
0 votes

Auto email is generated when another column is edited

You want to use the Has Colum Changed: dynamic content from the Get changes to an item or file (properties only) action to see if the specific column value has changed. Please note that the list or ...
  • 11.9k

Top 50 recent answers are included