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 @msmith,
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 @msmith,
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))
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
214 | |
204 | |
84 | |
59 | |
38 |