web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Logging in Data to Sha...
Power Apps
Unanswered

Logging in Data to SharePoint - Error Formula!

(0) ShareShare
ReportReport
Posted on by 231

Hello All

 

I created a "Point of Contact List" in SharePoint, then I created the Gallery in PowerApps, In the same page there is a label that has a lblresult however the result message is not in the SharePoint.

 

Also I created in SharePoint a List name "Back to Work Eligibility" it has Title, Check-In Date, Next Check in Date, Employee and Result

 

 In the Confirm Button

I wrote 

Patch(
'Back to Work Eligibility',
Defaults('Back to Work Eligibility'),
{
Title: "Status from " & User().FullName & " on " & Now(),
'Check-In Date': Now(),
'Result': {Value: lblResult},
'Next Check-In Date': DateAdd(
Now(),
Value(varCheckInDays),
Days
),
Employee: {
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Claims: "i:0#.f|membership|" & Lower(Office365Users.MyProfile().Mail),
Department: Office365Users.MyProfile().Department,
DisplayName: Office365Users.MyProfile().Mail,
Email: Office365Users.MyProfile().Mail,
JobTitle: Office365Users.MyProfile().JobTitle,
Picture: ""
}
}
);

 

the 'Result': {Value: lblResult}, Giving me error. Also all the data are logged in into the "Back to Work Eligibility' in SharePoint but not the lblResult. Also I want to add the Point of contact that the employee is assigned to or click on his/her name.

 

Is this possible? 

Can I create for every "Point of Contact" a dashboard the employee Result that clicked his/her name?

Hopefully I explained right. Thanks in Advance, much appreciated. 

Categories:
I have the same question (0)
  • Verified answer
    timl Profile Picture
    36,319 Super User 2025 Season 2 on at
    Re: Logging in Data to SharePoint - Error Formula!

    Hi @lolla70 

    If your lblResult label is showing the correct value, this could be a simple case of referencing the text property of the label. (eg) you would change the section of code that you highlighted to this:

     

     

    'Result': {Value: lblResult.Text},

     

    If the result field in your SharePoint list is just a text field, this may work:

     

    'Result': lblResult.Text,

     

     

     

     

     

  • LA-27081519-0 Profile Picture
    231 on at
    Re: Logging in Data to SharePoint - Error Formula!

    Hi 

    I tried too and it didn't work. Any other fix?

  • timl Profile Picture
    36,319 Super User 2025 Season 2 on at
    Re: Logging in Data to SharePoint - Error Formula!

    @lolla70 

    What's the exact error message that you get?

  • LA-27081519-0 Profile Picture
    231 on at
    Re: Logging in Data to SharePoint - Error Formula!

    Patch(
    'Back to Work Eligibility',
    Defaults('Back to Work Eligibility'),
    {
    Title: "Status from " & User().FullName & " on " & Now(),
    'Check-In Date': Now(),
    'Result': {Value: lblResult.Text},
    'Next Check-In Date': DateAdd(
    Now(),
    Value(varCheckInDays),
    Days
    ),
    Employee: {
    '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
    Claims: "i:0#.f|membership|" & Lower(Office365Users.MyProfile().Mail),
    Department: Office365Users.MyProfile().Department,
    DisplayName: Office365Users.MyProfile().Mail,
    Email: Office365Users.MyProfile().Mail,
    JobTitle: Office365Users.MyProfile().JobTitle,
    Picture: ""
    }
    }
    );

     

    It all turned to red and not sure why?

  • LA-27081519-0 Profile Picture
    231 on at
    Re: Logging in Data to SharePoint - Error Formula!
  • Verified answer
    LA-27081519-0 Profile Picture
    231 on at
    Re: Logging in Data to SharePoint - Error Formula!

    I fixed it,

    I removed the value and typed like this and it worked. Thank you so much

    'Result': lblResult_2.Text,

  • LA-27081519-0 Profile Picture
    231 on at
    Re: Logging in Data to SharePoint - Error Formula!

    Hi @Timi 

     

    For the second part of my question

    I want to add the Point of contact that the employee's click on his/her name to the Share Point List? Do you have any idea on how to add them.

    I created a column in the 'Back to Work Eligibility' - named it POC Name

     

    Also I created in the SharePoint a Point of Contact List - POC Name, Location, and Email.

  • LA-27081519-0 Profile Picture
    231 on at
    Re: Logging in Data to SharePoint - Error Formula!

    NVR mind I think I fixed it. Thanks

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 757 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 322 Super User 2025 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 209 Super User 2025 Season 2

Last 30 days Overall leaderboard