web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Run function in power ...

Power Apps

Unanswered

Run function in power apps

(0) Share

Report

Report

Posted on by wildchang

16

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 Img

All responses (2)

Answers Img

Answers (0)

Sort by

TheRobRush 11,128 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
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,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@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

Join the conversation