When we open a PowerApps form it uses Dynamics 365. How can I use a link to open a specific SharePoint list ID?
Solved! Go to Solution.
Hi @Anonymous,
I have a list called "ListList". I added a dropdown control, and set its Items property to
ListList.ID
The dropdown control shows empty value. So I think PowerApps cannot read the ID of the items from SharePoint list.
But once I change the Items property of the dropdown to:
ListList.Column1
The list shows the Column1 from the data source.
Insert a display form. Set the DataSource property of the form to ListList and the Item property of the form to this formula:
First(Filter(ListList, Column1=Dropdown1.Selected.Value))
This formula specifies that, after you finish configuring the form, it will show the record that the user selects in Dropdown1 control.
Please have a test.
For your reference:
https://docs.microsoft.com/en-us/powerapps/add-form
Regards,
Mona
Hi @Anonymous,
I have a list called "ListList". I added a dropdown control, and set its Items property to
ListList.ID
The dropdown control shows empty value. So I think PowerApps cannot read the ID of the items from SharePoint list.
But once I change the Items property of the dropdown to:
ListList.Column1
The list shows the Column1 from the data source.
Insert a display form. Set the DataSource property of the form to ListList and the Item property of the form to this formula:
First(Filter(ListList, Column1=Dropdown1.Selected.Value))
This formula specifies that, after you finish configuring the form, it will show the record that the user selects in Dropdown1 control.
Please have a test.
For your reference:
https://docs.microsoft.com/en-us/powerapps/add-form
Regards,
Mona
Hello @v-monli-msft
I am trying to achieve this with this formula
ID=Form1.LastSubmit.ID
I am using the last submitted ID of the form, but its not populating the data.
Can u confirm this??
Thank you for this! I did get it to work with ID, simply make sure ID field is in your form before trying. I ended up with: First(Filter('Meeting Requests',ID=59)). After creating a variable for the ID number, I can open the app based on an ID variable in a query string: First(Filter('Meeting Requests',ID=varID))
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.
User | Count |
---|---|
204 | |
106 | |
56 | |
52 | |
41 |
User | Count |
---|---|
274 | |
156 | |
86 | |
81 | |
56 |