Power Platform Community Forum Thread Details

Hi guys,

Lately i've been using the Collect and Patch function in some apps, but i notice that sometimes some infos are not going to my database, anyone has been expericieng that situation too?

Thats my collection (in that app, people can add more itens before patch)

I made some tests, and aparently, this part is working well

Thats the formula for patch all Collected items, but i notice that, especially "Número da Requisição" and "ChefiaEmail" (that item its using a LookUp in another Sharepoint List) its not working well, sometimes he cames with value 0, or Blank.

There some cfg to make?

Categories:

Building Power Apps

@Igarsaba

To start, your formula has the ForAll backward. You are trying to use it like a ForLoop in some development language - which PowerApps is not. ForAll is a function that returns a table of records based on your iteration table and record schema.

It is more efficient to use the function as intended and will provide better performance since your inner Patch performance will be horrible as you have it.

Your Formula should be of this style:

Patch('Horas Extras',
 ForAll(ColaboradoresHE,
 {Title: 
 ....etc...
 }
 )
)

However, you are putting a great deal of work into your process that you don't need to do!

Where are you using the first Collect formula you provided?

And finally, to your initial point - neither of your Lookup columns or email columns are correct. You cannot set them to text. The lookup needs to be a record to the looked up record - to include the ID (Id) and the Title or other lookup-defined field (Value). As for the User type column, you must be supplying a full SharePoint User record to that column.