Power Platform Community Forum Thread Details

Hi All,

I have two collections, Vehicles and Countries. I want to create records to a Sharepoint List

Vehicles : Car A, Car B

Countries : Country A, Country B

The result I would like is below

Record Vehicle Country

1 Car A Country A

2 Car A Country B

3 Car B Country A

4 Car B Country B

I was looking at using a Nested For All, but I am not able to get it to work

Thank in Advance

Categories:

Building Power Apps

Hello @Skybluekid,

Please try below code:

Assuming:
Vehicles has a column called Vehicle
Countries has a column called Country

ForAll(
    Vehicles As _vehicalObj, //Vehicles - Collection name
    ForAll(
        Countries As _countryObj, //Countries  - Collection name
        Patch(
            YourSharePointList,  //Replace this "YourSharePointList" your sharepoint list..
            Defaults(YourSharePointList),
            {
                Vehicle: _vehicalObj.Vehicle,
                Country: _countryObj.Country    //Update column name "Country" as per your list column name        
            }
        )
    )
)

I have already tested this using dummy collections and stored the output in a temporary collection, and the results are coming back as expected.

------------------------------------------------------------------------------------------------------------------------------------------

If this solution fixed your issue, please mark it as the verified/accepted solution.

📩 Need more help? Mention @Kalathiya anytime!
✔️ Don’t forget to Accept as Solution if this guidance worked for you.
💛 Your Like motivates me to keep helping.