Flow.run() not fill the collection

(0) Share

Report

Posted on by Citrix73

Hi Guys,

this is a big problem for me, because all the attempts that i try to populate a collection from flow fail.

I don't undertsand the problem because if i run the flow in test , all works fine, but when i call from powerapps the result is that in the step immediatly before the last i see that the flow returns the correct json with all the rows, but in the last step return 1 row retrieved. Where is the problem? In screenshot below you can see the result of monitoring and my call to flow is this.

ClearCollect('Raccolta 1';Load_Tasks.Run("Parameter"))

I Need a flow in order to populate the json because i have to do many trasformation before return data to powerapps.

Thanks a lot

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

Verified answer

Vijay Tailor 2,961 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Citrix73 ,

YOu can try like below, Code from the flow you are getting a response so hope that will be in string format or JSON formate.
but to are collecting tin the ClearCollect, that is not correct ways.

Set(IsCompleted,ExportFileFromSP.Run(varFOrmattedJson,Text("ExportCSVFile_"&First(Split(varCurrentUser.Email, "@")).Result),"NA").completed); //You can modify accordingly .

For your Case Like below -

Set(varName,Load_Tasks.Run("Parameter"));

and Now you can use the Variable for further manipulation.\Formatting purpose.

Thanks,
Vijay
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."-Vijay
Citrix73 32 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks a lot Vivian,
excuse me but i'm novice on Powerapps.
Where i have to put your formula?

Set(IsCompleted,ExportFileFromSP.Run(varFOrmattedJson,Text("ExportCSVFile_"&First(Split(varCurrentUser.Email, "@")).Result),"NA").completed); //You can modify accordingly .

On the Button that load data? or in the Flow? If in Flow , which kind of step i have to insert?
Then i presume that the formula on Button in powerapps should be that. It's correct?
Set(varName,Load_Tasks.Run("Parameter"));
Citrix73 32 on at

Like
a
(0)

Report
Copy link

Link copied!

Another question:
if i use your formula my editor return me always error on , or . I have to change , to ; and the Formula editor is ok. It's correct?
but i receve always error if i use the . in the formula in example .Result.
How can i change the . in the formula?
Vijay Tailor 2,961 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Citrix73 ,

No , it not the correct way,

i used.Result for my requirement coz I used split function for that reason i used the . Result.

but you you configure the response like below and try to validate the same in power apps then you can use like below.

See how I configured the response in flow.
and Now I am validating the flow response that i configured in the flow.
Set(IsCompleted,ExportSkillsSetData.Run(varFormattedJsonSkills,Text("ExportCSVSkillsFile_"&First(Split(User().Email, "@")).Result),"NA").completed); //completed is the response comming from flow and i am setting this value to IsCompleted Variable.
Thanks
Vijay
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."-Vijay
v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Citrix73 :

Could you tell me:

Do you want to retrun a table form Flow to PowerApps?

How is your flow configured?Could you attach some cdreenshots?

If you want to retrun a table form Flow to PowerApps,the point is using Respons action.I'v made a test for your reference:

1\My Flow-'PowerApp->Getitems'

2\Add a button and set it's OnSelelct property to:

ClearCollect(ddd,'PowerApp->Getitems'.Run())

Best Regards,

Bof