Filter Query Checking For Custom PWA Field

(0) Share

Report

Posted on by patrickmee

Sorry, I am relatively new to Power Automate

I have an List Tasks action that lists all tasks for a Project (which is triggered when a project is published).

Within the body of the data output there may/or may not be a custom field shown in the image below ending "36fcc"

I want to filter the List to only have entries that have this field set (the field does not exist in the list if an entry has not been recorded).

The value for that field originates from a drop down field, but from the square brackets it looks like it is returning an array (?). So the next part of the problem is that I just want a string, not an array (I can later apply conditions on that string).

Please can anyone advise

Thanks Patrick

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

shoog 2,164 on at

Like (1)

Report

It would be easier to use the ProjectData API than the Project Online connector.

You could use the "Send an HTTP request to SharePoint" action with URL <yourPWA>/_api/ProjectData/Projects(guid'<projectID>')/Tasks?$filter=<customfieldname> ne null

Advantage of this approach is that you can use the name instead of guid of the custom field and that it will return a string value instead of the array that you see from the ProjectServer API used by the PO connector.

Was this reply helpful? Yes No
patrickmee on at

Like (0)

Report

Thanks shoog. Exactly what I needed. Not sure if GUID needs to be in caps, but for anyone who has the similar situation:

Was this reply helpful? Yes No
shoog 2,164 on at

Like (0)

Report

GUID can be in lower case too.

Do you need further help on this? If the suggested solution is working as expected then please mark it as solution accepted. This will help others in the community looking for solutions.

Was this reply helpful? Yes No
patrickmee on at

Like (0)

Report

I could do with help on the next part. I now need to go through each of the tasks in the output to perform further actions. I think that I cannot use Apply to each because the output is an object, not an array, so I assume I need to convert this output to an array? How do I do that?

Thanks

Was this reply helpful? Yes No
shoog 2,164 on at

Like (0)

Report
The output contains an array called 'value' that holds all the individual tasks and can be used as input for the apply to each action.

You can reference it by using

body('Send_an_HTTP_request_to_SharePoint')['value']

Was this reply helpful? Yes No