web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
Season of Giving Solutions is Here!
Explore Copilot Studio Forums, Blogs & Galleries!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Base64 is producing to...
Power Automate
Unanswered

Base64 is producing too many images in my html table because of Append Variable

(0) ShareShare
ReportReport
Posted on by adriennevh 27

I have a flow which is pulling from a SharePoint Media Library. It is going to send the headshot proofs to all staff for their approval of the one they'd like to be their headshot.

I'll be giving the steps below in text and images. To keep it tidy I'll collapse the images as Spoilers. I'll put the input and output of each stage if applicable/valuable, and colour-code for references.

 

Update while I was writing this originally:

So... as i was ALMOST done writing this all out, i figured out the problem but not the solution

I'm Appending a Variable within an Apply to Each but it's still appending it for all of the runs as I have it set to concurrent. but I don't know how to change the input of the variable to be unique for each Employee receiving an email, but still only sending 1 email per employee. Help!

 

This is the email the testers are getting. Each of us should only be getting 2 images,  but we are all getting the same 4 as it's populated by the varRows. 

 

adriennevh_9-1708018257595.png

adriennevh_9-1708018257595.png

 

1. Manual Trigger

2. Get Items - with filter query Status eq 'Ready for Review'

3. Initialize Variable - varCSS - for the table CSS to be included in the email at the end

4. Initialize Variable - varTitle - String - Value: <table> <tr> <th> File Name </th> <th> Headshot </th>

5. Initialize Variable - varRows - String - Value: blank

6. Select - Users - From: Value: outputs('Get_items')?['body/value']

Map

Name: item()?['Employee/DisplayName']

Email: item()?['Employee/Email']

7. Compose - Unique Users

Inputs: union(body('Select_-_Users'),body('Select_-_Users'))

8. Initialize Variable - ImageBase64 - String - Value: blank

9. Apply to each - User - Select an output: outputs('Compose_-_Unique_Users')

9a. Scope - User Info

9a1. Compose - Users Full Name - Inputs: items('Apply_to_each_-_User')?['Name']

9a2. Compose - Users First Name - Inputs: first(split(outputs('Compose_-_Users_Full_Name'),' '))

9a3. Compose - Users Email Address - Inputs: items('Apply_to_each_-_User')?['Email']

9b. Scope - User Items

9b1. Filter array - User Items

Input result after run

 

Spoiler (Highlight to read)

From: outputs('Get_items')?['body/value']"}]

[
{
"@odata.etag": "\"19\"",
"ItemInternalId": "8",
"ID": 8,
"Status": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 1,
"Value": "Ready for review"
},
"Status#Id": 1,
"ProjectLead": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
"Claims": "i:0#.f|membership|Name1@domain.ca",
"DisplayName": "Name1",
"Email": "Name1@domain.ca",
"Picture": "https://domain.sharepoint.com/sites/IMDevEnvironment/_layouts/15/UserPhoto.aspx?Size=L&AccountName=Name1@domain.ca",
"Department": "IPC - CSD",
"JobTitle": "Information Management Specialist"
},
"ProjectLead#Claims": "i:0#.f|membership|Name1@domain.ca",
"MediaServiceImageTags": [
{
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedTaxonomy",
"TermGuid": "ffffffff-ffff-ffff-ffff-fffffffff006",
"WssId": 3,
"Label": "outdoor",
"Path": null,
"Value": "outdoor|ffffffff-ffff-ffff-ffff-fffffffff006"
}
],
"MediaServiceImageTags@odata.type": "#Collection(Microsoft.Azure.Connectors.SharePoint.SPListExpandedTaxonomy)",
"MediaServiceImageTags#WssId": [
3
],
"MediaServiceImageTags#WssId@odata.type": "#Collection(Int64)",
"Created": "2024-02-13T16:24:10Z",
"Author": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
"Claims": "i:0#.f|membership|Name1@domain.ca",
"DisplayName": "Name1",
"Email": "Name1@domain.ca",
"Picture": "https://domain.sharepoint.com/sites/IMDevEnvironment/_layouts/15/UserPhoto.aspx?Size=L&AccountName=Name1@domain.ca",
"Department": "IPC - CSD",
"JobTitle": "Information Management Specialist"
},
"Author#Claims": "i:0#.f|membership|Name1@domain.ca",
"Modified": "2024-02-14T19:00:43Z",
"Editor": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
"Claims": "i:0#.f|membership|Name1@domain.ca",
"DisplayName": "Name1",
"Email": "Name1@domain.ca",
"Picture": "https://domain.sharepoint.com/sites/IMDevEnvironment/_layouts/15/UserPhoto.aspx?Size=L&AccountName=Name1@domain.ca",
"Department": "IPC - CSD",
"JobTitle": "Information Management Specialist"
},
"Editor#Claims": "i:0#.f|membership|Name1@domain.ca",
"OData__DisplayName": "",
"{Identifier}": "Staff%2bHeadshots%2bfor%2bApproval%252fDoug%2b1%2bsmall.jpg",
"{IsFolder}": false,
"{Thumbnail}": {
Tumbnail Data Removed to shorten
},
"{Link}": "https://domain.sharepoint.com/sites/IMDevEnvironment/Staff%20Headshots%20for%20Approval/Doug%201%20small.jpg",
"{Name}": "Doug 1 small",
"{FilenameWithExtension}": "Doug 1 small.jpg",
"{Path}": "Staff Headshots for Approval/",
"{FullPath}": "Staff Headshots for Approval/Doug 1 small.jpg",
"{IsCheckedOut}": false,
"{VersionNumber}": "18.0"
},
{
"@odata.etag": "\"17\"",
"ItemInternalId": "9",
"ID": 9,
"Status": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 1,
"Value": "Ready for review"
},
"Status#Id": 1,
"ProjectLead": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
"Claims": "i:0#.f|membership|Name1@domain.ca",
"DisplayName": "Name1",
"Email": "Name1@domain.ca",
"Picture": "https://domain.sharepoint.com/sites/IMDevEnvironment/_layouts/15/UserPhoto.aspx?Size=L&AccountName=Name1@domain.ca",
"Department": "IPC - CSD",
"JobTitle": "Information Management Specialist"
},
"ProjectLead#Claims": "i:0#.f|membership|Name1@domain.ca",
"MediaServiceImageTags": [
{
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedTaxonomy",
"TermGuid": "ffffffff-ffff-ffff-ffff-fffffffff006",
"WssId": 3,
"Label": "outdoor",
"Path": null,
"Value": "outdoor|ffffffff-ffff-ffff-ffff-fffffffff006"
}
],
"MediaServiceImageTags@odata.type": "#Collection(Microsoft.Azure.Connectors.SharePoint.SPListExpandedTaxonomy)",
"MediaServiceImageTags#WssId": [
3
],
"MediaServiceImageTags#WssId@odata.type": "#Collection(Int64)",
"Created": "2024-02-13T18:35:49Z",
"Author": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
"Claims": "i:0#.f|membership|Name1@domain.ca",
"DisplayName": "Name1",
"Email": "Name1@domain.ca",
"Picture": "https://domain.sharepoint.com/sites/IMDevEnvironment/_layouts/15/UserPhoto.aspx?Size=L&AccountName=Name1@domain.ca",
"Department": "IPC - CSD",
"JobTitle": "Information Management Specialist"
},
"Author#Claims": "i:0#.f|membership|Name1@domain.ca",
"Modified": "2024-02-14T19:00:43Z",
"Editor": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
"Claims": "i:0#.f|membership|Name1@domain.ca",
"DisplayName": "Name1",
"Email": "Name1@domain.ca",
"Picture": "https://domain.sharepoint.com/sites/IMDevEnvironment/_layouts/15/UserPhoto.aspx?Size=L&AccountName=Name1@domain.ca",
"Department": "IPC - CSD",
"JobTitle": "Information Management Specialist"
},
"Editor#Claims": "i:0#.f|membership|Name1@domain.ca",
"OData__DisplayName": "",
"{Identifier}": "Staff%2bHeadshots%2bfor%2bApproval%252fDoug%2b2%2bsmall.jpg",
"{IsFolder}": false,
"{Thumbnail}": {
Tumbnail Data Removed to shorten
},
"{Link}": "https://domain.sharepoint.com/sites/IMDevEnvironment/Staff%20Headshots%20for%20Approval/Doug%202%20small.jpg",
"{Name}": "Doug 2 small",
"{FilenameWithExtension}": "Doug 2 small.jpg",
"{Path}": "Staff Headshots for Approval/",
"{FullPath}": "Staff Headshots for Approval/Doug 2 small.jpg",
"{IsCheckedOut}": false,
"{VersionNumber}": "16.0"
},
{
"@odata.etag": "\"4\"",
"ItemInternalId": "11",
"ID": 11,
"Status": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 1,
"Value": "Ready for review"
},
"Status#Id": 1,
"ProjectLead": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
"Claims": "i:0#.f|membership|andrew.nguyen@domain.ca",
"DisplayName": "Andrew Nguyen",
"Email": "Andrew.Nguyen@domain.ca",
"Picture": "https://domain.sharepoint.com/sites/IMDevEnvironment/_layouts/15/UserPhoto.aspx?Size=L&AccountName=Andrew.Nguyen@domain.ca",
"Department": null,
"JobTitle": null
},
"ProjectLead#Claims": "i:0#.f|membership|andrew.nguyen@domain.ca",
"MediaServiceImageTags": [],
"MediaServiceImageTags@odata.type": "#Collection(Microsoft.Azure.Connectors.SharePoint.SPListExpandedTaxonomy)",
"MediaServiceImageTags#WssId": [],
"MediaServiceImageTags#WssId@odata.type": "#Collection(Int64)",
"Created": "2024-02-14T19:27:59Z",
"Author": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
"Claims": "i:0#.f|membership|Name1@domain.ca",
"DisplayName": "Name1",
"Email": "Name1@domain.ca",
"Picture": "https://domain.sharepoint.com/sites/IMDevEnvironment/_layouts/15/UserPhoto.aspx?Size=L&AccountName=Name1@domain.ca",
"Department": "IPC - CSD",
"JobTitle": "Information Management Specialist"
},
"Author#Claims": "i:0#.f|membership|Name1@domain.ca",
"Modified": "2024-02-14T19:29:08Z",
"Editor": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
"Claims": "i:0#.f|membership|Name1@domain.ca",
"DisplayName": "Name1",
"Email": "Name1@domain.ca",
"Picture": "https://domain.sharepoint.com/sites/IMDevEnvironment/_layouts/15/UserPhoto.aspx?Size=L&AccountName=Name1@domain.ca",
"Department": "IPC - CSD",
"JobTitle": "Information Management Specialist"
},
"Editor#Claims": "i:0#.f|membership|Name1@domain.ca",
"OData__DisplayName": "",
"{Identifier}": "Staff%2bHeadshots%2bfor%2bApproval%252fStock%2bimage%2b1.jpg",
"{IsFolder}": false,
"{Thumbnail}": {
Tumbnail Data Removed to shorten
},
"{Link}": "https://domain.sharepoint.com/sites/IMDevEnvironment/Staff%20Headshots%20for%20Approval/Stock%20image%201.jpg",
"{Name}": "Stock image 1",
"{FilenameWithExtension}": "Stock image 1.jpg",
"{Path}": "Staff Headshots for Approval/",
"{FullPath}": "Staff Headshots for Approval/Stock image 1.jpg",
"{IsCheckedOut}": false,
"{VersionNumber}": "4.0"
},
{
"@odata.etag": "\"3\"",
"ItemInternalId": "12",
"ID": 12,
"Title": "Customer service. Woman operator call center with headphones and microphone with laptop. Support, assistance, call center, hot line, help, response, consultation. Vector illustration",
"Status": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 1,
"Value": "Ready for review"
},
"Status#Id": 1,
"ProjectLead": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
"Claims": "i:0#.f|membership|andrew.nguyen@domain.ca",
"DisplayName": "Andrew Nguyen",
"Email": "Andrew.Nguyen@domain.ca",
"Picture": "https://domain.sharepoint.com/sites/IMDevEnvironment/_layouts/15/UserPhoto.aspx?Size=L&AccountName=Andrew.Nguyen@domain.ca",
"Department": null,
"JobTitle": null
},
"ProjectLead#Claims": "i:0#.f|membership|andrew.nguyen@domain.ca",
"MediaServiceImageTags": [],
"MediaServiceImageTags@odata.type": "#Collection(Microsoft.Azure.Connectors.SharePoint.SPListExpandedTaxonomy)",
"MediaServiceImageTags#WssId": [],
"MediaServiceImageTags#WssId@odata.type": "#Collection(Int64)",
"Created": "2024-02-14T19:27:59Z",
"Author": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
"Claims": "i:0#.f|membership|Name1@domain.ca",
"DisplayName": "Name1",
"Email": "Name1@domain.ca",
"Picture": "https://domain.sharepoint.com/sites/IMDevEnvironment/_layouts/15/UserPhoto.aspx?Size=L&AccountName=Name1@domain.ca",
"Department": "IPC - CSD",
"JobTitle": "Information Management Specialist"
},
"Author#Claims": "i:0#.f|membership|Name1@domain.ca",
"Modified": "2024-02-14T19:29:16Z",
"Editor": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
"Claims": "i:0#.f|membership|Name1@domain.ca",
"DisplayName": "Name1",
"Email": "Name1@domain.ca",
"Picture": "https://domain.sharepoint.com/sites/IMDevEnvironment/_layouts/15/UserPhoto.aspx?Size=L&AccountName=Name1@domain.ca",
"Department": "IPC - CSD",
"JobTitle": "Information Management Specialist"
},
"Editor#Claims": "i:0#.f|membership|Name1@domain.ca",
"OData__DisplayName": "",
"{Identifier}": "Staff%2bHeadshots%2bfor%2bApproval%252fStock%2bimage%2b2.jpg",
"{IsFolder}": false,
"{Thumbnail}": {
Tumbnail Data Removed to shorten"
},
"{Link}": "https://domain.sharepoint.com/sites/IMDevEnvironment/Staff%20Headshots%20for%20Approval/Stock%20image%202.jpg",
"{Name}": "Stock image 2",
"{FilenameWithExtension}": "Stock image 2.jpg",
"{Path}": "Staff Headshots for Approval/",
"{FullPath}": "Staff Headshots for Approval/Stock image 2.jpg",
"{IsCheckedOut}": false,
"{VersionNumber}": "3.0"
}
]

From: outputs('Get_items')?['body/value']"}][{"@odata.etag": "\"19\"","ItemInternalId": "8","ID": 8,"Status": {"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id": 1,"Value": "Ready for review"},"Status#Id": 1,"ProjectLead": {"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser","Claims": "i:0#.f|membership|Name1@domain.ca","DisplayName": "Name1","Email": "Name1@domain.ca","Picture": "https://domain.sharepoint.com/sites/IMDevEnvironment/_layouts/15/UserPhoto.aspx?Size=L&AccountName=Name1@domain.ca","Department": "IPC - CSD","JobTitle": "Information Management Specialist"},"ProjectLead#Claims": "i:0#.f|membership|Name1@domain.ca","MediaServiceImageTags": [{"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedTaxonomy","TermGuid": "ffffffff-ffff-ffff-ffff-fffffffff006","WssId": 3,"Label": "outdoor","Path": null,"Value": "outdoor|ffffffff-ffff-ffff-ffff-fffffffff006"}],"MediaServiceImageTags@odata.type": "#Collection(Microsoft.Azure.Connectors.SharePoint.SPListExpandedTaxonomy)","MediaServiceImageTags#WssId": [3],"MediaServiceImageTags#WssId@odata.type": "#Collection(Int64)","Created": "2024-02-13T16:24:10Z","Author": {"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser","Claims": "i:0#.f|membership|Name1@domain.ca","DisplayName": "Name1","Email": "Name1@domain.ca","Picture": "https://domain.sharepoint.com/sites/IMDevEnvironment/_layouts/15/UserPhoto.aspx?Size=L&AccountName=Name1@domain.ca","Department": "IPC - CSD","JobTitle": "Information Management Specialist"},"Author#Claims": "i:0#.f|membership|Name1@domain.ca","Modified": "2024-02-14T19:00:43Z","Editor": {"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser","Claims": "i:0#.f|membership|Name1@domain.ca","DisplayName": "Name1","Email": "Name1@domain.ca","Picture": "https://domain.sharepoint.com/sites/IMDevEnvironment/_layouts/15/UserPhoto.aspx?Size=L&AccountName=Name1@domain.ca","Department": "IPC - CSD","JobTitle": "Information Management Specialist"},"Editor#Claims": "i:0#.f|membership|Name1@domain.ca","OData__DisplayName": "","{Identifier}": "Staff%2bHeadshots%2bfor%2bApproval%252fDoug%2b1%2bsmall.jpg","{IsFolder}": false,"{Thumbnail}": {Tumbnail Data Removed to shorten},"{Link}": "https://domain.sharepoint.com/sites/IMDevEnvironment/Staff%20Headshots%20for%20Approval/Doug%201%20small.jpg","{Name}": "Doug 1 small","{FilenameWithExtension}": "Doug 1 small.jpg","{Path}": "Staff Headshots for Approval/","{FullPath}": "Staff Headshots for Approval/Doug 1 small.jpg","{IsCheckedOut}": false,"{VersionNumber}": "18.0"},{"@odata.etag": "\"17\"","ItemInternalId": "9","ID": 9,"Status": {"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id": 1,"Value": "Ready for review"},"Status#Id": 1,"ProjectLead": {"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser","Claims": "i:0#.f|membership|Name1@domain.ca","DisplayName": "Name1","Email": "Name1@domain.ca","Picture": "https://domain.sharepoint.com/sites/IMDevEnvironment/_layouts/15/UserPhoto.aspx?Size=L&AccountName=Name1@domain.ca","Department": "IPC - CSD","JobTitle": "Information Management Specialist"},"ProjectLead#Claims": "i:0#.f|membership|Name1@domain.ca","MediaServiceImageTags": [{"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedTaxonomy","TermGuid": "ffffffff-ffff-ffff-ffff-fffffffff006","WssId": 3,"Label": "outdoor","Path": null,"Value": "outdoor|ffffffff-ffff-ffff-ffff-fffffffff006"}],"MediaServiceImageTags@odata.type": "#Collection(Microsoft.Azure.Connectors.SharePoint.SPListExpandedTaxonomy)","MediaServiceImageTags#WssId": [3],"MediaServiceImageTags#WssId@odata.type": "#Collection(Int64)","Created": "2024-02-13T18:35:49Z","Author": {"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser","Claims": "i:0#.f|membership|Name1@domain.ca","DisplayName": "Name1","Email": "Name1@domain.ca","Picture": "https://domain.sharepoint.com/sites/IMDevEnvironment/_layouts/15/UserPhoto.aspx?Size=L&AccountName=Name1@domain.ca","Department": "IPC - CSD","JobTitle": "Information Management Specialist"},"Author#Claims": "i:0#.f|membership|Name1@domain.ca","Modified": "2024-02-14T19:00:43Z","Editor": {"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser","Claims": "i:0#.f|membership|Name1@domain.ca","DisplayName": "Name1","Email": "Name1@domain.ca","Picture": "https://domain.sharepoint.com/sites/IMDevEnvironment/_layouts/15/UserPhoto.aspx?Size=L&AccountName=Name1@domain.ca","Department": "IPC - CSD","JobTitle": "Information Management Specialist"},"Editor#Claims": "i:0#.f|membership|Name1@domain.ca","OData__DisplayName": "","{Identifier}": "Staff%2bHeadshots%2bfor%2bApproval%252fDoug%2b2%2bsmall.jpg","{IsFolder}": false,"{Thumbnail}": {Tumbnail Data Removed to shorten},"{Link}": "https://domain.sharepoint.com/sites/IMDevEnvironment/Staff%20Headshots%20for%20Approval/Doug%202%20small.jpg","{Name}": "Doug 2 small","{FilenameWithExtension}": "Doug 2 small.jpg","{Path}": "Staff Headshots for Approval/","{FullPath}": "Staff Headshots for Approval/Doug 2 small.jpg","{IsCheckedOut}": false,"{VersionNumber}": "16.0"},{"@odata.etag": "\"4\"","ItemInternalId": "11","ID": 11,"Status": {"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id": 1,"Value": "Ready for review"},"Status#Id": 1,"ProjectLead": {"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser","Claims": "i:0#.f|membership|andrew.nguyen@domain.ca","DisplayName": "Andrew Nguyen","Email": "Andrew.Nguyen@domain.ca","Picture": "https://domain.sharepoint.com/sites/IMDevEnvironment/_layouts/15/UserPhoto.aspx?Size=L&AccountName=Andrew.Nguyen@domain.ca","Department": null,"JobTitle": null},"ProjectLead#Claims": "i:0#.f|membership|andrew.nguyen@domain.ca","MediaServiceImageTags": [],"MediaServiceImageTags@odata.type": "#Collection(Microsoft.Azure.Connectors.SharePoint.SPListExpandedTaxonomy)","MediaServiceImageTags#WssId": [],"MediaServiceImageTags#WssId@odata.type": "#Collection(Int64)","Created": "2024-02-14T19:27:59Z","Author": {"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser","Claims": "i:0#.f|membership|Name1@domain.ca","DisplayName": "Name1","Email": "Name1@domain.ca","Picture": "https://domain.sharepoint.com/sites/IMDevEnvironment/_layouts/15/UserPhoto.aspx?Size=L&AccountName=Name1@domain.ca","Department": "IPC - CSD","JobTitle": "Information Management Specialist"},"Author#Claims": "i:0#.f|membership|Name1@domain.ca","Modified": "2024-02-14T19:29:08Z","Editor": {"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser","Claims": "i:0#.f|membership|Name1@domain.ca","DisplayName": "Name1","Email": "Name1@domain.ca","Picture": "https://domain.sharepoint.com/sites/IMDevEnvironment/_layouts/15/UserPhoto.aspx?Size=L&AccountName=Name1@domain.ca","Department": "IPC - CSD","JobTitle": "Information Management Specialist"},"Editor#Claims": "i:0#.f|membership|Name1@domain.ca","OData__DisplayName": "","{Identifier}": "Staff%2bHeadshots%2bfor%2bApproval%252fStock%2bimage%2b1.jpg","{IsFolder}": false,"{Thumbnail}": {Tumbnail Data Removed to shorten},"{Link}": "https://domain.sharepoint.com/sites/IMDevEnvironment/Staff%20Headshots%20for%20Approval/Stock%20image%201.jpg","{Name}": "Stock image 1","{FilenameWithExtension}": "Stock image 1.jpg","{Path}": "Staff Headshots for Approval/","{FullPath}": "Staff Headshots for Approval/Stock image 1.jpg","{IsCheckedOut}": false,"{VersionNumber}": "4.0"},{"@odata.etag": "\"3\"","ItemInternalId": "12","ID": 12,"Title": "Customer service. Woman operator call center with headphones and microphone with laptop. Support, assistance, call center, hot line, help, response, consultation. Vector illustration","Status": {"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id": 1,"Value": "Ready for review"},"Status#Id": 1,"ProjectLead": {"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser","Claims": "i:0#.f|membership|andrew.nguyen@domain.ca","DisplayName": "Andrew Nguyen","Email": "Andrew.Nguyen@domain.ca","Picture": "https://domain.sharepoint.com/sites/IMDevEnvironment/_layouts/15/UserPhoto.aspx?Size=L&AccountName=Andrew.Nguyen@domain.ca","Department": null,"JobTitle": null},"ProjectLead#Claims": "i:0#.f|membership|andrew.nguyen@domain.ca","MediaServiceImageTags": [],"MediaServiceImageTags@odata.type": "#Collection(Microsoft.Azure.Connectors.SharePoint.SPListExpandedTaxonomy)","MediaServiceImageTags#WssId": [],"MediaServiceImageTags#WssId@odata.type": "#Collection(Int64)","Created": "2024-02-14T19:27:59Z","Author": {"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser","Claims": "i:0#.f|membership|Name1@domain.ca","DisplayName": "Name1","Email": "Name1@domain.ca","Picture": "https://domain.sharepoint.com/sites/IMDevEnvironment/_layouts/15/UserPhoto.aspx?Size=L&AccountName=Name1@domain.ca","Department": "IPC - CSD","JobTitle": "Information Management Specialist"},"Author#Claims": "i:0#.f|membership|Name1@domain.ca","Modified": "2024-02-14T19:29:16Z","Editor": {"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser","Claims": "i:0#.f|membership|Name1@domain.ca","DisplayName": "Name1","Email": "Name1@domain.ca","Picture": "https://domain.sharepoint.com/sites/IMDevEnvironment/_layouts/15/UserPhoto.aspx?Size=L&AccountName=Name1@domain.ca","Department": "IPC - CSD","JobTitle": "Information Management Specialist"},"Editor#Claims": "i:0#.f|membership|Name1@domain.ca","OData__DisplayName": "","{Identifier}": "Staff%2bHeadshots%2bfor%2bApproval%252fStock%2bimage%2b2.jpg","{IsFolder}": false,"{Thumbnail}": {Tumbnail Data Removed to shorten"},"{Link}": "https://domain.sharepoint.com/sites/IMDevEnvironment/Staff%20Headshots%20for%20Approval/Stock%20image%202.jpg","{Name}": "Stock image 2","{FilenameWithExtension}": "Stock image 2.jpg","{Path}": "Staff Headshots for Approval/","{FullPath}": "Staff Headshots for Approval/Stock image 2.jpg","{IsCheckedOut}": false,"{VersionNumber}": "3.0"}]

 

@equals(item()?['Employee/Email'], outputs('Compose_-_Users_Email_Address'))

Output result after run

 

Spoiler (Highlight to read)
[
{
"@odata.etag": "\"19\"",
"ItemInternalId": "8",
"ID": 8,
"Status": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 1,
"Value": "Ready for review"
},
"Status#Id": 1,
"ProjectLead": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
"Claims": "i:0#.f|membership|adrienne.vanhalem@ipc.on.ca",
"DisplayName": "Adrienne Van Halem",
"Email": "Adrienne.VanHalem@ipc.on.ca",
"Picture": "https://ipconca.sharepoint.com/sites/IMDevEnvironment/_layouts/15/UserPhoto.aspx?Size=L&AccountName=Adrienne.VanHalem@ipc.on.ca",
"Department": "IPC - CSD",
"JobTitle": "Information Management Specialist"
},
"ProjectLead#Claims": "i:0#.f|membership|adrienne.vanhalem@ipc.on.ca",
"MediaServiceImageTags": [
{
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedTaxonomy",
"TermGuid": "ffffffff-ffff-ffff-ffff-fffffffff006",
"WssId": 3,
"Label": "outdoor",
"Path": null,
"Value": "outdoor|ffffffff-ffff-ffff-ffff-fffffffff006"
}
],
"MediaServiceImageTags@odata.type": "#Collection(Microsoft.Azure.Connectors.SharePoint.SPListExpandedTaxonomy)",
"MediaServiceImageTags#WssId": [
3
],
"MediaServiceImageTags#WssId@odata.type": "#Collection(Int64)",
"Created": "2024-02-13T16:24:10Z",
"Author": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
"Claims": "i:0#.f|membership|adrienne.vanhalem@ipc.on.ca",
"DisplayName": "Adrienne Van Halem",
"Email": "Adrienne.VanHalem@ipc.on.ca",
"Picture": "https://ipconca.sharepoint.com/sites/IMDevEnvironment/_layouts/15/UserPhoto.aspx?Size=L&AccountName=Adrienne.VanHalem@ipc.on.ca",
"Department": "IPC - CSD",
"JobTitle": "Information Management Specialist"
},
"Author#Claims": "i:0#.f|membership|adrienne.vanhalem@ipc.on.ca",
"Modified": "2024-02-14T19:00:43Z",
"Editor": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
"Claims": "i:0#.f|membership|adrienne.vanhalem@ipc.on.ca",
"DisplayName": "Adrienne Van Halem",
"Email": "Adrienne.VanHalem@ipc.on.ca",
"Picture": "https://ipconca.sharepoint.com/sites/IMDevEnvironment/_layouts/15/UserPhoto.aspx?Size=L&AccountName=Adrienne.VanHalem@ipc.on.ca",
"Department": "IPC - CSD",
"JobTitle": "Information Management Specialist"
},
"Editor#Claims": "i:0#.f|membership|adrienne.vanhalem@ipc.on.ca",
"OData__DisplayName": "",
"{Identifier}": "Staff%2bHeadshots%2bfor%2bApproval%252fDoug%2b1%2bsmall.jpg",
"{IsFolder}": false,
"{Thumbnail}": {
Tumbnail Data Removed to shorten"
"{Link}": "https://ipconca.sharepoint.com/sites/IMDevEnvironment/Staff%20Headshots%20for%20Approval/Doug%201%20small.jpg",
"{Name}": "Doug 1 small",
"{FilenameWithExtension}": "Doug 1 small.jpg",
"{Path}": "Staff Headshots for Approval/",
"{FullPath}": "Staff Headshots for Approval/Doug 1 small.jpg",
"{IsCheckedOut}": false,
"{VersionNumber}": "18.0"
},
{
"@odata.etag": "\"17\"",
"ItemInternalId": "9",
"ID": 9,
"Status": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 1,
"Value": "Ready for review"
},
"Status#Id": 1,
"ProjectLead": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
"Claims": "i:0#.f|membership|adrienne.vanhalem@ipc.on.ca",
"DisplayName": "Adrienne Van Halem",
"Email": "Adrienne.VanHalem@ipc.on.ca",
"Picture": "https://ipconca.sharepoint.com/sites/IMDevEnvironment/_layouts/15/UserPhoto.aspx?Size=L&AccountName=Adrienne.VanHalem@ipc.on.ca",
"Department": "IPC - CSD",
"JobTitle": "Information Management Specialist"
},
"ProjectLead#Claims": "i:0#.f|membership|adrienne.vanhalem@ipc.on.ca",
"MediaServiceImageTags": [
{
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedTaxonomy",
"TermGuid": "ffffffff-ffff-ffff-ffff-fffffffff006",
"WssId": 3,
"Label": "outdoor",
"Path": null,
"Value": "outdoor|ffffffff-ffff-ffff-ffff-fffffffff006"
}
],
"MediaServiceImageTags@odata.type": "#Collection(Microsoft.Azure.Connectors.SharePoint.SPListExpandedTaxonomy)",
"MediaServiceImageTags#WssId": [
3
],
"MediaServiceImageTags#WssId@odata.type": "#Collection(Int64)",
"Created": "2024-02-13T18:35:49Z",
"Author": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
"Claims": "i:0#.f|membership|adrienne.vanhalem@ipc.on.ca",
"DisplayName": "Adrienne Van Halem",
"Email": "Adrienne.VanHalem@ipc.on.ca",
"Picture": "https://ipconca.sharepoint.com/sites/IMDevEnvironment/_layouts/15/UserPhoto.aspx?Size=L&AccountName=Adrienne.VanHalem@ipc.on.ca",
"Department": "IPC - CSD",
"JobTitle": "Information Management Specialist"
},
"Author#Claims": "i:0#.f|membership|adrienne.vanhalem@ipc.on.ca",
"Modified": "2024-02-14T19:00:43Z",
"Editor": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
"Claims": "i:0#.f|membership|adrienne.vanhalem@ipc.on.ca",
"DisplayName": "Adrienne Van Halem",
"Email": "Adrienne.VanHalem@ipc.on.ca",
"Picture": "https://ipconca.sharepoint.com/sites/IMDevEnvironment/_layouts/15/UserPhoto.aspx?Size=L&AccountName=Adrienne.VanHalem@ipc.on.ca",
"Department": "IPC - CSD",
"JobTitle": "Information Management Specialist"
},
"Editor#Claims": "i:0#.f|membership|adrienne.vanhalem@ipc.on.ca",
"OData__DisplayName": "",
"{Identifier}": "Staff%2bHeadshots%2bfor%2bApproval%252fDoug%2b2%2bsmall.jpg",
"{IsFolder}": false,
"{Thumbnail}": {
Tumbnail Data Removed to shorten"
},
"{Link}": "https://ipconca.sharepoint.com/sites/IMDevEnvironment/Staff%20Headshots%20for%20Approval/Doug%202%20small.jpg",
"{Name}": "Doug 2 small",
"{FilenameWithExtension}": "Doug 2 small.jpg",
"{Path}": "Staff Headshots for Approval/",
"{FullPath}": "Staff Headshots for Approval/Doug 2 small.jpg",
"{IsCheckedOut}": false,
"{VersionNumber}": "16.0"
}
]
[{"@odata.etag": "\"19\"","ItemInternalId": "8","ID": 8,"Status": {"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id": 1,"Value": "Ready for review"},"Status#Id": 1,"ProjectLead": {"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser","Claims": "i:0#.f|membership|adrienne.vanhalem@ipc.on.ca","DisplayName": "Adrienne Van Halem","Email": "Adrienne.VanHalem@ipc.on.ca","Picture": "https://ipconca.sharepoint.com/sites/IMDevEnvironment/_layouts/15/UserPhoto.aspx?Size=L&AccountName=Adrienne.VanHalem@ipc.on.ca","Department": "IPC - CSD","JobTitle": "Information Management Specialist"},"ProjectLead#Claims": "i:0#.f|membership|adrienne.vanhalem@ipc.on.ca","MediaServiceImageTags": [{"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedTaxonomy","TermGuid": "ffffffff-ffff-ffff-ffff-fffffffff006","WssId": 3,"Label": "outdoor","Path": null,"Value": "outdoor|ffffffff-ffff-ffff-ffff-fffffffff006"}],"MediaServiceImageTags@odata.type": "#Collection(Microsoft.Azure.Connectors.SharePoint.SPListExpandedTaxonomy)","MediaServiceImageTags#WssId": [3],"MediaServiceImageTags#WssId@odata.type": "#Collection(Int64)","Created": "2024-02-13T16:24:10Z","Author": {"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser","Claims": "i:0#.f|membership|adrienne.vanhalem@ipc.on.ca","DisplayName": "Adrienne Van Halem","Email": "Adrienne.VanHalem@ipc.on.ca","Picture": "https://ipconca.sharepoint.com/sites/IMDevEnvironment/_layouts/15/UserPhoto.aspx?Size=L&AccountName=Adrienne.VanHalem@ipc.on.ca","Department": "IPC - CSD","JobTitle": "Information Management Specialist"},"Author#Claims": "i:0#.f|membership|adrienne.vanhalem@ipc.on.ca","Modified": "2024-02-14T19:00:43Z","Editor": {"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser","Claims": "i:0#.f|membership|adrienne.vanhalem@ipc.on.ca","DisplayName": "Adrienne Van Halem","Email": "Adrienne.VanHalem@ipc.on.ca","Picture": "https://ipconca.sharepoint.com/sites/IMDevEnvironment/_layouts/15/UserPhoto.aspx?Size=L&AccountName=Adrienne.VanHalem@ipc.on.ca","Department": "IPC - CSD","JobTitle": "Information Management Specialist"},"Editor#Claims": "i:0#.f|membership|adrienne.vanhalem@ipc.on.ca","OData__DisplayName": "","{Identifier}": "Staff%2bHeadshots%2bfor%2bApproval%252fDoug%2b1%2bsmall.jpg","{IsFolder}": false,"{Thumbnail}": {Tumbnail Data Removed to shorten""{Link}": "https://ipconca.sharepoint.com/sites/IMDevEnvironment/Staff%20Headshots%20for%20Approval/Doug%201%20small.jpg","{Name}": "Doug 1 small","{FilenameWithExtension}": "Doug 1 small.jpg","{Path}": "Staff Headshots for Approval/","{FullPath}": "Staff Headshots for Approval/Doug 1 small.jpg","{IsCheckedOut}": false,"{VersionNumber}": "18.0"},{"@odata.etag": "\"17\"","ItemInternalId": "9","ID": 9,"Status": {"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id": 1,"Value": "Ready for review"},"Status#Id": 1,"ProjectLead": {"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser","Claims": "i:0#.f|membership|adrienne.vanhalem@ipc.on.ca","DisplayName": "Adrienne Van Halem","Email": "Adrienne.VanHalem@ipc.on.ca","Picture": "https://ipconca.sharepoint.com/sites/IMDevEnvironment/_layouts/15/UserPhoto.aspx?Size=L&AccountName=Adrienne.VanHalem@ipc.on.ca","Department": "IPC - CSD","JobTitle": "Information Management Specialist"},"ProjectLead#Claims": "i:0#.f|membership|adrienne.vanhalem@ipc.on.ca","MediaServiceImageTags": [{"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedTaxonomy","TermGuid": "ffffffff-ffff-ffff-ffff-fffffffff006","WssId": 3,"Label": "outdoor","Path": null,"Value": "outdoor|ffffffff-ffff-ffff-ffff-fffffffff006"}],"MediaServiceImageTags@odata.type": "#Collection(Microsoft.Azure.Connectors.SharePoint.SPListExpandedTaxonomy)","MediaServiceImageTags#WssId": [3],"MediaServiceImageTags#WssId@odata.type": "#Collection(Int64)","Created": "2024-02-13T18:35:49Z","Author": {"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser","Claims": "i:0#.f|membership|adrienne.vanhalem@ipc.on.ca","DisplayName": "Adrienne Van Halem","Email": "Adrienne.VanHalem@ipc.on.ca","Picture": "https://ipconca.sharepoint.com/sites/IMDevEnvironment/_layouts/15/UserPhoto.aspx?Size=L&AccountName=Adrienne.VanHalem@ipc.on.ca","Department": "IPC - CSD","JobTitle": "Information Management Specialist"},"Author#Claims": "i:0#.f|membership|adrienne.vanhalem@ipc.on.ca","Modified": "2024-02-14T19:00:43Z","Editor": {"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser","Claims": "i:0#.f|membership|adrienne.vanhalem@ipc.on.ca","DisplayName": "Adrienne Van Halem","Email": "Adrienne.VanHalem@ipc.on.ca","Picture": "https://ipconca.sharepoint.com/sites/IMDevEnvironment/_layouts/15/UserPhoto.aspx?Size=L&AccountName=Adrienne.VanHalem@ipc.on.ca","Department": "IPC - CSD","JobTitle": "Information Management Specialist"},"Editor#Claims": "i:0#.f|membership|adrienne.vanhalem@ipc.on.ca","OData__DisplayName": "","{Identifier}": "Staff%2bHeadshots%2bfor%2bApproval%252fDoug%2b2%2bsmall.jpg","{IsFolder}": false,"{Thumbnail}": {Tumbnail Data Removed to shorten"},"{Link}": "https://ipconca.sharepoint.com/sites/IMDevEnvironment/Staff%20Headshots%20for%20Approval/Doug%202%20small.jpg","{Name}": "Doug 2 small","{FilenameWithExtension}": "Doug 2 small.jpg","{Path}": "Staff Headshots for Approval/","{FullPath}": "Staff Headshots for Approval/Doug 2 small.jpg","{IsCheckedOut}": false,"{VersionNumber}": "16.0"}]

 

 

9b2. Compose - User Item Count - Inputs: length(body('Filter_array_-_User_Items'))

Result after run

 

Spoiler (Highlight to read)

Input: 2

Output: 2

Input: 2Output: 2

 

9c. Apply to Each - Photo - Select an output: body('Filter_array_-_User_Items')

9c1. Get file properties - Id: items('Apply_to_each_-_Photo')?['ID']

Spoiler (Highlight to read)
adriennevh_7-1708018009729.png

 


 

  

 

9c2. Get file contents - File identifier: outputs('Get_file_properties')?['body/{Identifier}']

Spoiler (Highlight to read)
adriennevh_8-1708018050091.png

 

9c3. Compose base64 - Inputs: base64(body('Get_file_content'))

9c4. Compose ImageBase64 - Inputs: outputs('Compose_base64')

9c5. Compose Image - Inputs: <img src="data&colon;image/jpeg;base64,@{outputs('Compose_ImageBase64')}" />

9c6. Append varRows - <tr> <td>@{outputs('Get_file_properties')?['body/{Name}']}</td> <td>@{outputs('Compose_Image')} </td>

Spoiler (Highlight to read)
<tr> <td>Doug 1 small</td> <td><img src="data&colon;image/jpeg;base64,/9j/long base64 code removed/mf//Z" /> </td>
<tr> <td>Doug 1 small</td> <td><img src="data&colon;image/jpeg;base64,/9j/long base64 code removed/mf//Z" /> </td>

9c7. Update file properties

Id: items('Apply_to_each_-_Photo')['ID']

Status Value: Sent for review

9d. Select - List File Names

From: body('Filter_array_-_User_Items')

Map: concat(item()?['{Name}'])

9e. Compose - Option Names - Inputs: join(body('Select_-__List_File_Names'),',')

9f. Send email with Options

To: outputs('Compose_-_Users_Email_Address')

User Options: outputs('Compose_-_Option_Names')

Body: @{variables('varCSS')}@{variables('varTitle')}@{variables('varRows')}

Use only HTML message: Yes

9g. Apply to each - Name check

Condition  - this part after the issue and doesn't seem to be affecting it

 

 

 

 

adriennevh_1-1708014034905.png

adriennevh_2-1708014112450.png

adriennevh_4-1708014138327.png

 

Categories:
General topics
I have the same question (0)
  • Verified answer
    SamLed Profile Picture
    SamLed 2,338 Moderator on at

    Hi @adriennevh,

     

    It's a great project, you've already had a lot of work done, but allow me, without wanting to offend you, to say that I find the design of your flow too complex. Let me share with you how I would have done it.

     

    First I would split this flow into 2 flows :

    • A main flow to manage users info
    • A sub flow which take user info as input, build HTML, send email and update item for selected picture

    Using that design you get many benefits:

    • User's apply to each concurrent mode use in main flow
    • One flow instance (sub flow) per user
    • No mess with variable as you dont need concurrent mode to build Email HTML

    Use this design, you'll have to create a solution and build both flow inside that solution then you'll be able to use the following action to call your sub flow:

    SamLed_0-1709077347092.png

     

    When selected child flow trigger has input set up, this action will propose to populate it. You can have an array as input and pass all data of a user to child flow.  

     

     

    HTML Build design pattern:

    You can simplify HTML build by saving variable and loop use, here a flow to illustrate:

    SamLed_0-1709111573234.png

    SamLed_1-1709111679314.png

     

    outputs:

    SamLed_3-1709078897189.png

     

    CRLF variable is just a string with a blank line, this is just making HTML more readable in last compose outputs  for debug purpose. 

     
    Data optimization:
    • Minimize data to deal with in user apply to each using "Select" after having filtered by email.
    SamLed_7-1709076646008.png

    From: body('Filter_array_-_User_Items')

    Fullname: item()?['Name']

    Firstname: first(split(item()?['Name'],' '))

    Email: item()?['Email']

    ItemID: item()?['ID']

     

    This way you get an array of all required user data for later use, you save so many compose, filter, and loop.

     

    You could also create a view in your document library which shows only column required by your flow and configure "Get items" action with it, it will improve data fetch performance from library:

    SamLed_1-1709078416209.png

     

     

    I can see some other possible optimizations, I'll let you see if you're already interested by those I related, that's already big changes to your current flow, but rebuild your flow will be less time spent than trying to find a solution to your variable issue. Solution you won't be able to find because appending to variable inside a concurrent loop will only work if you need to get one overhall array in an unordered way but totally incompatible with your use case where variable should contains only data of one user at once.

     

    Feel free to ping me if you need support, I can help you with, I like your interesting project 😉

    ______________________________________________________________

    If I have answered your question, please Accept the post as solution.
    If you like my response, please Thumbs Up.

       

     

     

     

  • adriennevh Profile Picture
    adriennevh 27 on at

    This is amazing! Thank you so much, not offended at all. Not knowing the tools as well as I want to, means I go by indirect methods. I'll work through implementing this and re-post if I continue to have issues.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities
Season of Giving Solutions is Here!
Explore Copilot Studio Forums, Blogs & Galleries!

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 523 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 406 Moderator

#3
abm abm Profile Picture

abm abm 245 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!
Survey: Power Automate mobile app
How to Ask for Help with Your Power Automate Workflow
Flows are not visible for users who sign in with their personal accounts
Start and wait for an approval action
Restore a deleted flow
List of actions cheat sheet for Power Automate Desktop
Question for everyone : How are you using Create Text GPT in AI Builder?
Welcome to the Power Automate forum!

Product updates

Microsoft Power Platform Community release plans