Power Platform Community Forum Thread Details

Hi,

I am using customized PowerApps form for SPList_1 to display PromoCodes from another list called PromoCodesList.

Below is the screenshot of my form : View Promo Code button gets enabled after the required field called KioskID is entered. When users click on view promo code button, screen navigates to a Label field that displays the PromoCode. View Promo Code button has the submit button functionality.

Formulas: 

 OnStart : 

Set(promoCode,
First(Shuffle(Filter(PromoCodesList, IsSelected="No")))
);
UpdateIf(PromoCodesList, ID=promoCode.ID, {IsSelected:"Yes"})



 OnSelect of View Promo Code button :

SubmitForm(SharePointForm1);Navigate(ThankyouScreen,ScreenTransition.None)



Text Property of Label on Thankyou Screen :

DataCardValue1



Also the Promo Code field is hidden but it is there is in the form whose default property is set to promoCode.Transaction Code. (Transaction Code is field name in the lookup list i.e., Promo Codes List)

The issue is : When users clicks on View Promo Code button, users are surely(100%) showing with a Promo Code but 2(or 3)/100 items that are getting submitted to SPList_1 are showing with empty Promo Code field value! I wonder why!

Need your help!

Categories:

Building Power Apps