cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
iwonder
Post Prodigy
Post Prodigy

Update a Yes No field in SharePoint List from Excel file

Thank you for taking the time to read my question.

 

I have a SharePoint list that I want to add some data to from an Excel file that has a data table. The list has 3 fields: Title, ProductName, IsActive.

 

In my flow I can add the Title values and the ProductName values but I can't seem to figure out how to add the IsActive value. I don't want it to be all Yes or all No, I need the value in the Excel file. I tried clicking on Enter custom value but don't understand what I need to do to get the IsActive value from Excel

 

iwonder_0-1618603238761.png

any help would be great.

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
iwonder
Post Prodigy
Post Prodigy

I created a variable and set the IsActive value to the variable vIsActive. Then I added the new variable to the Create Item.

 

iwonder_0-1618608296113.png

iwonder_1-1618608334026.png

 

That worked for me. Not sure if that's the right way but it's working

 

Thanks

View solution in original post

1 REPLY 1
iwonder
Post Prodigy
Post Prodigy

I created a variable and set the IsActive value to the variable vIsActive. Then I added the new variable to the Create Item.

 

iwonder_0-1618608296113.png

iwonder_1-1618608334026.png

 

That worked for me. Not sure if that's the right way but it's working

 

Thanks

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (2,519)