Repeating Table in PowerApps - Similar to InfoPath Form | Gallery | PowerApps | Power Platform

Power UP with Sarvesh
Power UP with Sarvesh
33.3 هزار بار بازدید - 5 سال پیش - In this video we will
In this video we will see how to create repeating table in PowerApps, same as InfoPath Form.

CODE SNIPPET

Combine table data into one string variable ----

Set(AllItemsString,Concat(GalleryRepeatingTable.AllItems,Concatenate(ItemSerialNumber.Text,";",VisitorName.Text,";",VisitorPhoneNumber.Text,";",VisitorEmail.Text,";",VisitorCity.Text,"|")))

------
Add new row in Gallery ----

Collect(CollItems,{CItemSerialNumber: Text(Last(CollItems).CItemSerialNumber + 1) ,CVisitorName:"",CVisitorPhone:"",CVisitorEmail:"",CVisitorCity:""})
-------

Remove Row from Gallery -----

RemoveIf(CollItems,CItemSerialNumber = ThisItem.CItemSerialNumber)
----

Pull data and generate collection object -----

Clear(CollItems);
Set(AllItemsString,Left(AllItemsString, Len(AllItemsString)-1));
ForAll(Split(AllItemsString,"|"),
Collect(CollItems,
{CItemSerialNumber: Text(Last(FirstN(Split(Result,";").Result,1).Result).Result),
CVisitorName:Text(Last(FirstN(Split(Result,";").Result,2).Result).Result),
CVisitorPhone:Text(Last(FirstN(Split(Result,";").Result,3).Result).Result),
CVisitorEmail:Text(Last(FirstN(Split(Result,";").Result,4).Result).Result),
CVisitorCity:Text(Last(FirstN(Split(Result,";").Result,5).Result).Result)}))
----------------------------------------------------------------------------------------------------------------

PowerApps Learning Playlist - PowerApps Learning

Check out my articles and blogs on
https://www.c-sharpcorner.com/members...

#powerapps #sharepoint #powerplatform
5 سال پیش در تاریخ 1398/05/11 منتشر شده است.
33,333 بـار بازدید شده
... بیشتر