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

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / How to get unique obje...
Power Automate
Unanswered

How to get unique objects from an array of objects in Power Automate?

(0) ShareShare
ReportReport
Posted on by bsalunkhe 3

We are using SharePoint Online list as a data source for storing and updating tasks of approvals. Tasks are getting created against an parent item from another list. Each task is having due date.

 

In our process, we are assigning tasks to multiple users. User to whom task is assigned can reject the approval and then requestor can resubmit the request for approval. On resubmit tasks are getting assigned to only those users who rejected the approval.

 

Now, we want to get the request auto approved if tasks of that request are pending for more than X days if other completed tasks are Approved. As per process, tasks are getting assigned in a repetitive manner, we want to get latest unique tasks items to check the status.

We have been through some articles, where only plain array are used to get unique values.

We need help on getting latest unique tasks items assigned to each approver.

 

Appreciate the help! 

Categories:
General topics
  • S-Venkadesh Profile Picture
    S-Venkadesh 1,227 Super User 2026 Season 2 on at

    Hi @bsalunkhe ,

    Here is a possible approach to handle incomplete tasks:

    1. Add a "ParentID" column to the task list and populate it with the ID of the parent item for each task when creating an approval task.
    2. Optionally, add an additional column "TaskGroupID" with a value of guid() to uniquely identify the group of tasks created together.
    3. Use Power Automate to create a recurring flow and perform the following actions:
      1. Query all tasks that have been pending for N days. Optionally, save the results in an array for use in subsequent steps.
      2. Loop through the tasks and query the task list again using the "ParentID" column to check the status of related tasks.
      3. If other tasks are completed, mark the current task item as "completed".
      4. Send an email notification to the relevant parties to inform them of the updated task status.

    By following these steps, you can automate the process of tracking incomplete tasks and ensure that no requests are left unattended.

    I hope this helps! Please hit the thumbs up if it does.

     

    Best Regards,

    Venkadesh Sundaramurthy

  • bsalunkhe Profile Picture
    bsalunkhe 3 on at

    Hi @S-Venkadesh,

    Thank you for looking into my problem.

    I am receiving below XML array and we need to get distinct objects based on reviewer ID.

    <?xml version="1.0" encoding="utf-8"?>
<feed xml:base="https://myabc.sharepoint.com/sites/EHS-DMS_Dev/_api/" xmlns="http://www.w3.org/2005/Atom" xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices" xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata" xmlns:georss="http://www.georss.org/georss" xmlns:gml="http://www.opengis.net/gml">
 <id>ebff680b-7dc7-4bb9-9fce-d248b4e4e505</id>
 <title />
 <updated>2023-04-24T05:38:10Z</updated>
 <entry m:etag="&quot;1&quot;">
 <id>f8e4204d-9c0f-4ef2-8264-08e035056fe1</id>
 <category term="SP.Data.EHSReviewsListItem" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
 <link rel="edit" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(383)" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/FirstUniqueAncestorSecurableObject" type="application/atom+xml;type=entry" title="FirstUniqueAncestorSecurableObject" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(383)/FirstUniqueAncestorSecurableObject" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/RoleAssignments" type="application/atom+xml;type=feed" title="RoleAssignments" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(383)/RoleAssignments" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/AttachmentFiles" type="application/atom+xml;type=feed" title="AttachmentFiles" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(383)/AttachmentFiles" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/ContentType" type="application/atom+xml;type=entry" title="ContentType" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(383)/ContentType" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/GetDlpPolicyTip" type="application/atom+xml;type=entry" title="GetDlpPolicyTip" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(383)/GetDlpPolicyTip" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/FieldValuesAsHtml" type="application/atom+xml;type=entry" title="FieldValuesAsHtml" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(383)/FieldValuesAsHtml" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/FieldValuesAsText" type="application/atom+xml;type=entry" title="FieldValuesAsText" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(383)/FieldValuesAsText" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/FieldValuesForEdit" type="application/atom+xml;type=entry" title="FieldValuesForEdit" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(383)/FieldValuesForEdit" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/File" type="application/atom+xml;type=entry" title="File" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(383)/File" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Folder" type="application/atom+xml;type=entry" title="Folder" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(383)/Folder" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/LikedByInformation" type="application/atom+xml;type=entry" title="LikedByInformation" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(383)/LikedByInformation" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/ParentList" type="application/atom+xml;type=entry" title="ParentList" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(383)/ParentList" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Properties" type="application/atom+xml;type=entry" title="Properties" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(383)/Properties" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Versions" type="application/atom+xml;type=feed" title="Versions" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(383)/Versions" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Reviewer" type="application/atom+xml;type=entry" title="Reviewer" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(383)/Reviewer">
 <m:inline>
 <entry>
 <id>81183be7-2706-474e-9089-49f7adfa248e</id>
 <category term="SP.Data.UserInfoItem" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
 <title />
 <updated>2023-04-24T05:38:10Z</updated>
 <author>
 <name />
 </author>
 <content type="application/xml">
 <m:properties>
 <d:ID m:type="Edm.Int32">13</d:ID>
 <d:Title>test user2</d:Title>
 <d:EMail>test.user2@abc.com</d:EMail>
 </m:properties>
 </content>
 </entry>
 </m:inline>
 </link>
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/EHSRequest" type="application/atom+xml;type=entry" title="EHSRequest" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(383)/EHSRequest">
 <m:inline>
 <entry>
 <id>1627667c-883a-4bd0-a51a-790a5860d1e1</id>
 <category term="SP.Data.EHSRequestDetailsListItem" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
 <title />
 <updated>2023-04-24T05:38:10Z</updated>
 <author>
 <name />
 </author>
 <content type="application/xml">
 <m:properties>
 <d:ID m:type="Edm.Int32">199</d:ID>
 </m:properties>
 </content>
 </entry>
 </m:inline>
 </link>
 <title />
 <updated>2023-04-24T05:38:10Z</updated>
 <author>
 <name />
 </author>
 <content type="application/xml">
 <m:properties>
 <d:FileSystemObjectType m:type="Edm.Int32">0</d:FileSystemObjectType>
 <d:Id m:type="Edm.Int32">383</d:Id>
 <d:ServerRedirectedEmbedUri m:null="true" />
 <d:ServerRedirectedEmbedUrl></d:ServerRedirectedEmbedUrl>
 <d:ContentTypeId>0x01009AF605C9ED681843ABBF43FAEBFA8265000F7028B6263FF9468B5ABAD85380897B</d:ContentTypeId>
 <d:Title>SEP - DHJ - EHS TEST Request1 - R100123</d:Title>
 <d:ComplianceAssetId m:null="true" />
 <d:ReviewerId m:type="Edm.Int32">13</d:ReviewerId>
 <d:ReviewerStringId>13</d:ReviewerStringId>
 <d:DueDate m:type="Edm.DateTime">2023-04-28T18:30:00Z</d:DueDate>
 <d:ActionDate m:null="true" />
 <d:Status>Pending</d:Status>
 <d:RevisedTask m:type="Edm.Boolean">true</d:RevisedTask>
 <d:EHSRequestId m:type="Edm.Int32">199</d:EHSRequestId>
 <d:Comments m:null="true" />
 <d:SubmissionVersion m:null="true" />
 <d:ReviewAction m:null="true" />
 <d:OData__ColorTag m:null="true" />
 <d:ID m:type="Edm.Int32">383</d:ID>
 <d:Modified m:type="Edm.DateTime">2023-04-14T06:13:30Z</d:Modified>
 <d:Created m:type="Edm.DateTime">2023-04-14T06:13:30Z</d:Created>
 <d:AuthorId m:type="Edm.Int32">13</d:AuthorId>
 <d:EditorId m:type="Edm.Int32">13</d:EditorId>
 <d:OData__UIVersionString>1.0</d:OData__UIVersionString>
 <d:Attachments m:type="Edm.Boolean">false</d:Attachments>
 <d:GUID m:type="Edm.Guid">365563d3-0514-4377-9a32-1bebefb8ba5d</d:GUID>
 </m:properties>
 </content>
 </entry>
 <entry m:etag="&quot;1&quot;">
 <id>11d02080-3fca-4d48-83bb-f177ccad28a4</id>
 <category term="SP.Data.EHSReviewsListItem" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
 <link rel="edit" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(382)" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/FirstUniqueAncestorSecurableObject" type="application/atom+xml;type=entry" title="FirstUniqueAncestorSecurableObject" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(382)/FirstUniqueAncestorSecurableObject" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/RoleAssignments" type="application/atom+xml;type=feed" title="RoleAssignments" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(382)/RoleAssignments" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/AttachmentFiles" type="application/atom+xml;type=feed" title="AttachmentFiles" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(382)/AttachmentFiles" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/ContentType" type="application/atom+xml;type=entry" title="ContentType" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(382)/ContentType" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/GetDlpPolicyTip" type="application/atom+xml;type=entry" title="GetDlpPolicyTip" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(382)/GetDlpPolicyTip" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/FieldValuesAsHtml" type="application/atom+xml;type=entry" title="FieldValuesAsHtml" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(382)/FieldValuesAsHtml" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/FieldValuesAsText" type="application/atom+xml;type=entry" title="FieldValuesAsText" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(382)/FieldValuesAsText" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/FieldValuesForEdit" type="application/atom+xml;type=entry" title="FieldValuesForEdit" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(382)/FieldValuesForEdit" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/File" type="application/atom+xml;type=entry" title="File" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(382)/File" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Folder" type="application/atom+xml;type=entry" title="Folder" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(382)/Folder" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/LikedByInformation" type="application/atom+xml;type=entry" title="LikedByInformation" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(382)/LikedByInformation" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/ParentList" type="application/atom+xml;type=entry" title="ParentList" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(382)/ParentList" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Properties" type="application/atom+xml;type=entry" title="Properties" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(382)/Properties" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Versions" type="application/atom+xml;type=feed" title="Versions" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(382)/Versions" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Reviewer" type="application/atom+xml;type=entry" title="Reviewer" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(382)/Reviewer">
 <m:inline>
 <entry>
 <id>488e199d-3b0d-4bd0-b146-3cafb1217e4b</id>
 <category term="SP.Data.UserInfoItem" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
 <title />
 <updated>2023-04-24T05:38:10Z</updated>
 <author>
 <name />
 </author>
 <content type="application/xml">
 <m:properties>
 <d:ID m:type="Edm.Int32">11</d:ID>
 <d:Title>test user5</d:Title>
 <d:EMail>test.user5@abc.com</d:EMail>
 </m:properties>
 </content>
 </entry>
 </m:inline>
 </link>
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/EHSRequest" type="application/atom+xml;type=entry" title="EHSRequest" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(382)/EHSRequest">
 <m:inline>
 <entry>
 <id>203ccea9-5d6c-4c1b-b40c-b328b51b4deb</id>
 <category term="SP.Data.EHSRequestDetailsListItem" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
 <title />
 <updated>2023-04-24T05:38:10Z</updated>
 <author>
 <name />
 </author>
 <content type="application/xml">
 <m:properties>
 <d:ID m:type="Edm.Int32">199</d:ID>
 </m:properties>
 </content>
 </entry>
 </m:inline>
 </link>
 <title />
 <updated>2023-04-24T05:38:10Z</updated>
 <author>
 <name />
 </author>
 <content type="application/xml">
 <m:properties>
 <d:FileSystemObjectType m:type="Edm.Int32">0</d:FileSystemObjectType>
 <d:Id m:type="Edm.Int32">382</d:Id>
 <d:ServerRedirectedEmbedUri m:null="true" />
 <d:ServerRedirectedEmbedUrl></d:ServerRedirectedEmbedUrl>
 <d:ContentTypeId>0x01009AF605C9ED681843ABBF43FAEBFA8265000F7028B6263FF9468B5ABAD85380897B</d:ContentTypeId>
 <d:Title>SEP - DHJ - EHS TEST Request1 - R100123</d:Title>
 <d:ComplianceAssetId m:null="true" />
 <d:ReviewerId m:type="Edm.Int32">11</d:ReviewerId>
 <d:ReviewerStringId>11</d:ReviewerStringId>
 <d:DueDate m:type="Edm.DateTime">2023-04-28T18:30:00Z</d:DueDate>
 <d:ActionDate m:null="true" />
 <d:Status>Pending</d:Status>
 <d:RevisedTask m:type="Edm.Boolean">true</d:RevisedTask>
 <d:EHSRequestId m:type="Edm.Int32">199</d:EHSRequestId>
 <d:Comments m:null="true" />
 <d:SubmissionVersion m:null="true" />
 <d:ReviewAction m:null="true" />
 <d:OData__ColorTag m:null="true" />
 <d:ID m:type="Edm.Int32">382</d:ID>
 <d:Modified m:type="Edm.DateTime">2023-04-14T06:13:30Z</d:Modified>
 <d:Created m:type="Edm.DateTime">2023-04-14T06:13:30Z</d:Created>
 <d:AuthorId m:type="Edm.Int32">13</d:AuthorId>
 <d:EditorId m:type="Edm.Int32">13</d:EditorId>
 <d:OData__UIVersionString>1.0</d:OData__UIVersionString>
 <d:Attachments m:type="Edm.Boolean">false</d:Attachments>
 <d:GUID m:type="Edm.Guid">740df143-9418-4b6c-9653-f2e126d0dde0</d:GUID>
 </m:properties>
 </content>
 </entry>
 <entry m:etag="&quot;2&quot;">
 <id>bd68b559-533c-4a41-b15f-46228e7bc45b</id>
 <category term="SP.Data.EHSReviewsListItem" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
 <link rel="edit" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(370)" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/FirstUniqueAncestorSecurableObject" type="application/atom+xml;type=entry" title="FirstUniqueAncestorSecurableObject" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(370)/FirstUniqueAncestorSecurableObject" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/RoleAssignments" type="application/atom+xml;type=feed" title="RoleAssignments" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(370)/RoleAssignments" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/AttachmentFiles" type="application/atom+xml;type=feed" title="AttachmentFiles" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(370)/AttachmentFiles" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/ContentType" type="application/atom+xml;type=entry" title="ContentType" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(370)/ContentType" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/GetDlpPolicyTip" type="application/atom+xml;type=entry" title="GetDlpPolicyTip" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(370)/GetDlpPolicyTip" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/FieldValuesAsHtml" type="application/atom+xml;type=entry" title="FieldValuesAsHtml" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(370)/FieldValuesAsHtml" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/FieldValuesAsText" type="application/atom+xml;type=entry" title="FieldValuesAsText" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(370)/FieldValuesAsText" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/FieldValuesForEdit" type="application/atom+xml;type=entry" title="FieldValuesForEdit" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(370)/FieldValuesForEdit" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/File" type="application/atom+xml;type=entry" title="File" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(370)/File" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Folder" type="application/atom+xml;type=entry" title="Folder" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(370)/Folder" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/LikedByInformation" type="application/atom+xml;type=entry" title="LikedByInformation" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(370)/LikedByInformation" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/ParentList" type="application/atom+xml;type=entry" title="ParentList" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(370)/ParentList" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Properties" type="application/atom+xml;type=entry" title="Properties" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(370)/Properties" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Versions" type="application/atom+xml;type=feed" title="Versions" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(370)/Versions" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Reviewer" type="application/atom+xml;type=entry" title="Reviewer" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(370)/Reviewer">
 <m:inline>
 <entry>
 <id>696734c2-27ea-4a64-bad2-386f809006f1</id>
 <category term="SP.Data.UserInfoItem" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
 <title />
 <updated>2023-04-24T05:38:10Z</updated>
 <author>
 <name />
 </author>
 <content type="application/xml">
 <m:properties>
 <d:ID m:type="Edm.Int32">11</d:ID>
 <d:Title>test user5</d:Title>
 <d:EMail>test.user5@abc.com</d:EMail>
 </m:properties>
 </content>
 </entry>
 </m:inline>
 </link>
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/EHSRequest" type="application/atom+xml;type=entry" title="EHSRequest" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(370)/EHSRequest">
 <m:inline>
 <entry>
 <id>5bf00d0a-b926-4eac-bb46-58e4aa715d60</id>
 <category term="SP.Data.EHSRequestDetailsListItem" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
 <title />
 <updated>2023-04-24T05:38:10Z</updated>
 <author>
 <name />
 </author>
 <content type="application/xml">
 <m:properties>
 <d:ID m:type="Edm.Int32">199</d:ID>
 </m:properties>
 </content>
 </entry>
 </m:inline>
 </link>
 <title />
 <updated>2023-04-24T05:38:10Z</updated>
 <author>
 <name />
 </author>
 <content type="application/xml">
 <m:properties>
 <d:FileSystemObjectType m:type="Edm.Int32">0</d:FileSystemObjectType>
 <d:Id m:type="Edm.Int32">370</d:Id>
 <d:ServerRedirectedEmbedUri m:null="true" />
 <d:ServerRedirectedEmbedUrl></d:ServerRedirectedEmbedUrl>
 <d:ContentTypeId>0x01009AF605C9ED681843ABBF43FAEBFA8265000F7028B6263FF9468B5ABAD85380897B</d:ContentTypeId>
 <d:Title>SEP - DHJ - EHS TEST Request1 - R100123</d:Title>
 <d:ComplianceAssetId m:null="true" />
 <d:ReviewerId m:type="Edm.Int32">11</d:ReviewerId>
 <d:ReviewerStringId>11</d:ReviewerStringId>
 <d:DueDate m:type="Edm.DateTime">2023-04-28T18:30:00Z</d:DueDate>
 <d:ActionDate m:type="Edm.DateTime">2023-04-13T18:30:00Z</d:ActionDate>
 <d:Status>Completed</d:Status>
 <d:RevisedTask m:type="Edm.Boolean">false</d:RevisedTask>
 <d:EHSRequestId m:type="Edm.Int32">199</d:EHSRequestId>
 <d:Comments>[{"ID":1,"Reviewer":{"ID":11,"Title":"test user5","EMail":"test.user5@abc.com"},"Comment":"send back by test user 5 - successfully","Section":{"ID":1,"SectionHeading":"Purpose","SectionOrder":1},"CommentedDate":"2023-04-14T06:11:21.931Z","flagCompleted":false}]</d:Comments>
 <d:SubmissionVersion m:null="true" />
 <d:ReviewAction>Send Back</d:ReviewAction>
 <d:OData__ColorTag m:null="true" />
 <d:ID m:type="Edm.Int32">370</d:ID>
 <d:Modified m:type="Edm.DateTime">2023-04-14T06:12:09Z</d:Modified>
 <d:Created m:type="Edm.DateTime">2023-04-14T04:46:29Z</d:Created>
 <d:AuthorId m:type="Edm.Int32">13</d:AuthorId>
 <d:EditorId m:type="Edm.Int32">11</d:EditorId>
 <d:OData__UIVersionString>2.0</d:OData__UIVersionString>
 <d:Attachments m:type="Edm.Boolean">false</d:Attachments>
 <d:GUID m:type="Edm.Guid">246fd424-e89b-401d-96e8-d87da7c8996a</d:GUID>
 </m:properties>
 </content>
 </entry>
 <entry m:etag="&quot;2&quot;">
 <id>46a4438b-aa92-4b1e-9186-899003dbec7f</id>
 <category term="SP.Data.EHSReviewsListItem" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
 <link rel="edit" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(369)" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/FirstUniqueAncestorSecurableObject" type="application/atom+xml;type=entry" title="FirstUniqueAncestorSecurableObject" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(369)/FirstUniqueAncestorSecurableObject" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/RoleAssignments" type="application/atom+xml;type=feed" title="RoleAssignments" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(369)/RoleAssignments" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/AttachmentFiles" type="application/atom+xml;type=feed" title="AttachmentFiles" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(369)/AttachmentFiles" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/ContentType" type="application/atom+xml;type=entry" title="ContentType" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(369)/ContentType" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/GetDlpPolicyTip" type="application/atom+xml;type=entry" title="GetDlpPolicyTip" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(369)/GetDlpPolicyTip" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/FieldValuesAsHtml" type="application/atom+xml;type=entry" title="FieldValuesAsHtml" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(369)/FieldValuesAsHtml" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/FieldValuesAsText" type="application/atom+xml;type=entry" title="FieldValuesAsText" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(369)/FieldValuesAsText" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/FieldValuesForEdit" type="application/atom+xml;type=entry" title="FieldValuesForEdit" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(369)/FieldValuesForEdit" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/File" type="application/atom+xml;type=entry" title="File" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(369)/File" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Folder" type="application/atom+xml;type=entry" title="Folder" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(369)/Folder" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/LikedByInformation" type="application/atom+xml;type=entry" title="LikedByInformation" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(369)/LikedByInformation" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/ParentList" type="application/atom+xml;type=entry" title="ParentList" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(369)/ParentList" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Properties" type="application/atom+xml;type=entry" title="Properties" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(369)/Properties" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Versions" type="application/atom+xml;type=feed" title="Versions" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(369)/Versions" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Reviewer" type="application/atom+xml;type=entry" title="Reviewer" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(369)/Reviewer">
 <m:inline>
 <entry>
 <id>9896fd32-bc14-4a28-ad0e-aa02d65790cf</id>
 <category term="SP.Data.UserInfoItem" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
 <title />
 <updated>2023-04-24T05:38:10Z</updated>
 <author>
 <name />
 </author>
 <content type="application/xml">
 <m:properties>
 <d:ID m:type="Edm.Int32">13</d:ID>
 <d:Title>test user2</d:Title>
 <d:EMail>test.user2@abc.com</d:EMail>
 </m:properties>
 </content>
 </entry>
 </m:inline>
 </link>
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/EHSRequest" type="application/atom+xml;type=entry" title="EHSRequest" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(369)/EHSRequest">
 <m:inline>
 <entry>
 <id>248bd8c2-5b78-4314-8053-bc63e3b0fb4e</id>
 <category term="SP.Data.EHSRequestDetailsListItem" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
 <title />
 <updated>2023-04-24T05:38:10Z</updated>
 <author>
 <name />
 </author>
 <content type="application/xml">
 <m:properties>
 <d:ID m:type="Edm.Int32">199</d:ID>
 </m:properties>
 </content>
 </entry>
 </m:inline>
 </link>
 <title />
 <updated>2023-04-24T05:38:10Z</updated>
 <author>
 <name />
 </author>
 <content type="application/xml">
 <m:properties>
 <d:FileSystemObjectType m:type="Edm.Int32">0</d:FileSystemObjectType>
 <d:Id m:type="Edm.Int32">369</d:Id>
 <d:ServerRedirectedEmbedUri m:null="true" />
 <d:ServerRedirectedEmbedUrl></d:ServerRedirectedEmbedUrl>
 <d:ContentTypeId>0x01009AF605C9ED681843ABBF43FAEBFA8265000F7028B6263FF9468B5ABAD85380897B</d:ContentTypeId>
 <d:Title>SEP - DHJ - EHS TEST Request1 - R100123</d:Title>
 <d:ComplianceAssetId m:null="true" />
 <d:ReviewerId m:type="Edm.Int32">13</d:ReviewerId>
 <d:ReviewerStringId>13</d:ReviewerStringId>
 <d:DueDate m:type="Edm.DateTime">2023-04-28T18:30:00Z</d:DueDate>
 <d:ActionDate m:type="Edm.DateTime">2023-04-13T18:30:00Z</d:ActionDate>
 <d:Status>Completed</d:Status>
 <d:RevisedTask m:type="Edm.Boolean">false</d:RevisedTask>
 <d:EHSRequestId m:type="Edm.Int32">199</d:EHSRequestId>
 <d:Comments>[{"ID":1,"Reviewer":{"ID":13,"Title":"test user2","EMail":"test.user2@abc.com"},"Comment":"send back by test user 2 - need more informations","Section":{"ID":1,"SectionHeading":"Purpose","SectionOrder":1},"CommentedDate":"2023-04-14T06:12:33.699Z","flagCompleted":false}]</d:Comments>
 <d:SubmissionVersion m:null="true" />
 <d:ReviewAction>Send Back</d:ReviewAction>
 <d:OData__ColorTag m:null="true" />
 <d:ID m:type="Edm.Int32">369</d:ID>
 <d:Modified m:type="Edm.DateTime">2023-04-14T06:12:54Z</d:Modified>
 <d:Created m:type="Edm.DateTime">2023-04-14T04:46:28Z</d:Created>
 <d:AuthorId m:type="Edm.Int32">13</d:AuthorId>
 <d:EditorId m:type="Edm.Int32">13</d:EditorId>
 <d:OData__UIVersionString>2.0</d:OData__UIVersionString>
 <d:Attachments m:type="Edm.Boolean">false</d:Attachments>
 <d:GUID m:type="Edm.Guid">0b396591-d8fe-40b8-adee-42ff1c1a9714</d:GUID>
 </m:properties>
 </content>
 </entry>
 <entry m:etag="&quot;2&quot;">
 <id>cc5b5e44-23c5-4385-a2cc-efcec3880ee7</id>
 <category term="SP.Data.EHSReviewsListItem" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
 <link rel="edit" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(368)" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/FirstUniqueAncestorSecurableObject" type="application/atom+xml;type=entry" title="FirstUniqueAncestorSecurableObject" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(368)/FirstUniqueAncestorSecurableObject" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/RoleAssignments" type="application/atom+xml;type=feed" title="RoleAssignments" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(368)/RoleAssignments" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/AttachmentFiles" type="application/atom+xml;type=feed" title="AttachmentFiles" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(368)/AttachmentFiles" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/ContentType" type="application/atom+xml;type=entry" title="ContentType" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(368)/ContentType" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/GetDlpPolicyTip" type="application/atom+xml;type=entry" title="GetDlpPolicyTip" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(368)/GetDlpPolicyTip" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/FieldValuesAsHtml" type="application/atom+xml;type=entry" title="FieldValuesAsHtml" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(368)/FieldValuesAsHtml" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/FieldValuesAsText" type="application/atom+xml;type=entry" title="FieldValuesAsText" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(368)/FieldValuesAsText" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/FieldValuesForEdit" type="application/atom+xml;type=entry" title="FieldValuesForEdit" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(368)/FieldValuesForEdit" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/File" type="application/atom+xml;type=entry" title="File" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(368)/File" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Folder" type="application/atom+xml;type=entry" title="Folder" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(368)/Folder" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/LikedByInformation" type="application/atom+xml;type=entry" title="LikedByInformation" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(368)/LikedByInformation" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/ParentList" type="application/atom+xml;type=entry" title="ParentList" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(368)/ParentList" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Properties" type="application/atom+xml;type=entry" title="Properties" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(368)/Properties" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Versions" type="application/atom+xml;type=feed" title="Versions" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(368)/Versions" />
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Reviewer" type="application/atom+xml;type=entry" title="Reviewer" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(368)/Reviewer">
 <m:inline>
 <entry>
 <id>baff514d-d962-42dc-b11b-b4712c559a84</id>
 <category term="SP.Data.UserInfoItem" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
 <title />
 <updated>2023-04-24T05:38:10Z</updated>
 <author>
 <name />
 </author>
 <content type="application/xml">
 <m:properties>
 <d:ID m:type="Edm.Int32">12</d:ID>
 <d:Title>test user4</d:Title>
 <d:EMail>test.user4@abc.com</d:EMail>
 </m:properties>
 </content>
 </entry>
 </m:inline>
 </link>
 <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/EHSRequest" type="application/atom+xml;type=entry" title="EHSRequest" href="Web/Lists(guid'5cc0b232-5f07-4871-a6f1-9362a1cb7ea9')/Items(368)/EHSRequest">
 <m:inline>
 <entry>
 <id>78790153-e461-4853-8657-25284cc2125c</id>
 <category term="SP.Data.EHSRequestDetailsListItem" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
 <title />
 <updated>2023-04-24T05:38:10Z</updated>
 <author>
 <name />
 </author>
 <content type="application/xml">
 <m:properties>
 <d:ID m:type="Edm.Int32">199</d:ID>
 </m:properties>
 </content>
 </entry>
 </m:inline>
 </link>
 <title />
 <updated>2023-04-24T05:38:10Z</updated>
 <author>
 <name />
 </author>
 <content type="application/xml">
 <m:properties>
 <d:FileSystemObjectType m:type="Edm.Int32">0</d:FileSystemObjectType>
 <d:Id m:type="Edm.Int32">368</d:Id>
 <d:ServerRedirectedEmbedUri m:null="true" />
 <d:ServerRedirectedEmbedUrl></d:ServerRedirectedEmbedUrl>
 <d:ContentTypeId>0x01009AF605C9ED681843ABBF43FAEBFA8265000F7028B6263FF9468B5ABAD85380897B</d:ContentTypeId>
 <d:Title>SEP - DHJ - EHS TEST Request1 - R100123</d:Title>
 <d:ComplianceAssetId m:null="true" />
 <d:ReviewerId m:type="Edm.Int32">12</d:ReviewerId>
 <d:ReviewerStringId>12</d:ReviewerStringId>
 <d:DueDate m:type="Edm.DateTime">2023-04-28T18:30:00Z</d:DueDate>
 <d:ActionDate m:type="Edm.DateTime">2023-04-13T18:30:00Z</d:ActionDate>
 <d:Status>Completed</d:Status>
 <d:RevisedTask m:type="Edm.Boolean">false</d:RevisedTask>
 <d:EHSRequestId m:type="Edm.Int32">199</d:EHSRequestId>
 <d:Comments>[{"ID":1,"Reviewer":{"ID":12,"Title":"test user4","EMail":"test.user4@abc.com"},"Comment":"reviewed by testuser2 - successfully","Section":{"ID":1,"SectionHeading":"Purpose","SectionOrder":1},"CommentedDate":"2023-04-14T06:10:46.684Z","flagCompleted":false}]</d:Comments>
 <d:SubmissionVersion m:null="true" />
 <d:ReviewAction>Reviewed</d:ReviewAction>
 <d:OData__ColorTag m:null="true" />
 <d:ID m:type="Edm.Int32">368</d:ID>
 <d:Modified m:type="Edm.DateTime">2023-04-14T06:11:01Z</d:Modified>
 <d:Created m:type="Edm.DateTime">2023-04-14T04:46:27Z</d:Created>
 <d:AuthorId m:type="Edm.Int32">13</d:AuthorId>
 <d:EditorId m:type="Edm.Int32">12</d:EditorId>
 <d:OData__UIVersionString>2.0</d:OData__UIVersionString>
 <d:Attachments m:type="Edm.Boolean">false</d:Attachments>
 <d:GUID m:type="Edm.Guid">8d1c95aa-9958-4384-86a0-1526c0fd5d97</d:GUID>
 </m:properties>
 </content>
 </entry>
</feed>

     

    Appriciate your help on this.

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

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 426

#2
11manish Profile Picture

11manish 349 Super User 2026 Season 2

#3
M Bilal Khan Profile Picture

M Bilal Khan 308

Last 30 days Overall leaderboard

Featured topics

Known issue with browser automation in Power Automate for Desktop on Google Chrome 146 and 147
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
Start and wait for an approval action
Restore a deleted flow
List of actions cheat sheet for Power Automate Desktop
Welcome to the Power Automate forum!

Product updates

Microsoft Power Platform Community release plans