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!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 549 Most Valuable Professional

#2
Kalathiya Profile Picture

Kalathiya 225 Super User 2026 Season 1

#3
Haque Profile Picture

Haque 224

Last 30 days Overall leaderboard