Announcements
I am pulling information with the AI builder from Power BI pdfs. My IF statement will update the rows that already exist, but will continue to add duplicate rows. Some of the rows have the same project name, but different titles.
@JB_work Before add row you should check whether your excel is having that row or not. Use length(). if this is zero then add row otherwise update row.
Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.
@Hardesh /Gopenly.in
Unfortunately, that didn't work. It read everything as false. I was going to try to compare the length of substrings, but I can't figure out how to get just the output of the AI data substring.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Mohsin Ali 426
11manish 345 Super User 2026 Season 2
M Bilal Khan 308
