Power Platform Community Forum Thread Details

Hey guys,

I'm struggling with the following flow.

The flow is going to be triggered everytime a new resource is created on Project Online.

I will then get the Manager of that specific resource and doing some steps, if the manager doens't fit to manually specififed ones the flow will be terminated. As well if the manager field for that resource is empty, the flow will be terminated as well.

That works very well.

Now the idea is to substitute the manually set managers via dynamic content, e.g. one or more managers are leaving I then didn't need to update the flow manually.

Therefore I had the idea to use the RSP customfield of Project Online, all needed managers are resources as well and are set on one specific entry for that RSP field.

The next step was now to do an HTTP request and get the resources filtered by the specified RSP Entries. But here it get's tricky. Everytime I get a Bad Gateway response.

When I GET all resources everything works fine, but for me it doesn't make any sense to get everytime all resources when I only need four.

RSP:

{
 "AppAlternateId": "000039b7-8bbe-4ceb-82c4-fa8c0c400284",
 "DepartmentId": "00000000-0000-0000-0000-000000000000",
 "Description": null,
 "FieldType": 21,
 "Formula": null,
 "GraphicalIndicatorNonSummary": null,
 "GraphicalIndicatorProjectSummary": null,
 "GraphicalIndicatorSummary": null,
 "Id": "000039b7-8bbe-4ceb-82c4-fa8c0c400284",
 "InternalName": "Custom_000039b78bbe4ceb82c4fa8c0c400284",
 "IsEditableInVisibility": false,
 "IsLeafOnly": false,
 "IsMultilineText": false,
 "IsRequired": false,
 "IsWorkflowControlled": false,
 "LookupAllowMultiSelect": false,
 "LookupDefaultValue": "00000000-0000-0000-0000-000000000000",
 "Name": "RSP",
 "RollsDownToAssignments": true,
 "RollupType": 11,
 "ShowToolTip": false,
 "UseFieldForMatching": false
 }

LookupEntries:

{
 "odata.type": "PS.LookupText",
 "odata.id": "https://xxxx.sharepoint.com/sites/pwa/_api/ProjectServer/LookupTables('00008e67-65a3-4898-baaa-d82d995bbb02')/Entries('05867911-b8d5-ec11-8d8c-00155df4552b')",
 "odata.editLink": "ProjectServer/LookupTables('00008e67-65a3-4898-baaa-d82d995bbb02')/Entries('05867911-b8d5-ec11-8d8c-00155df4552b')",
 "AppAlternateId": "00000000-0000-0000-0000-000000000000",
 "Description": "",
 "FullValue": "xxxx.IT",
 "Id": "05867911-b8d5-ec11-8d8c-00155df4552b",
 "InternalName": "Entry_05867911b8d5ec118d8c00155df4552b",
 "SortIndex": "2.0000000000",
 "HasChildren": true,
 "Mask": {
 "Length": 0,
 "MaskType": 3,
 "Separator": "."
 },
 "Value": "IT"
 }

ResourceInformation:

{
 "odata.type": "PS.EnterpriseResource",
 "odata.id": "https://xxxx.sharepoint.com/sites/pwa/_api/ProjectServer/EnterpriseResources('1ce50d71-978d-ec11-b00b-00155df04a5b')",
 "odata.editLink": "ProjectServer/EnterpriseResources('1ce50d71-978d-ec11-b00b-00155df04a5b')",
 "CanLevel": true,
 "Code": null,
 "CostAccrual": 3,
 "CostCenter": null,
 "Created": "2022-02-14T13:10:38.377",
 "DefaultBookingType": 2,
 "Email": "xxxx",
 "ExternalId": null,
 "Group": "IT xxxx",
 "HireDate": "0001-01-01T00:00:00",
 "HyperlinkName": "",
 "HyperlinkUrl": "",
 "Id": "1ce50d71-978d-ec11-b00b-00155df04a5b",
 "Initials": "A",
 "IsActive": true,
 "IsBudget": false,
 "IsCheckedOut": false,
 "IsGeneric": false,
 "IsTeam": false,
 "MaterialLabel": "",
 "Modified": "2024-01-12T12:53:42.14",
 "Name": "xxxx",
 "Phonetics": "",
 "RequiresEngagements": false,
 "ResourceIdentifier": 473,
 "ResourceType": 1,
 "TerminationDate": "0001-01-01T00:00:00",
 "Custom_x005f_000039b78bbe4ceb82c4fa8c0c400284": [
 "Entry_0a867911b8d5ec118d8c00155df4552b"
 ],
 "Custom_x005f_0000740fcf674b93a405f0c12c5bc942": [
 "Entry_c8f54be0529bee119a7500155d785420"
 ]
 }

As you are able to see I got two different information about the internal name of my RSP field.

RSP InternalName: Custom_000039b78bbe4ceb82c4fa8c0c400284

Resource RSP InternalName: Custom_x005f_000039b78bbe4ceb82c4fa8c0c400284

To only get the manager I tried to filter:

_api/ProjectServer/EnterpriseResources?$filter=Custom_x005f_000039b78bbe4ceb82c4fa8c0c400284 eq 'Entry_05867911b8d5ec118d8c00155df4552b'

But that's not working. Even if I change to the RSP InternalName or using the displayname of RSP or value of that LookupEntry. Everytime the same error message: Bad Gateway

Has anyone an idea where my mistake might be?

Thanks in advance for your time and effort