Hey, will a run function work if I place a lookup expression into its parameters. It would look something like this.
PowerAutomateFlow1.Run(Lookup()).
I am trying to bring forth a specific record from a table by using this specific function. This function will make a button active.
SubmitShuttleChecklistAddendum.Run(
JSON(
{
ID1:If(LookUp(AddendumChoice,FalseID=1,PassFail)=true,"Pass","Fail"),
ID2:If(LookUp(AddendumChoice,FalseID=1,PassFail)=true,"Pass","Fail"),
ID3:If(LookUp(AddendumChoice,FalseID=1,PassFail)=true,"Pass","Fail"),
ID4:If(LookUp(AddendumChoice,FalseID=1,PassFail)=true,"Pass","Fail"),
ID5:If(LookUp(AddendumChoice,FalseID=1,PassFail)=true,"Pass","Fail"),
ID6:If(LookUp(AddendumChoice,FalseID=1,PassFail)=true,"Pass","Fail"),
ID7:If(LookUp(AddendumChoice,FalseID=1,PassFail)=true,"Pass","Fail"),
ID8:If(LookUp(AddendumChoice,FalseID=1,PassFail)=true,"Pass","Fail"),
ID9:If(LookUp(AddendumChoice,FalseID=1,PassFail)=true,"Pass","Fail"),
ID10:If(LookUp(AddendumChoice,FalseID=1,PassFail)=true,"Pass","Fail"),
ID11:If(LookUp(AddendumChoice,FalseID=1,PassFail)=true,"Pass","Fail"),
ID12:If(LookUp(AddendumChoice,FalseID=1,PassFail)=true,"Pass","Fail"),
ID13:If(LookUp(AddendumChoice,FalseID=1,PassFail)=true,"Pass","Fail"),
ID14:If(LookUp(AddendumChoice,FalseID=1,PassFail)=true,"Pass","Fail"),
ID15:If(LookUp(AddendumChoice,FalseID=1,PassFail)=true,"Pass","Fail"),
ID16:If(LookUp(AddendumChoice,FalseID=1,PassFail)=true,"Pass","Fail"),
ID17:If(LookUp(AddendumChoice,FalseID=1,PassFail)=true,"Pass","Fail"),
ID18:If(LookUp(AddendumChoice,FalseID=1,PassFail)=true,"Pass","Fail"),
ID19:If(LookUp(AddendumChoice,FalseID=1,PassFail)=true,"Pass","Fail"),
ID20:If(LookUp(AddendumChoice,FalseID=1,PassFail)=true,"Pass","Fail"),
ID21:If(LookUp(AddendumChoice,FalseID=1,PassFail)=true,"Pass","Fail"),
ID22:If(LookUp(AddendumChoice,FalseID=1,PassFail)=true,"Pass","Fail"),
ID23:If(LookUp(AddendumChoice,FalseID=1,PassFail)=true,"Pass","Fail"),
ID24:If(LookUp(AddendumChoice,FalseID=1,PassFail)=true,"Pass","Fail"),
ID25:If(LookUp(AddendumChoice,FalseID=1,PassFail)=true,"Pass","Fail"),
ID26:If(LookUp(AddendumChoice,FalseID=1,PassFail)=true,"Pass","Fail")
}
),
NotesVar,
Text(Now(),DateTimeFormat.ShortDate),
Switch(
loggedinVar.DISPLAYNAME,
Blank(),
First(LastN(Split(loggedinVar.Title,","),1)).Result&" "&Last(FirstN(Split(loggedinVar.Title,","),1)).Result,
First(LastN(Split(loggedinVar.DISPLAYNAME,","),1)).Result&" "&Last(FirstN(Split(loggedinVar.DISPLAYNAME,","),1)).Result
),
loggedinVar.EmployeeSSO,
Text(Now(),"yyyy/mmmm/dd"),
Concatenate(Upper(Text(Now(),"ddmmmyyyy"))," - ",First(AddendumChoice).Venue),
venueType,
First(AddendumChoice).Venue,
{file:First(SignatureCapture)})
Above is an example of a PA Run I launch form within my own powerapps, it has several lookups
-See Randy's answer below, misread
Yes, the LookUp works fine as a parameter for the Run action.
I hope this is helpful for you.
User | Count |
---|---|
253 | |
106 | |
94 | |
50 | |
39 |