Answered

Submitting form on power apps is updating a field in SharePoint list

(0) Share

Report

Posted on by rishimarde

Hi ,

I am quite new to Power Apps and facing a problem that the field in a SharePoint list is got getting updated through Power apps.

as you can see that I have used 'Office365-Benutzer'.SearchUser({searchTerm:Label3.Text}) for default select item but when submit the for it does not get reflected on SP list

an when I remove the 'Office365-Benutzer'.SearchUser({searchTerm:Label3.Text}) , manually search the user and then save the form the field gets updated

what could be the Problem?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

v-yujincui-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @rishimarde ,

Select the Combo Box Control and try to apply the following formula on its DefaultSelectedItems property as:
If(!IsBlank(DataCardValue1.Text), { '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", Claims: "i:0#.f|membership|" & First(Office365Users.SearchUserV2({searchTerm:DataCardValue1.Text}).value).Mail, Department: "", DisplayName: First(Office365Users.SearchUserV2({searchTerm:DataCardValue1.Text}).value).DisplayName, Email: First(Office365Users.SearchUserV2({searchTerm:DataCardValue1.Text}).value).Mail, JobTitle: "", Picture: "" } )
The following formula should work for your app:
If(!IsBlank(Label3.Text), { '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", Claims: "i:0#.f|membership|" & First('Office365-Benutzer'.SearchUserV2({searchTerm:Label3.Text}).value).Mail, Department: "", DisplayName: First('Office365-Benutzer'.SearchUserV2({searchTerm:Label3.Text}).value).DisplayName, Email: First('Office365-Benutzer'.SearchUserV2({searchTerm:Label3.Text}).value).Mail, JobTitle: "", Picture: "" } )

Best Regards,
Charlie Choi

Was this reply helpful? Yes No
rishimarde 46 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi thanks for the reply but I have figured this out by other way. It works right now. please let me know if its right.

Was this reply helpful? Yes No
v-yujincui-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @rishimarde ,

Glad to see you solved the problem. If it works fine, it's no problem.
In addition, you could mark your reply or mine as a 'solution' to close the case.

Best Regards,
Charlie Choi

Was this reply helpful? Yes No