ForAll(DataCardValue.SelectedItems, Patch( - how to use

(0) Share

Report

Posted on by Bingqiling

321

Asset Table	Application Table
ID	search type(Asset Table's ID) <- cocheckvalue's Text data
Asset Status (choice type)

I have 2 tables in SharePoint.
The data in the text column of the cocheckvalue collection is put into a multi-selection query column.
I need to find the ID of this cocheck value and change the option of asset status in asset table.
I need a code to change the asset status option in this asset table to "Determined" when subsit to the OnSuccess function in the form.
Please help me.

/*ForAll(
 DataCardValue13.SelectedItems,
 Patch(
 ITAM_asset,
 Defaults(ITAM_asset),
 LookUp(
 ITAM_asset,
 Id = colcheckvalue.Text
 ),
 { asset_status: {Value:"결재중"} }
 )
);*/
Patch(
 ITAM_asset,
	ForAll(
		colcheckvalue, //[myListGallery_4].AllItems As _item,
		{ asset_status: {Value:"결재중"} }
 )
);

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Bingqiling ,

I would recommend considering this formula.

UpdateIf( ITAM_asset, Id in DataCardValue13.SelectedItems.IdColumn, {asset_status:{Value:"결재중"}} )

I think this link will help you a lot:

https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-update-updateif

Best Regards,
Bof

Was this reply helpful? Yes No