Run function in power apps

(0) Share

Report

Posted on by wildchang

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

TheRobRush 11,128 Moderator on at

Like (0)

Report
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

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (1)

Report

@wildchang

Yes, the LookUp works fine as a parameter for the Run action.

I hope this is helpful for you.

Was this reply helpful? Yes No