6 votes
Accepted

What limitations should I keep in mind when choosing between single line of text or choice columns?

You are correct that you can't use a choice field in a lookup (but you can reference a choice field in a calculated column which can be used in lookups). However, there are some gotchas when it comes ...
theChrisKent's user avatar
  • 5,971
5 votes
Accepted

Get Email from user and enter into SharePoint list field

Solution 1: You can create a workflow or Microsoft flow/power automate to update the Email address field based on the Person or Group field. Solution 2: If you are not going to use those email address ...
Ganesh Sanap - MVP's user avatar
5 votes

"Send an Wait for Approval" inside a "Apply to each" will never end

Your current flow is creating a separate approval request for each member of the group instead of sending a single approval request to all members. I think you'll need to create a string variable and ...
user79408's user avatar
  • 945
4 votes
Accepted

Microsoft Flow: Single flow for multiple Forms

Microsoft Flow has trigger action When a new response is submitted where you have to set Form ID to listen this event when MS Forms is submitted. And it takes only one Form ID value in this control. ...
Dikesh Gandhi's user avatar
4 votes
Accepted

Power Automate - Get DisplayName from People object as text

Have you tried using Parse JSON action? For input to Parse JSON, use the Person object retrieved by Get Items action, and for Schema, use the below: { "type": "object", &...
Matiur Rahman's user avatar
4 votes
Accepted

Which Power automate/flow license removes the 90 days limitation

A cloud flow that has no successful triggers will expire and be turned off. After 90 days of inactivity, the flow creator will receive an email. If no action is taken in next 30 days, the flow will be ...
Denis Molodtsov's user avatar
4 votes

SharePoint Modern Library - Power Automate notification email - 6 Months after Created date

Theoretically, if you used the triggers for when an item/file is created, you would then use a Delay action to delay for six months, and then you would send the email. This issue with this technique ...
Rob Windsor's user avatar
  • 12.6k
3 votes
Accepted

What format is required when adding a value to a 'Choice > Allow multiple selections' column in a SharePoint list?

Make the join value this (a semicolon and a hash - ;#): Gleaned from this answer: https://sharepoint.stackexchange.com/a/78912
user1063287's user avatar
3 votes

Export/Import microsoft flow in SharePoint Online

Export a Flow: click on ellipsis "..." menu, select 'Export' then click on 'Package (.zip)' provide a name and a description for your package and configure other options click on the "Export" ...
SP Combatant's user avatar
3 votes

Power Automate - trigger an email when one of the field in the sharepoint list is yes

Please check this post from Powerusers forum. It contains what you need. Basically, you need use the SharePoint Connector Trigger for when a SharePoint item is created or modified and then a switch-...
UBK's user avatar
  • 1,213
3 votes
Accepted

Is it possible to add HTML buttons in send an email(V2) of Power automate. I want to create 3 buttons which has links to 3 different sharepoint sites

I don't think you can make html button () works in emails. However, you can create links () with pure CSS and elements that would looks like button. See sample of HTML used in [Send an email (V2)] MS ...
Matiur Rahman's user avatar
3 votes
Accepted

Trigger flow with icon instead of button?

You will require button element to use action and actionParams. However, you can add children elements to button element to add icon & text (if required). Example: { "$schema": "...
Ganesh Sanap - MVP's user avatar
3 votes
Accepted

/_api/web/sitegroups/GetByName('GroupName')

You can get the SharePoint group Id from API response (body) using Parse JSON action like below: Send HTTP Request action configuration: Method: GET Uri: _api/web/sitegroups/GetByName('Flow Owners')...
Ganesh Sanap - MVP's user avatar
3 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 ...
Ganesh Sanap - MVP's user avatar
3 votes

Power Automate - Embed 2 images within an email

Use two Get file content or Get file content using path actions to get the two images. Then use two variables to store their Base64 encoded content. Then use the variables when generating the body of ...
Rob Windsor's user avatar
  • 12.6k
3 votes
Accepted

Power Automate - Action 'Get_tables' failed

As you are deleting excel file and recreating it daily, there might be issue related to file identifier when you are selecting file from file picker in "Get tables" action. Instead of above ...
Ganesh Sanap - MVP's user avatar
3 votes

Build an instant flow which iterate over a SharePoint library that have 2 million documents and folders

As @Derek Gusoff mentioned, doing such a large bulk operation is tricky and will likely run into throttling issues, and while I would agree with the comment to push back on the idea of doing it all at ...
Dylan Cristy's user avatar
  • 12.6k
3 votes

Power Automate - How to Update SharePoint list with Approval Response

You have instructed to create an approval. If you need to return the outcome, you need to use Wait for an approval. Wait for an approval
ChengFeng - MSFT's user avatar
2 votes

List attachment to Document Library

Not sure if I understand your question completely. You can use Get Item (not Get Items!!) to get all properties of a list item. Then edit the properties of the file in its new location in the library ...
teylyn's user avatar
  • 8,867
2 votes
Accepted

How to build a dynamic form

No, MS Forms does not have the capability, you can do some branching logic within the Form, but only based on previous questions within the same Form. I think you would be better off building a ...
willman's user avatar
  • 3,714
2 votes
Accepted

Export/Import microsoft flow in SharePoint Online

There was no such functionality to import/export flows or any other backup option previously. But you can configure Data Loss Prevention (DLP) policies as shown here for prevention. UPDATE As per @...
Dikesh Gandhi's user avatar
2 votes

MS Flow time-out after 30 days

The answer is, it depends. If you want to build the approval as a single flow, then the answer is no for the reasons given by @Michael Han_MSFT. However, you could build a set of flows that ...
Rob Windsor's user avatar
  • 12.6k
2 votes
Accepted

SharePoint file name help

Try using this formula: formatDateTime(startOfMonth(addToTime(utcNow(), -1, 'Month')),'dd/MM/yyyy')
Ganesh Sanap - MVP's user avatar
2 votes

Get Email from user and enter into SharePoint list field

In addition to Ganesh Sanap’s Solution 1, here’s a sample flow for your reference. There is one dynamic content called PersonGroupCol Email, which you can directly use to update the Email column. (...
Chelsea_MSFT's user avatar
  • 4,502
2 votes

Power Auatomate/Flow - Attach a Flow to a SharePoint List/Library to trigger or create/update

Flow trigger based on site address, so you can't create a common flow to be used across multiple SharePoint sites. Reference: https://powerusers.microsoft.com/t5/General-Power-Automate/One-Flow-...
Julie_MSFT's user avatar
  • 4,197
2 votes
Accepted

Sharepoint Group Group ID

The "List group members" action can only get Office 365 groups. It does not allow us to get membership of SharePoint Groups. To get sharepoint groups, you can use the rest API call. Refer ...
Diksha Poddar's user avatar
2 votes

MS Flow ODATA filtering fails on ModerationStatus

The correct internal name for ModerationStatus column is OData__ModerationStatus. It is usually hidden from the UI. That's why you are facing the error that column doesn't exist . Please change it to ...
Gautam Sheth's user avatar
  • 30.8k
2 votes
Accepted

MS Flow ODATA filtering fails on ModerationStatus

Internal name of moderation status column is OData__ModerationStatus. So you need to use this in your filter query. It has below values: 0 = Approved 1 = Rejected 2 = Pending 3 = Draft So, in REST ...
Ganesh Sanap - MVP's user avatar

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