cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ChrisC
Kudo Kingpin
Kudo Kingpin

Dynamic Content from another piece of dynamic content

Hello everybody,

 

I have a flow which observes a Sharepoint list for changes. It checks for new items to be added and looks at two text fields in the new item. One item is moved along as plain text, but the other is the name of another list on the Sharepoint site. Here is an image of that process.

 

Get Items.png

 

My problem is on the next step. Since I am adding the list name through a dynamic content, it does not actually give me access to anything within that contact list (of course because it does not know what will be there yet). But, since I do know what fields would be present in that list, shouldn't there be a way that I can add it manually? Just to be clear, the fields name is Business%20Phone. Something like "GetItems.ContactList.Business%20Phone"? I can't seem to get it working.

 

Dynamic Content.png

 

 

Thanks for any help. I hope I explained it well enough

1 ACCEPTED SOLUTION

Accepted Solutions
ChrisC
Kudo Kingpin
Kudo Kingpin

I actually just figured out that you can trick it.

 

Where the "Contact List" variable is, enter in a known list name that you want to use. Once that list has its contents added to dynamic content, place it into the position in the flow you wish it to go (in my case in the 'To Phone Number' field). 

 

After it is entered, remove your temporary list name and add the dynamic content name and save quickly, before it can correct itself. After saving, it won't correct itself but loading it again you will notice the dynamic content has renamed itself to some nonsense, but it will still work.

 

The downside is that every time you need to edit anything else on the list, you need to redo this trick every time.

View solution in original post

2 REPLIES 2
ChrisC
Kudo Kingpin
Kudo Kingpin

I actually just figured out that you can trick it.

 

Where the "Contact List" variable is, enter in a known list name that you want to use. Once that list has its contents added to dynamic content, place it into the position in the flow you wish it to go (in my case in the 'To Phone Number' field). 

 

After it is entered, remove your temporary list name and add the dynamic content name and save quickly, before it can correct itself. After saving, it won't correct itself but loading it again you will notice the dynamic content has renamed itself to some nonsense, but it will still work.

 

The downside is that every time you need to edit anything else on the list, you need to redo this trick every time.

SameerCh
Power Automate
Power Automate

In general this pattern doesnt work in Flow today.

 

There are coupele of issues (I think).

 

First, the dropdown for List name in SharePoint's "Get items" may not actually be sending the name -- but rather an "ID" of the List that you select from the dropdown.  The designer UI shows the List name, but what it does behind the scene is that it calls "Get Tables" and shows you the list.  It uses the "Display Name" to show in the dropdown but uses the "Name" field.  And they are probably not the same -- need to check.

 

Second, as you correctly identified, the designer cannot get you the schema/columns for the List since it doesnt know which List you are going to use.

 

Finally, we have an issue in the designer today, which prevents using array outputs (from SharePoint Get Items) with any action that outputs an object that contains an array (like Twilio Send Message).

 

Unfortunately, I dont know of any workaround.  But, this is something that we should probably address.

Logic Apps is probably an alternative, but you will have to go into advanced editor there as well.

 

 

 

 

Helpful resources

Announcements
October Events

Mark Your Calendars

So many events happening this month - don't miss out!

 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Users online (1,993)