I am using the power Apps and its gives delegation warning for using GUID formula on the large data set. How could I address the problem. Appreciate any help
Explanation: The formula uses Patch function to upload the attached document to Estimating Approval APPs tables table.
It uses a collection WBSEestimates2 which is collected from Estimating Approval APPs tables. By comparing the GUIDS It uploads the attachment to each rows.
Formula.
ForAll( WBSEestimates2,
Patch(
'Estimating Approval Apps',LookUp('Estimating Approval Apps' As A,GUID(ThisRecord.'Estimating Approval App')= A[@'Estimating Approval App'])
,
{
Attachment: {
FileName: First(DataCardValue6.Attachments).Name,
Value: First(DataCardValue6.Attachments).Value
}
}
))