Set or update context inside ForAll function of PowerApps

(0) Share

Report

Posted on by Ananda

147

I've a requirement, where I need to use updatecontext inside a ForAll function, I understand it's not supported.

Do you have any alternatives/ suggestion on this use case.

Please find the code below, any suggestion is really appreciated.

// I'm adding data into SharePoint List from a collection

ForAll (JobSheeWCollection,

Patch ('Job Sheet', Defaults('Job Sheet'),{

Title: Customer,

Mobile: Mobile,

Email: Email,

Address: Address,

MachineModel: Model,

JobType: InsType,

CustomerRemark: CustRemark,

EngRemark: EngRemark,

SLNo: SLNo,

TempID: ID,

JobID: "JOB No : 0" & Last('Job Sheet').ID + 1 } );

//Can't assign any variable here, from another collection

//UpdateContext( { sFileContent: Filter(SignatureList,FileContent in ID).FileContent } 😞 Not supported

Filter(SignatureList,FileContent in ID).FileContent; //Executes with no error

//Run a flow which accept 2 parameters (file name, file content), to upload file into sharepoint folder, and

//getting error in below line.

CreateSignature.Run( "JoobID:"& Last('Job Sheet').ID & ".png", JSON(Filter(SignatureList,FileContent in ID).FileContent)));

//Error

);

Thank you for your support.

Thank You
Ananda

ReplyForward

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

v-siky-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @ananda ,

Although it is not supported to define a variable in ForAll loop, you can collect data to collection, so use Collection to store and reference data.

However, what is the error in your case? I have some confusion with your code:

1. What does the Filter code mean? What is SignatureList? Why does this mean that 'FileContent in ID'?

2. You miss the JSONFormat in JSON function, it should be: JSON("Your Data",JSONFormat.IncludeBinaryData)

Please share more information.

Sik

Was this reply helpful? Yes No
Ananda 147 on at

Like (0)

Report
Copy link

Link copied!

Managed to execute the code without error, data saved, but images are not visible. now it's formatting issue.

ForAll (JobSheeWCollection,
Patch ('Job Sheet', Defaults('Job Sheet'),{
Title: Customer,
Mobile: Mobile,
Email: Email,
Address: Address,
MachineModel: Model,
JobType: InsType,
CustomerRemark: CustRemark,
EngRemark: EngRemark,
SLNo: SLNo,
TempID: ID,
JobID: "JOB No : 0" & Last('Job Sheet').ID + 1 } );
CreateSignature.Run("JOB No : 0"&Last('Job Sheet').ID &".png", "JOB No : 0"& Last('Job Sheet').ID &".png",
Mid(JSON(Filter(SignatureList,JobId in ID).FileContent,JSONFormat.IncludeBinaryData),Find(",",JSON(Filter (SignatureList,JobId in ID).FileContent,JSONFormat.IncludeBinaryData))+1, Len(JSON(Filter(SignatureList,JobId in ID).FileContent,JSONFormat.IncludeBinaryData)) - Find(",",JSON(Filter(SignatureList,JobId in ID).FileContent,JSONFormat.IncludeBinaryData))-3) ));

Was this reply helpful? Yes No
v-siky-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @ananda,

Please share the flow steps, and why you need to define the JSON like that?

Sik

Was this reply helpful? Yes No