web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Reference value from s...

Power Apps

Answered

Reference value from source

(0) Share

Report

Report

Posted on by drossi90

188

I have a connection to Salesforce where I'm pulling Jobs from.

User can then open a specific job via a gallery:

This then pulls all that record info using the Job_Code_c record to open a new page on the app

What I then want to do is via a Save button OnSelect is Patch that Order value and Job_Code__c number to a SP List

I have written:

Set(varRecordID, Patch(BoilerQuotes, Defaults(BoilerQuotes), {Title:LookUp(Jobs,'Job Code' = selectedId), OrderTotal:Sum(colQuote,SubTotal)}).ID)

But it doesn't work. the bit I am stuck at is how do I pull the Job_Code__c value from the record?

Categories:

Building Power Apps

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi,
When you use LookUp, it will give you a record with all details (column values). In your formula you will have to use a column name which you want to save in Sharepoint list Title column (ColumnNameFromJobs)
Set(varRecordID, Patch(BoilerQuotes, Defaults(BoilerQuotes), {Title: LookUp(Jobs,'Job Code' = selectedId).ColumnNameFromJobs, OrderTotal:Sum(colQuote,SubTotal)}).ID)

Join the conversation