Unanswered

power automate flow configuration in copilot AI agent

(1) Share

Report

Posted on by JM-16050834-0

I have a flow i want to implement in topics with a filter array action and up until this action the rest are okay. The filter array action is getting input but not giving output at all thus my problem starts from there.
The filter query i've given is as follows:
@or(
equals(item()?['JournalNo'], triggerOutputs()?['body/UserInput']),
equals(item()?['Id'], triggerOutputs()?['body/UserInput']),
equals(item()?['TAId'], triggerOutputs()?['body/UserInput']),
equals(item()?['SystemCode'], triggerOutputs()?['body/UserInput'])
)
Unfortunately chatgpt is taking me in circles but the goal of this flow is:

The agent:
Accept user input: either JournalNo, TAId, Id, or SystemCode.

Use an Excel file (in SharePoint) to map between these fields.

Find the folder named using either Id/TAId/SystemCode related to the user's input in a fixed SharePoint path

Return all documents inside the matching folder.

Provide a summary for each document along with a direct clickable link.

someone please kindly help.

Categories:

Topic creation & management

Screenshot 2025-0...

I have the same question (0)

All responses (9)

Answers (0)

stampcoin 5,058 Super User 2025 Season 2 on at

Like (0)

Report

@JM-16050834-0 Hi,

I would like to know your output from 'ResolvedFolderName' or the input of the 'Get folder Files' .

We can debug from here.

Was this reply helpful? Yes No
Romain The Low-Code... 2,111 Super User 2025 Season 2 on at

Like (0)

Report

i will recommand you a sharepoint to list to make you mapping, much easy way to manipulate it.

Was this reply helpful? Yes No
JM-16050834-0 19 on at

Like (0)

Report

@stampcoin
unfortunately anything below the filter array doesnt have output. The input for ResolvedFolderName is:
if(empty(first(body('Filter_Match_Row'))?['Id']),
if(empty(first(body('Filter_Match_Row'))?['TAId']),
first(body('Filter_Match_Row'))?['SystemCode'],
first(body('Filter_Match_Row'))?['TAId']
),
first(body('Filter_Match_Row'))?['Id']
)

the input for Get Folder Files is ;

Was this reply helpful? Yes No
JM-16050834-0 19 on at

Like (0)

Report

@Romain The Low-Code Bearded Bear
Sorry i didnt understand your response. Can you give more details on it i try it?

Was this reply helpful? Yes No
stampcoin 5,058 Super User 2025 Season 2 on at

Like (0)

Report

@JM-16050834-0 Hi,

What I mean is when you test it , it has input and output data.

please share those two. especially the output it tells clue.

you can click 'Show raw outputs'

Was this reply helpful? Yes No
Veddd007 41 on at

Like (0)

Report

Please check if there is a type mismatch. The columns you've mentioned seem to be of type 'number'. Is the input to the flow also same? If both are of type string then consider using trim and lower function on both sides to ensure consistency while checking. Hope it helps !

Was this reply helpful? Yes No
JM-16050834-0 19 on at

Like (0)

Report

@stampcoin
Hello, i'll attach some screenshots and some copies (due to restrictions) of the inputs and outputs to help.

GET FOLDER FILES ...

GET FOLDER FILES ...

Was this reply helpful? Yes No
stampcoin 5,058 Super User 2025 Season 2 on at

Like (0)

Report

@JM-16050834-0 Hi,

Sorry, I didn't receive the notification ( it happens now and then).

I notice that your Filter match Row, doesn't match anything.

What is the filter query ?

Was this reply helpful? Yes No
JM-16050834-0 19 on at

Like (0)

Report

@stampcoin the filter query for Filter Match Row is:

or(

equals(item()?['JournalNo'], triggerOutputs()?['body/UserInput']),

equals(item()?['Id'], triggerOutputs()?['body/UserInput']),

equals(item()?['TAId'], triggerOutputs()?['body/UserInput']),

equals(item()?['SystemCode'], triggerOutputs()?['body/UserInput'])

)

Was this reply helpful? Yes No