Power Platform Community Forum Thread Details

My Problem:

How to populate multiple rows into a table from an excel source, in my example using 'Sponsor Code' as a 'key'

What I am Doing:

From an MS list a team member provides some basic data about a client, specifically 'Sponsor Code'. That action triggers my flow. The flow gathers the 'Sponsor Code' Uses it to gather a single line of data from a database about the client, and adds that data to a table.

- This functions excellently

Next It uses that same 'Sponsor Code' to gather many lines of data a different database and add it to the same table

Then, it uses 'Program Code' from the second database to gather many lines of data from a third database and add it to the same table as the previous two.

- These two only return a single line of data.

Finally the flow posts the excel document to the row in the MS list for the team member to complete some manual processes.

Categories:

Building flows