Patch Text column from Collection into Choice Column in Table

(0) Share

Report

Posted on by ashokpershad

321

I have a Dataverse Table with Lookup Column of Person Name form another Table.

I am using powerapps to create new data which I am storing in a collection with all fields matching Dataverse Table but this time everything in Text format. Now I want to Patch collection data into Dataverse table. What should be right patching format for Lookup Column and Date Columns.

Thanks in Advance

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Ram Prakash Duraisamy 5,580 Super User 2025 Season 2 on at

Like (1)

Report
Hello @ashokpershad,

You Can easily path Lookup Column in DataVerse using below code

Patch(TABLENAME,Defaults(TABLENAME),{Name:"11",LOOKUPFIELDNAME:LookUp(DESINATIONLOOKUP,'DESTINATIONName'="COLLECTIONLOOKUPNAME") })

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

Was this reply helpful? Yes No
ashokpershad 321 on at

Like (0)

Report
@rampprakash Thanks for your Answer but it is not working.
Let me try to explain in detail:
I have one Table in Dataverse (Manhours) with following columns:

Now I used one FORM for this table. When I press one submit button after filling details in this form I am creating one collection (displayed in Gallery5) too where I am storing all FORM submit entries. Please note this Submit button actually not for SUBMITFORM function.
Gallery5:
Now I want to Patch this Gallery back to my Dataverse Table using this ForAll and Patch functions.
I used Following Formula:

ForAll(Gallery5.AllItems, Patch(Manhours, Defaults(Manhours), {WOrder:glry5WO.Text, 'Lab Supervisor':LookUp(Manhours, 'Lab Supervisor'.Supervisor = glry5Sup.Text), 'Service Engineer': LookUp(Manhours, 'Service Engineer'.'Engineer Name' = glry5eng.Text), 'Date Started':glry5DS, 'Date Completed': glry5DE, 'Actual Work Hours': glry5AH.Text, Remarks: glry5Remarks.Text}))

But this formula is showing following error:

What formula shall I use?

I hope now its clear.

Was this reply helpful? Yes No