Unanswered

PVA Return Sharepoint Files unable to Return Items

(0) Share

Report

Posted on by VeeLearnMSFT

508

A little frustrated, trying to get this flow working all day. I was trying to use @renatromano flow so I could replicate but but cannot get anything to return. I am trying to crate a PVA bot that would return a list of files based off of search input. So I would ask the bot to look for files inside of sharepiont. I would enter a text search, which could be a partial of the file OR Contains. And then the bot would reutrn a list of files and their corresponding folder if possible. Can someone kindly look at my flow to see where I am going wrong. 12 hours of work and still not results. Please help!

Nothing is returing back. I spent all day trying to get this to work. Im not ready to throw in the towel as I know I am way too new at this. I am stuck and I cannot get a search to work to return files.

Categories:

Building flows

I have the same question (0)

All responses (18)

Answers (2)

Rhiassuring 8,690 Moderator on at

Like (0)

Report

Can we please see the inside of your Append to String Variable?

Your error says there is an issue with that action.

Was this reply helpful? Yes No
VeeLearnMSFT 508 on at

Like (0)

Report

I see the data coming in to the Filter Array but it does not show any output. It just seems to stop there.

Was this reply helpful? Yes No
VeeLearnMSFT 508 on at

Like (0)

Report

I changed the flow slightly. I got rid of the filter array and filtering right using the filter query:
It came back with 10 records:
Now the flow is returning values all the way to the agent but the agent is not returning anythign in the chat window. I dont understand why, is it the type of data that is not in the format it requires?

Here is my error from the bot:

Was this reply helpful? Yes No
Rhiassuring 8,690 Moderator on at

Like (0)

Report

In your last screenshot, it looks like you are appending the variable "Link" to itself, without any content in it..?

Was this reply helpful? Yes No
VeeLearnMSFT 508 on at

Like (1)

Report

what is the proper way to do it...Do i need to put the Name instead of link? Can you show me a screenshot of what it should look like? Sorry I am just too knew and I am not quite sure how to fix it.

Was this reply helpful? Yes No
Rhiassuring 8,690 Moderator on at

Like (0)

Report

It's okay, Vee, we'll get there.

So right now, you are filling a blank variable (Link) with itself - which is blank. So ... blank!

Instead, try this:

Where I have txtTable, you'll have your Link variable - where I have "Link to Item", you'll select the Dynamic Content from your Get Files output, and you should have the same thing to select, "Link to Item". Now, we're storing that link in the variable - and since it's an APPEND to string variable, it's going to put it right alongside whatever other values we add.

Note I have a "; " after - a semi-colon, and a space - because the Append to String Variable action will literally put them sidebyside unless we tell it not to!

Also, a tip: I recommend (and this is a personal thing, of course, I am sure we will have plenty of folks here disagree) naming variables with a prefix. This helps more easily identify their purpose, so you won't see "Link" and wonder what kind of variable it is. Examples: intSharePointID, txtNameOfDoc, arrDepartments... (some people prefer str over txt, which I get - txt is a habit for me.)

Was this reply helpful? Yes No
VeeLearnMSFT 508 on at

Like (0)

Report

I am still missing something. I apologize if am a severe bother 😞
This is part of my flow revised:

Here is what it returned: I see the 10 items coming in...but see further below.

Am I getting close?

Was this reply helpful? Yes No
Rhiassuring 8,690 Moderator on at

Like (0)

Report

Errrr.. hard to tell. I don't know what "Kada" is, at all...

And, for 'txtTable' - that will still be your variable called Link, you don't need to rename it to what I've used 😛

Let me give a test on my side, and I'll report back in a sec.... I've never used a chat bot before.

Was this reply helpful? Yes No
VeeLearnMSFT 508 on at

Like (0)

Report

I know but I wanted to impress you 😞 so I am passing a text string through the bot which is the name of the file. The file contains Kadaj in side of it. It is pulling all instances matching Kadaj string. But what I dont get is why is it bunching kadaj and the link to the file right next to each other. I just thought it was weird and perhaps this is why it stopped. I mean I see the links being outputed in the body of the return to virtual agent box. I just dont know why its not returning anything.

Was this reply helpful? Yes No
Verified answer

Rhiassuring 8,690 Moderator on at

Like (0)

Report

WELP - I've just learned something from you, and also from a past @Pstork1 post.

Just built my first bot, and, figured out the issue here!

When passing links back to the PVA, you want to use the format of [TITLE](link).

Check this out: https://docs.microsoft.com/en-us/power-automate/approvals-markdown-support#links

My string looked like this:

And here's the output:

Uh oh, these bots are fun...
...oh and $1280 a month apparently. ..WELP.

Was this reply helpful? Yes No