Need to patch collection to sharepoint

[ahamedafridi18]

Hi All, i am just stuck with this form as i am new to this platform. 

here i have created the form and to the submit button, i coded in such a way to filter submitted Assets gets into collection. i have connected my sharepoint list now. how do i send the data from my collection to sharepoint list by filtering only the submitted one.

My collection name is 'AssetUtilisation', sharepoint name is 'Utilisation East'

[Hassan_SZ_365]

Hi @ahamedafridi18 ,

1. Identify the Condition for Submitted Items: Determine what makes an item in 'AssetUtilisation' considered as 'submitted'. This could be a specific column or status.

2. Use the Patch Function: Iterate over the 'AssetUtilisation' collection and use the Patch function to add items to the SharePoint list.

Example Code:

ForAll(
    Filter(AssetUtilisation, YourConditionHere),
    Patch(
        'Utilisation East',
        Defaults('Utilisation East'),
        {
            Title: TitleColumn, // Replace with actual column names and values
            // Other columns...
        }
    )
)

Replace YourConditionHere with the condition that identifies a submitted item and map the column names and values from your collection to the corresponding fields in your SharePoint list.

Note: Make sure the column names used in the Patch function match those in your SharePoint list.

Best Regards,

Hassan Raza

[ahamedafridi18]

Thanks for the quick reply Hassan, the condition i used was Set(testJSON,JSON(RemoveIf(AssetUtilisation, Submit <> "Submitted")));

so i had a submit: Sumitted in my form, so once they check and select confirm it assumes as submitted but they need to select the submit button to add the form into collection.

so yeah, after adding the condition i still see error

[Hassan_SZ_365]

Hi @ahamedafridi18 ,

Follow these steps:

1. Check the Condition: Ensure that the condition used in the Filter function correctly identifies items marked as "Submitted". The Set(testJSON, JSON(RemoveIf(AssetUtilisation, Submit <> "Submitted"))); command removes non-submitted items from the collection. Make sure that the 'Submit' field exists and is correctly populated in the 'AssetUtilisation' collection.

2. Verify Data Types: Ensure that the data types in your collection match those in the SharePoint list. Mismatches in data types (e.g., text vs. number) can cause errors.

3. Examine Patch Function: Ensure that the Patch function is correctly structured and that the field names used in the Patch function match exactly with those in the SharePoint list. Pay special attention to any complex fields like Choice, Lookup, or Person.

4. Check for Errors in PowerApps: Sometimes the error message provided by PowerApps can give clues about what's wrong. If you can provide a text description of the error message, it might help in diagnosing the issue.

5. Test with a Simplified Patch: Try using the Patch function with a simplified dataset or fewer fields to see if the basic functionality works. This can help isolate the problem.

If you provide more specific information about the error message or the structure of your PowerApps collection and SharePoint list, I may be able to offer more targeted advice.

Best Regards,

Hassan Raza

[ahamedafridi18]

So yeah, i have applied the code here on the submit button. The error its showing is 'This function cannot operate on same data source that is used in filter.

previously i had - Set(testJSON,JSON(RemoveIf(AssetUtilisation, Submit <> "Submitted")));

this just remove the assets which is not been selected.

So basically, i need to only the summitted assets to to be sent to SharePoint once they click 'submit fleet' button.

[Hassan_SZ_365]

Hi @ahamedafridi18 ,

1. Separate Collection for Patching

Create a separate collection specifically for the items you want to patch to SharePoint. This can be done right before the patch operation. For example:

ClearCollect(ToPatchCollection, Filter(AssetUtilisation, Submit = "Submitted"));
ForAll(ToPatchCollection, Patch('Utilisation East', Defaults('Utilisation East'), {Title: TitleColumn /* other columns */ }));

2. Direct Patch Without Intermediate Collection

If the AssetUtilisation collection is not large, you might patch directly from it without using Filter in the same function:

ForAll(AssetUtilisation, If(Submit = "Submitted", Patch('Utilisation East', Defaults('Utilisation East'), {Title: TitleColumn /* other columns */ })));

3. Use a Variable to Store Filtered Results

If the first method causes performance issues, consider storing the filtered results in a variable first and then using that variable in the Patch function:

Set(VarToPatch, Filter(AssetUtilisation, Submit = "Submitted"));
ForAll(VarToPatch, Patch('Utilisation East', Defaults('Utilisation East'), {Title: TitleColumn /* other columns */ }));

Notes:

• Replace TitleColumn and /* other columns */ with the actual field names and values you need to patch.
• Ensure that the data types and column names in the Patch function match those in your SharePoint list.

The key here is to ensure that the Filter and Patch operations are not directly nested or applied on the same data source in the same formula. By separating these operations, you should be able to avoid the error and achieve the desired functionality.