News and Announcements icon

Power Platform CommunityForums Power Apps - Building Power Apps power apps SQL Query

Power Apps - Building Power Apps

Unanswered

power apps SQL Query

(0) Share

Report

Report

Posted on by SL-07111355-0

I'm trying to retrieve data on my list and store it on my form using this formular If(
previousSubmission.'TOTAL ROAD LENGTH' <> previousSubmission.'END POINT/KM',
Set(previousSubmission, LookUp('Internal Blading List', 'ROAD NUMBER' = previousSubmission.'ROAD NUMBER')),
Blank()) but no data is returned even if my condition is true

All responses Img

All responses (2)

Answers Img

Answers (0)

SL-07111355-0 on at

Like (0)

Report

Re: power apps SQL Query

doesn't work
Community Power Pla... on at

Like (0)

Report

Re: power apps SQL Query

Try using update instead of set

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Give Back to the Community this Month

Quick Links

Leaderboard

#1

WarrenBelz 143,591

#2

RandyHayes 76,308

#3

Pstork1 64,090

Leaderboard

Featured topics

Gallery Tabs - Show or Hide Tabs based on Field Value

How to patch multiple records at once

Enable Copilot for end users in model-driven apps

Product updates

Microsoft Power Platform Community release plans