For Each Flow Building

(0) Share

Report

Posted on by as733y

224

I have a SharePoint list with the below info (Screenshot 1).

How do I set up my flow to get these items and create an item in a separate SP list where each date/flight is created for each crewmember (PIC, SIC, FA) Like in Screenshot 2?

Screenshot 1

Screenshot 2

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

WarrenBelz 152,845 Most Valuable Professional on at

Like (0)

Report
For Each Flow Building

Hi @as733y

Try this format in the Items of the Gallery - note the data sample utilised is subject to your Data Row Limit as there are many "local" functions in there, so I have used the newest records.
ShowColumns( RenameColumns( Ungroup( AddColumns( AddColumns( Sort( SPListName, ID, SortOrder.Descending ), Crew, PIC & "|" & SIC & "|" & FA, 'Calendar Title', 'A/C' & " " & Legs ), CrewSplit, Split( Crew, "|" ) ), CrewSplit ), Value, 'Crew String' ), Date, 'Crew String', 'Calendar Title' )

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No
WarrenBelz 152,845 Most Valuable Professional on at

Like (0)

Report

For Each Flow Building

@as733y,

A quick follow-up to see if you received the answer you were looking for or if you need further assistance.

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No