Answered

Updating Context Value from SharePoint List Value in OnVisible

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I currently have a few datacards on my View and Edit forms that hide if a value on SharePoint is edited on the form. When the EscalateS2 field on SharePoint is changed to YES (Control is a Toggle on the form and the SharePoint List field is a YES/NO type. I have been controlling this with the Context of "s2Visible"

The toggle is set to OnCheck run: UpdateContext({s2Visible: true})

and OnUncheck it runs: UpdateContext({s2Visible: false})

However I've not been able to figure out how to make it check the field when the form is loaded from scratch so it only retains from previous sessions causing UI issues.

I had tried added the following to the Screen's "OnVisible" to try and update the Context instantly on load

If('SHAREPOINTLIST'.EscalateS2="Yes",UpdateContext({s2Visible: true}),UpdateContext({s2Visible: false}))

However this fails with a "Invalid Argument Type" error message, so I think I'm messing up the coding, any ideas?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

LRVinNC 2,297 on at

Like
a
(2)

Report
Copy link

Link copied!

You need to check your toggle's setting using true/false, not "YES"/"NO". The toggle is actually saved as a boolean.

If('SHAREPOINTLIST'.EscalateS2=true,UpdateContext({s2Visible: true}),UpdateContext({s2Visible: false}))

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for the advice, sadly though when amending it to that code I still get "Invalid Argument" errors when putting that in the OnVisible properties of the screen, should this go elsewhere or would there be a better way to check a field for a value and update the context when the form is loaded?

Kind Regards

Was this reply helpful? Yes No
panand99 641 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous
Use this -

If('SHAREPOINTLIST'.EscalateS2<>true,UpdateContext({s2Visible: true}),UpdateContext({s2Visible: false}))

hope this helps

Thanks,
Prashant

please mark this accepted if it fulfill your requirement

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Sadly this is giving the same error code message as well.

Is there an alternative way of having the form check a YES/NO value from the selected SharePoint item then updating the context accordingly when the form is loaded?

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Solved it, I replaced 'SharepointList.EscalateS2' with 'SharePointIntegration.Selected.EscalateS2' and now it works!
So the final code was

If(SharePointIntegration.Selected.EscalateS2=true,UpdateContext({s2Visible: true}),UpdateContext({s2Visible: false}))

Thank you all for your help!

Was this reply helpful? Yes No