Unanswered

getting results in a variable from power automate

(0) Share

Report

Posted on by gstlouis

I am trying to get data back from automate that looks for files in a sharepoint library.

I am using powerapps(2) and my flow is simple, and when I run to step 2 (Get Files Properties Only) it I can see the results of the files in text automate. But I am trying to put online it says to use "Respond to a PowerApp or flow". But in my power apps if I do something like
UpdateContext( { Files: PSIFileSearch.Run() } ) and when I look in context variable I get: Files (Record: {"files":{"Kind":8,"severity":3}})

How do I get the results of the files and its properties for meta data?

Screen Shot 2023-11-27 at 5.38.42 PM.png

Screen Shot 2023-11-27 at 5.42.22 PM.png

Categories:

General Questions

All responses (3)

Answers (0)

v-yueyun-msft on at

Like (0)

Report

Re: getting results in a variable from power automate

Hi , @gstlouis
Thanks for your response ! What do you mean "get a Constraint Violation"?
And for the flow return is just a Text String , we need to use the ParseJson in Power Apps to parse the json string and then convert it to the table in Power Apps.
For this , you can refer to :
ParseJSON function - Power Platform | Microsoft Learn

Best Regards,
Yueyun Zhang
gstlouis on at

Like (0)

Report

Re: getting results in a variable from power automate

@v-yueyun-msft
Thanks for sharing. This looks like a lot. I tried this and I get a Constraint Violation. I think you'd have to explain this a little more.

If I go back to the compose and run it I can see the files output. I do not understand why respond to power apps cannot provide the array
v-yueyun-msft on at

Like (0)

Report
Re: getting results in a variable from power automate

Hi , @gstlouis
According to your description, you want to get the return from the flow's action "Get files".
This is my test flow, you can refer to :

This is my app , you can use this code to get the result from the flow .
Set(data2,ForAll(Table(ParseJSON( 'getfilesproper-2'.Run().result)) ,{FilenameWithExtension: Text(ThisRecord.Value.FilenameWithExtension) ,FullPath:Text(ThisRecord.Value.FullPath),Link:Text(ThisRecord.Value.Link)}) )
The result is as follows:

Best Regards,
Yueyun Zhang