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 Apps - Building Power Apps
Answered

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. 

I have the same question (0)
  • Verified answer
    timl Profile Picture
    35,805 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
    35,805 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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 629 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 397 Super User 2025 Season 2

#3
wolenberg_ Profile Picture

wolenberg_ 232 Moderator

Last 30 days Overall leaderboard