Unanswered

ERROR UN FLOW USING SHAREPOINT

(0) Share

Report

Posted on by Gean_ST

I have created a flow using AI Builder to extract information from several PDFs located in a SharePoint folder and place the information in an Excel file also located in SharePoint. However, when I add a new PDF to the folder, the flow doesn't work, and I get the following error: The execution of template action 'Aplicar_a_cada_uno' failed: the result of the evaluation of 'foreach' expression '@{triggerOutputs()?['body/Author']}@{triggerOutputs()?['body/Author/JobTitle']}@{triggerOutputs()?['body/Author/DisplayName']}@{triggerOutputs()?['body/Author/Email']}' is of type 'String'. The result must be a valid array.

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Michael E. Gernaey 53,963 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hello,

I am not sure what the Apply to Each you have is trying to do, can you explain. What I can say is that based on what you put there, the result is in fact just a string, and an Apply to Each requires it to be an array of values that it can loop through

Can you please share more of the flow and what you expect to loop through
Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
Gean_ST 56 on at

Like (0)

Report
Copy link

Link copied!

I'm trying to extract information from several PDFs located in a SharePoint folder. I'm using the AI Builder tool to perform this extraction. What I want is that every time I upload a file to the folder, AI Builder should do its work, extract the information, and place it in the Excel file.

Was this reply helpful? Yes No
Michael E. Gernaey 53,963 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi,

I understand that part, but what is the loop for. You are talking about a single file, not files. Since the loop is your issue, what are you trying to loop through at that point.

Was this reply helpful? Yes No
Gean_ST 56 on at

Like (0)

Report
Copy link

Link copied!

Okay, I fixed it already. Now, the problem is that when extracting the information, it doesn't extract the first piece of data, even though the flow indicates that it's working correctly. it should report 5 items: NOTI_NRO, DECLA_NRO, SERIE, USUARIO_NOMB and RUC_NRO. but as you can see it doesnt extract NOTI_NRO. when i test its fine.

Was this reply helpful? Yes No