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 ...
- 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 ...
- 42.9k
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 ...
- 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.
...
- 6,748
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",
&...
- 2,142
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 ...
- 9,572
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 ...
- 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
- 214
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" ...
- 417
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-...
- 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 ...
- 2,142
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": "...
- 42.9k
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')...
- 42.9k
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 ...
- 42.9k
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 ...
- 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 ...
- 42.9k
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 ...
- 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
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 ...
- 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 ...
- 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 @...
- 6,748
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 ...
- 12.6k
2
votes
Accepted
SharePoint file name help
Try using this formula:
formatDateTime(startOfMonth(addToTime(utcNow(), -1, 'Month')),'dd/MM/yyyy')
- 42.9k
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. (...
- 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-...
- 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 ...
- 426
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 ...
- 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 ...
- 42.9k
Only top scored, non community-wiki answers of a minimum length are eligible