Answered

Patch 2 Forms

(0) Share

Report

Posted on by buzzen

Hi,

I have a form with some fields (Form3) and in the top right corner I've created another "FormViewer" (FormViewer1) to display information like "Requestor" and the "Office Location".

Now with the save button I'd like to store the informations from both Forms in the same record.

First I wanted to try it like this:

Patch('listname', Defaults('listname'), Form3.Updates, FormViewer1.Updates)

But FormViewer does not have the option ".Updates". So I tried it like this:

Patch('listname', Defaults('listname'), Form3.Updates, {Requestor: DataCardValue26, Office: DataCardValue27})

This one stores the infos from Form3 but nothing else. How can I include the info

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (1)

Sort by

zmansuri 6,048 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

{Requestor: DataCardValue26, Office: DataCardValue27}

You are mentioning control names. You need to mention properties too. Like DataCardValue26.Text or DataCardValue26.Value. Depends on whatever schema you have for your list

Was this reply helpful? Yes No
buzzen 80 on at

Like
a
(0)

Report
Copy link

Link copied!

Many thanks for your quick reply... Thanks this worked for the Office location with "DataCardValue27.Text".
But the Requestor field is in SP a "Person or Group" field. And here it always says:
"The type of this argument 'Requestor' does not match the expected type 'Record'. Found type 'Text'"
and also I've added this to the end ";NewForm(Form3)", but once saved it doesn't load a new form.

Was this reply helpful? Yes No
zmansuri 6,048 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

patching a person type field is complicated you need specific schema like this:

{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Claims:"i:0#.f|membership|" & User().Email,
Department:"",
DisplayName:User().FullName,
Email:User().Email,
JobTitle:"",
Picture:""
}

change this User().Email to wherever you are getting your email id's from.
This is a specific structure required to patch a person type column. Even though claims is the only thing which is important here. You still need to write all this.

Was this reply helpful? Yes No
buzzen 80 on at

Like
a
(0)

Report
Copy link

Link copied!

Yeah looks really complicated... Don't know how to exactly implement that into my patch command....

Do you also now why it doesn't load a NewForm?

Was this reply helpful? Yes No
Verified answer

zmansuri 6,048 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

There is also another way and better practice too. Take a text type column instead of person type column. In the combobox item property where you select person. Set office365user connector. Then in your patch code you can just save the display name that text column.

And if you want to use your current patch code you can integrate it here
{Requestor:
{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Claims:"i:0#.f|membership|" & DataCardValue26.Selected.Email,
Department:"",
DisplayName:DataCardValue26.Selected.DisplayName,
Email:DataCardValue26.Selected.Email,
JobTitle:"",
Picture:""
},Office: DataCardValue27.Text})

Was this reply helpful? Yes No
buzzen 80 on at

Like
a
(0)

Report
Copy link

Link copied!

Yeah when I use a SP Text field it works with "DataCardValue26.Selected.DisplayName".
But with the SP People field and your code "...DataCardValue26.Selected.Email..." it says when saving:
The specified user i:0#.f|membership| could not be found.
Quite strange...

Was this reply helpful? Yes No
zmansuri 6,048 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Claims:"i:0#.f|membership|"abc@gmail.com
The above should be format of claims to store in person type field. So set your code according to attach email id with it

Claims:"i:0#.f|membership|" & DataCardValue26.Selected.Email,

Was this reply helpful? Yes No
buzzen 80 on at

Like
a
(0)

Report
Copy link

Link copied!

yeah I did it exactly how your wrote it... and the App itself doesn't show an issue with the function... But it still doesn't work... I have the feeling that my whole User Profile setup is wrong.. despite it shows the correct data. Not quite sure if it has something to do with the Data source dependency from the DataCardValue26 field....

Was this reply helpful? Yes No
zmansuri 6,048 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

I usually avoid complex type columns especially person type. Instead i take 3 text columns and store person's name email and phone it from office365user connector. So no delegation issues plus easy to filter and reference

Was this reply helpful? Yes No
buzzen 80 on at

Like
a
(1)

Report
Copy link

Link copied!

Many thanks for your support... In the end I was able to achieve what I wanted!
THANKS!

Was this reply helpful? Yes No