the formula Collect(colItemsCollection, Items) does not work. ?

Question

There is no field in the sheet called "Items". Is this why the formula doesn't recognize 'items'?

Answer 1

Hi David,

Happy to offer my assistance. it sounds like the issue might be related to the absence of a field named "Items" in your data source.

Here are a few things you can check:

Verify Field Names: Double-check the data source you are working with to ensure that there is a field named "Items." If the field name is different, update your formula to match the correct field name.

Check Data Source Structure: Ensure that your data source (such as a SharePoint list, Excel file, or database) contains the data you expect and is connected correctly to your app.

Update Formula: If the field name is different, adjust your Collect function to use the actual field name from your data source. For example, if the field name is "ItemName" instead of "Items," you would use Collect(colItemsCollection, ItemName).

Review Documentation: Consider consulting the Power Apps documentation or training resources for additional guidance on working with collections and data sources.

If you can provide more details about your data source or the specific error message you’re encountering, I can offer more tailored assistance.

Best,
Kings