Can you please show full steps by steps? From list to creating app, type of app sharepoint integration or not,List definition to steps taken in the form itself.
Also point out field definitions are they dropdowns or not in PowerApps, and in SharePoint list settings what's the column types? Are they single texts or multi line etc?
I am having a hard time trying to do the same and I am specifically trying to autopopulate only one field based of a multiple choice list in SharePoint.
If anyone else show with screenshots even better!
I do not have the time to go into the detail you want, but can give you the steps that should help you.
1. You create a list in Sharepoint, and then let Powerapp generate a form based on it (in Powerapps insert Form Edit and connect it to the Sharepoint List so Powerapps generates the Datacards.
2. Change the form's FormMode from New to Edit.
3. In the OnStart Attribute for the Screen, set a command format: Set(Recordlookup,Param("List_ID"))
Where Recordlookup is a variable we are setting here to identify the line for the form.
And List_ID is a string to identify the line and feed it to the form. More later.
4. Now select your form and for the Item Attribute enter: LookUp('MyList', ID=Recordlookup)
Where MyList if the Sharepoint List.
5. Now get the URL for your Powerapp, and launch it using the URL:
Where the address/URL is PowerAppsURL
And Number is the ID (1,2,3 etc) of the record you want to populate the form on opening.
I used flow to trigger my workflow that was triggered by a new record in the list. This allowed me in an email to recipient to include the PowerAppsURL?List_ID=Number address in the email with the ID variable being use to provide the correct address.
Hope this helps.
The app should open with the record with ID that matches the
By seeing ur post i manage also to open the power app pre-populated with a sharepoint list item . I have one status field in list . If its "Draft" we can able to create/edit the stuff from power app but if its "Under process" or "Approved" we want to make fields disable for the user. How can i check ??
You can do this by putting an IF statement into the Required property of the DataCard, if 'Draft' the True, 'Under Proces' or 'Approved' then false.
Syntax covered here:
I have followed this to the letter and cannot get it to work. Does anyone know of any more recent posts to do the same thing. Completely stuck with this.
Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.
Check out the winners of the recent 'Can You Solve These?' community challenge!
Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.
Featuring samples like Return to the Workplace and Emergency Response Applications
Features releasing from October 2020 through March 2021