I would really appreciate help in regards to figuring out the below solution.
We have created a travel approval form which writes data to SharePoint list and triggers a workflow approval process. We are trying to implement a screen to retrieve an old request from the sharepoint list based on their user name to resubmit a new form based on the details already used in old form to make it easier for users .Often people will travel to the same place therefore if the fields were automatically filled with previous information the only changes required would be dates/times would make the process effecient . Can powerapps provide this solution ?
That is a good idea for user experience.
We could first create a collection when App starts, with the Onvisibe property of the landing screen, to get the SharePoint list items created by the current user.
Formula should be:
clearcollect(CurrentData, filter(SharePointLists, Author.Email=User().Email))
Then add dropdown control to replace the TextInput in the Edit Form control, with the following formula under items property of dropdown:
Doing it in this way would allow the submitted place being listed in the dropdown as available choices.
After that, change the Update property of the Corresponding Data Card to:
I need to retrieve the data from the old submitted forms which i believe cant be done using the collect function . I did try to use the app but looks like it doesnt seem to be able to populate the data once the user picks the name . Not sure what i am doing wrong ?
Hi Guys ,
Need Help for my powerapp
i have crated visitor registration app i wnt to know how i get old user details as a new record
EX: i put user NIC ID i wnt to auto fill previous User data that fealds from sharepoint list.
Need your help!
Check out these cool Power Apps & vote on your favorite!
Check out whats happening in Power Apps
FIll out a quick form to claim your community user group member badge today!
Features releasing from October 2020 through March 2021