Hi All,
I am new to Power Apps and would really like your help with this. I have been reading some posts about it but still not able to apply it to my solution.
I am doing a visitor registration app, which was working fine until I started to get feedback on how to improve it. last thing I am stuck on is having the app to populate the location automatically without asking the user to chose it.
the Location Column is in a SharePoint list with Choice option, and in the PowerApps, I had a location_DataCard that allows the user to chose location and populate SharePoint with the submit button along with other fields (like name and person visiting)
My setup is done with a special user hosted on a Tablet that people use to register. So I found that I can by default assign a location of the user who signed in (information taken from the profile in Office 365)
Default = Office365Users.UserProfile(User().Email).OfficeLocation
Now my issue is how to integrate this formula in my setup and make it appear in sharePoint. so I want to get rid of the Choice Option and have the Default location appearing in SharePoint instead in the Location Column.
the Location information is used in 2 forms, one in the Edit From and in the Detailed Screen Form.
In the future I will have 5 tablets each with its own specific user and location set in their profile. so whenever a tablet is used in the location, the location appears automatically in SharePoint list.
hope this makes sense and looking forward for your feedback. thanks
PS: Attached is how my Datacard looks now and the apps forms.

Report
All responses (
Answers (