Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
hi,
say I have a table with 3 records. A column containing 'ID', and 3 rows.
ID |
12345 |
56789 |
10112 |
is it possible to automatically create a page with each of these in a card on them?
issue is that these ID's can change each month. Ie next month may have id '22222' in addition to the previous 3.
I was thinking of power automate, but please let me know if you have any suggestions.
thanks.
Solved! Go to Solution.
So yes, you can filter each page with an Index so that if the ID changes it still have the new ID value. If you have alot then you have to go through each page.
Also you can just create everything on one page and just have a dropdown where the users selects the ID, think this much cleaner.
Hi @wonka1234,
Thank you for reaching out in Microsoft Community Forum.
Thank you @Bmejia for the helpful response.
As suggested by Bmejia, I hope this information was helpful. Please let me know if you have any further questions or you'd like to discuss this further. If this answers your question, please "Accept as Solution" and give it a 'Kudos' so others can find it easily.
Please continue using Microsoft community forum.
Regards,
Pavan.
@Bmejia I wan tto create a page of each of my IDs.
next month, do the same thing, create a page for each of my IDs.
Each page must have a card or table showing the ID.
So yes, you can filter each page with an Index so that if the ID changes it still have the new ID value. If you have alot then you have to go through each page.
Also you can just create everything on one page and just have a dropdown where the users selects the ID, think this much cleaner.
thanks! this makes sense.
What are your thoughts on having users wanting to fill out text , lets say in a text box in each page?
They users can not fill a text box but you can create dynamic tittles so when they choose a ID. They know what they are looking at.
Simple example like this
I am not sure that I understand fully what you are trying to do , but the Page names can not be dynamically rename base on your ID or anythig else, what you can do is add and Index column to the ID list and filter each page by the each index. make sure that you sort the table asc or desc so that at least there is an order to it.
User | Count |
---|---|
84 | |
76 | |
74 | |
48 | |
39 |
User | Count |
---|---|
114 | |
56 | |
51 | |
42 | |
42 |