
Announcements
Hi,
Currently, I am using PowerApps + SharePoint List to build a form with one field and a submit button but I am unsuccessful in doing so.
Here is the requirement:
User has an excel file with 75000+ records with a single column called "PromoCodes". Requirement is to build a form with a drop down field. This drop down needs to show only a single promo code i.e., one promo code per submitter. The promo code used by the submitter needs to be deleted once after the form is submitted in the background. I have already had knowledge in using Flow to delete the selected promo code from excel data. But my struggle is to show or fetch the promo code from the data source on to the Form.
Please suggest a possible approach. Thank you in advance.
Note: I tried exporting excel data to SharePoint List but it is unsuccessful as the records are large in number.
Hi,
have a look into the below-mentioned URL.
https://www.youtube.com/watch?v=0PLznP64O9o
Hope this will help you regarding your Issue.
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."