Using patch with boolean values - Expected type 'Boolean'. Found type 'Record'

(0) Share

Report

Posted on by Community Power Pla...

Hi,

I am using a patch function to update a Sharepoint List using a PowerApps form but I am getting an issue with my Yes/No columns (The Column Type is Yes/No in sharepoint Lists). I have put an if statement to try andn solve this but it is not working.

ForAll(
 Split(DataCardValue2.Text, "," ),
 Patch(
 'Walkdown Requests_1',
 Defaults('Walkdown Requests_1'),
 {
 'DAC No.': ThisRecord.Result,
 'Scope of works complete?': If(DataCardValue22.SelectedText= "Yes", true, false) 
 }
 )
)

I get the error Expected type 'Boolean'. Found type 'Record'

Thank you.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report
Hi @Anonymous ,

This should work

ForAll( Split(DataCardValue2.Text, "," ) As aPatch, Patch( 'Walkdown Requests_1', Defaults('Walkdown Requests_1'), { 'DAC No.': aPatch.Result, 'Scope of works complete?': DataCardValue22.Selected.Value= "Yes" } ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

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

Like (0)

Report

Thank you so much

Was this reply helpful? Yes No