web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Need the data from Flo...
Power Apps
Unanswered

Need the data from Flow to Gallery.

(1) ShareShare
ReportReport
Posted on by 18

I am using a flow which output will be saved in a Variable and that will be send to PowerApps Collection.
This collection is not collecting the way I want it to.
I am not able to use the collection data in to my Gallery in power apps.
As Gallery have 3 columns and collection is storing entire data in to one as shown Below.

 

 

 

 

Capture1.PNGCapture.PNGCapture2.PNG

Categories:
I have the same question (0)
  • poweractivate Profile Picture
    11,078 Most Valuable Professional on at

    @Rajesh456 

     

    Check if instead of using "Respond to a PowerApp or flow" Action,

    if using the Response Action works better for you:

     

    poweractivate_0-1658661024501.png

    poweractivate_1-1658661042434.png

     

    Then populate the Response Action appropriately based on your scenario.

     

    See if this helps @Rajesh456 

     

  • Rajesh456 Profile Picture
    18 on at

    HI
    But the response is a premium connector. Which my client is not ready to use. Can we have any other approach.
    I tried using below code.

    Set(varResponse,Split('Copyof-Temp456_editing_array'.Run(noi,noi).complete,";"));
    ForAll(varResponse.Result,Collect(colGridData,{
    Affected_Item:Last(FirstN(Split(Last(FirstN(Split(Result,",").Result,1).Result).Result,":").Result,2).Result).Result,
    Affected_Revision:Last(FirstN(Split(Last(FirstN(Split(Result,",").Result,2).Result).Result,":").Result,2).Result).Result,
    Effective_date:Last(FirstN(Split(Last(FirstN(Split(Result,",").Result,3).Result).Result,":").Result,2).Result).Result-1


    }
    )
    );

    Rajesh456_0-1658723746953.png

    I  need to remove the "" in the collection and date is also not coming.
    I need the collection in below format.

    Rajesh456_1-1658723915557.png

     

  • v-bofeng-msft Profile Picture
    Microsoft Employee on at

    Hi @Rajesh456 ,

     

    Please try:

     

    Set(varResponse,Split('Copyof-Temp456_editing_array'.Run(noi,noi).complete,";"));
    Clear(colGridData);
    ForAll(
     varResponse.Result,
     Collect(
     colGridData,
     {
    Affected_Item:First(Split(Last(Split(Result,""""&"Affected Item"&""""&":"&"""")).Result,"""")).Result,
    Affected_Revision:First(Split(Last(Split(Result,""""&"Affected Revision"&""""&":"&"""")).Result,"""")).Result,
    Effective_date:DateAdd(DateTimeValue(First(Split(Last(Split(Result,""""&"Effective Date"&""""&":"&"""")).Result,"""")).Result),-1,Days)
    
    }
    )
    );

     

    vbofengmsft_0-1658816853294.png

    vbofengmsft_1-1658816864527.png

     

    Best Regards,

    Bof

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 541

#2
WarrenBelz Profile Picture

WarrenBelz 434 Most Valuable Professional

#3
Valantis Profile Picture

Valantis 289

Last 30 days Overall leaderboard